[thelist] setting up MySQL username/password on local host

Paul Bennett Paul.Bennett at wcc.govt.nz
Tue Jan 15 17:10:10 CST 2008


Hi Bruce,

I assume you already have a root account (username & password).

If so then create a database:
Create database `mydb`;

Then I usually add a user account by using the grant command:
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html

Let me know if you need any more help :)

Paul



More information about the thelist mailing list