ERROR 1130 远程连接mysql异常
程序员文章站
2022-07-13 15:50:16
...
操作系统:centos 6.9
mysql版本:5.5.35
#root 用户密码初始设置为"w123456"
/usr/bin/mysqladmin -u root password 'w123456'
错误描述:
ERROR 1130 (HY000): Host '192.168.89.168' is not allowed to connect to this MySQL server
参考:
https://blog.csdn.net/jrn1012/article/details/53231244
mysql版本:5.5.35
#root 用户密码初始设置为"w123456"
/usr/bin/mysqladmin -u root password 'w123456'
错误描述:
ERROR 1130 (HY000): Host '192.168.89.168' is not allowed to connect to this MySQL server
mysql -u root -pw123456 mysql>use mysql; mysql>INSERT INTO `user` (`Host`, `User`, `Password`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Create_user_priv`, `Event_priv`, `Trigger_priv`, `ssl_type`, `ssl_cipher`, `x509_issuer`, `x509_subject`, `max_questions`, `max_updates`, `max_connections`, `max_user_connections`) VALUES ('%', 'root', '*54F500156C181C6CDE0B51B7B2DCCAD222955471', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0); mysql>flush privileges;
参考:
https://blog.csdn.net/jrn1012/article/details/53231244