Mysql 5.6添加修改用户名和密码的方法
先登录MySQL
shell>mysql--user=rootmysql
有密码的需要添加–password或-p选项
添加用户
mysql>CREATEUSER'finley'@'localhost'IDENTIFIEDBY'some_pass'; mysql>GRANTALLPRIVILEGESON*.*TO'finley'@'localhost'WITHGRANTOPTION; mysql>CREATEUSER'finley'@'%'IDENTIFIEDBY'some_pass'; mysql>GRANTALLPRIVILEGESON*.*TO'finley'@'%'WITHGRANTOPTION; mysql>CREATEUSER'admin'@'localhost'IDENTIFIEDBY'admin_pass'; mysql>GRANTRELOAD,PROCESSON*.*TO'admin'@'localhost'; mysql>CREATEUSER'dummy'@'localhost';
添加用户并设置数据库具体权限：
mysql>CREATEUSER'custom'@'localhost'IDENTIFIEDBY'obscure'; mysql>GRANTSELECT,INSERT,UPDATE,DELETE,CREATE,DROPONbankaccount.*TO'custom'@'localhost'; mysql>CREATEUSER'custom'@'host47.example.com'IDENTIFIEDBY'obscure'; mysql>GRANTSELECT,INSERT,UPDATE,DELETE,CREATE,DROPONexpenses.*TO'custom'@'host47.example.com'; mysql>CREATEUSER'custom'@'%.example.com'IDENTIFIEDBY'obscure'; mysql>GRANTSELECT,INSERT,UPDATE,DELETE,CREATE,DROPONcustomer.*TO'custom'@'%.example.com';
删除用户：
mysql>DROPUSER'jeffrey'@'localhost';
修改密码：
mysql>SETPASSWORDFOR'jeffrey'@'localhost'=PASSWORD('mypass');
修改当前登录用户密码：
mysql>SETPASSWORD=PASSWORD('mypass');
以上所述是小编给大家介绍的Mysql5.6添加修改用户名和密码的方法，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持！