Tuesday, May 26, 2009

How to create new user on mysql using command line on windows

1. Quote : cd apache/mysql/bin

2. Quote : mysql -u root -p

3. Quote : use mysql;

4. Quote : create user modcert;

5. Quote : update user set password = PASSWORD('sqlpassword') where User = 'kunkun';

6. Quote : flush privileges;

7. Quote : grant select, insert, delete, update on database.* to 'kunkun'@'localhost' identified by 'sqlpassword';

8. Quote : flush privileges;

Enjoy ubuntu... ;)

No comments:

kunkun-laptop .... ;)