mysql -u root
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON *.*
TO mrliu@localhost
IDENTIFIED BY '123456';
mysql 密码设置与授权
简介：
mysql -u root
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON *.*
TO mrliu@localhost
IDENTIFIED BY '123456';
责任编辑：admin