11.給mysql指定數(shù)據(jù)庫(kù)分配用戶(hù)及權(quán)限。

grant select,insert,update,delete on C.* to mpp@localhost identified by "123456";

12.生效遠(yuǎn)程連接mysql

mysql>GRANT?ALL?PRIVILEGES?ON C.*?TO?'root'@'%'identified by "123456";

mysql>GRANT?ALL?PRIVILEGES?ON C.*?TO?'root'@localhostidentified by "123456";

//賦予任何主機(jī)訪問(wèn)數(shù)據(jù)的權(quán)限

mysql>FLUSH?PRIVILEGES

//修改生效

14.撤銷(xiāo)權(quán)限

revoke all on C.* from 'root'@localhost identified by '123456';

13.MySQL修改賬戶(hù)密碼

use mysql

update user set Password=password('newpassword') where User='root';

flush privileges;

The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

解決辦法：

mysql> set global read_only=0;

(關(guān)掉新主庫(kù)的只讀屬性)

flush privileges;

總結(jié)

以上是生活随笔為你收集整理的mysql的远程帐号密码_MySQL设置远程客户端访问权限和修改账户密码的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。