how do I create a MySQL user/account? I am running php/mysql under win7?
thanks a lot!!
- R.F.Lv 71 decade agoFavorite Answer
1. Log into MySQL as the "root" user.
2. Enter this statement:
GRANT ALL ON [db].* TO [user]@localhost IDENTIFIED BY '[password]';
[db] = the database name. For all databases, enter * so it looks this: *.*
[user] = the user name
[password] = the user password
For full details on how to add users to MySQL:
- dieterleLv 44 years ago