11.给mysql指定数据库分配用户及权限。
grant select,insert,update,delete on C.* to mpp@localhost identified by "123456";
12.生效远程连接mysql
mysql>GRANTALLPRIVILEGESON C.*TO'root'@'%'identified by "123456";
mysql>GRANTALLPRIVILEGESON C.*TO'root'@localhostidentified by "123456";
//赋予任何主机访问数据的权限
mysql>FLUSHPRIVILEGES
//修改生效
14.撤销权限
revoke all on C.* from 'root'@localhost identified by '123456';
13.MySQL修改账户密码
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;
(关掉新主库的只读属性)
flush privileges;