mysql持续学习

/*php+apache+mysql单独配置*/
http://wenku.baidu.com/link?url=XF_7ug67dZreL0itsQxbVnvFQRZHLceqbS6MkKhwSATTnSJZy8YYr67r6B1GGa_NA49eiXVUrRJF_w1Yy0x7MGIe73aEzL_1ntlRYGfgHa3

进入bin目录

/*登录ROOT超级用户*/
/*在bin目录下输入*/
mysql -uroot -p
/*初始状态下密码为空,直接回车*/

/*创建新用户*/

GRANT USAGE ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
/*username和password分别为用户名和密码*/

/*为新用户授权*/
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON dbx.*  TO 'username'@'localhost' IDENTIFIED BY 'password';
/*username和password分别为用户名和密码*/
/*SELECT等等是权限*/
/*或者这样*/
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

/*刷新权限*/
FLUSH PRIVILEGES;

/*退出*/
exit

/*在bin目录下重新登录*/
/*sa为用户名*/
mysql -u sa -p