报错:1130-host ... is not allowed to connect to this MySql server
首先:修改配置文件my.cnf
vim /usr/local/mysql3306/etc/my.cnf
在[mysqld]处添加一行:skip-grant-tables
退出保存
重其mysql 服务。
Mysql提示you need the SUPER privilege for this operation的解决办法
同上
转自:http://www.cnblogs.com/xyzdw/archive/2011/08/11/2135227.html
错误2:Access denied for user 'root'@'localhost' (using password:YES)
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root'; mysql> FLUSH PRIVILEGES; mysql> quit
重启mysql服务;
执行
grant replication slave, replication client on *.* to repl@'localhost' identified by '123456' 时报错:
ERROR 1290 (HY000): 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;
set global read_only=1;(读写属相)
flush privileges;