Posted by larry on 05/11/07 17:49

On May 11, 10:39 am, harvey <harvey....@blueyonzders.com> wrote:


> Is there anything I can do to limit the problems of creating the database
> in PHP? I really don't want to try and get him to do anything manually.
>
> Thanks again.


Many programs have a "database setup" script that asks for the MySQL
root password and then creates the tables and users for the main
program to use later (the db 'user' it creates has limited
functionality so it cannot mess with other databases or create/delete
tables.) It never records the root PW, once the MySQL users and
tables are done it utilizes only the limited accounts it created.
(probably only requiring root PW later for major upgrades)

[Back to original message]