GRANT USAGE ON *.* TO 'mydb'@'localhost' IDENTIFIED BY 'yourPassword';
GRANT ALL PRIVILEGES ON `mydb`.* TO 'mydb'@'localhost';
GRANT ALL PRIVILEGES ON `mydb`.* TO 'mydb'@'localhost';
调试欢乐多
shell> mysql -u root
mysql> use mysql;
mysql> INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'),
-> 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
mysql> FLUSH PRIVILEGES;
当然用grant语句也可以的。