当前位置：网站首页>1130 - host XXX is not allowed to connect to this MySQL server error in Navicat remote connection database

1130 - host XXX is not allowed to connect to this MySQL server error in Navicat remote connection database

2022-04-23 12:58:00 【@Natural and unrestrained】

solve : Navicat Remote connection database error 1130- Host xxx is not allowed to connect to this MySQL server

Problem description

Use Navicat Appears when connecting to a remote database 1130 error , Then try it again SSH user name + Password to connect , Still can't connect . Later, it was found that it was because of Mysql database root User does not have permission to open .

terms of settlement

Into the database

mysql -u root -p

Switch to mysql

use mysql;

Set up root User's connection permission

% It means to allow all IP Connect to database

update user set host = '%' where user ='root';

Refresh the permissions

flush privileges;

Complete the above steps , Reuse Navicat Connect , You can successfully enter .
Database connection successful

above .

版权声明
本文为[@Natural and unrestrained]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204231256482671.html