ERROR 1130: Host ***.***.***.*** is not allowed to connect to this MySQL serverERROR 1062 (23000):
經過驗證以下方法有效
mysql -u root -p
mysql>use mysql;
mysql>select 'host' from user where user='root';
mysql>update user set host = '%' where user ='root';
mysql>flush privileges;
mysql>select 'host' from user where user='root';
第一句是以許可權使用者root登入
第二句:選擇mysql庫
第三句:檢視mysql庫中的user表的host值(即可進行連線訪問的主機/IP名稱)
第四句:修改host值(以萬用字元%的內容增加主機/IP地址),當然也可以直接增加IP地址
第五句:重新整理MySQL的系統許可權相關表
第六句:再重新檢視user表時,有修改。。
重起mysql服務即可完成。
mysql>use mysql;
mysql>select 'host' from user where user='root';
mysql>update user set host = '%' where user ='root';
mysql>flush privileges;
mysql>select 'host' from user where user='root';
第一句是以許可權使用者root登入
第二句:選擇mysql庫
第三句:檢視mysql庫中的user表的host值(即可進行連線訪問的主機/IP名稱)
第四句:修改host值(以萬用字元%的內容增加主機/IP地址),當然也可以直接增加IP地址
第五句:重新整理MySQL的系統許可權相關表
第六句:再重新檢視user表時,有修改。。
重起mysql服務即可完成。
以下百度查到的,試過可以
說明所連線的使用者帳號沒有遠端連線的許可權,只能在本機(localhost)登入。
需更改 mysql 資料庫裡的 user表裡的 host項
把localhost改稱%
具體步驟:登陸到mysql
首先 use mysql;
按照別人提供的方式update的時候,出現錯誤。
mysql> update user set host='%' where user = 'root';
ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
然後檢視了下資料庫的host資訊如下:
mysql> select host from user where user = 'root';
+-----------------------+
| host |
+-----------------------+
| % |
| 127.0.0.1 |
| localhost.localdomain |
+-----------------------+
3 rows in set (0.00 sec)
host已經有了%這個值,所以直接執行命令:
mysql>flush privileges;
再用mysql administrator連線...成功!!!
相關文章
- SQL Error (1130): Host IP is not allowed to connect to this MySQL serverErrorMySqlServer
- MySQL-1130-host ... is not allowed to connect to this MySql serverMySqlServer
- 解決mysql Navicat 出錯:1130-host . is not allowed to connect to this MySql server,MySqlServer
- Host 'localhost' is not allowed to connect to this MySQL serverlocalhostMySqlServer
- 解決MySql報錯:1130 - Host ‘xxx‘ is not allowed to connect to this MySQL server的方法MySqlServer
- 報錯:1130-host ... is not allowed to connect to this MySql server 開放mysql遠端連線 不使用localhostMySqlServerlocalhost
- mysql遠端連線 Host * is not allowed to connect to this MySQL serverMySqlServer
- Host 'xxx' is not allowed to connect to this MySQL server.MySqlServer
- HOW TO SOLVE ERROR 1062 (23000) ?Error
- Host 'xxx' is not allowed to connect to this MySQL server 解決方法MySqlServer
- “Host ‘xxxx‘ is not allowed to connect to this MySQL server“MySqlServer
- Host is not allowed to connect to this MySQL server 錯誤的處理方法MySqlServer
- Navicat連線centos裡mysql報錯Host is not allowed to connect to this MySQL serverCentOSMySqlServer
- ERROR 1062 (23000): Duplicate entry for key 'PRIMARY'Error
- ERROR 1062 (23000): Duplicate entry '0' for key 'PRIMARY'Error
- 關於對連線資料庫時出現1130-host “**” is not allowed to connect to this MySql/mariadb server 的錯誤解決方法資料庫MySqlServer
- 虛擬機器NAT模式下連線mysql報錯:Host '192.168.30.1' is not allowed to connect to this MySQL server虛擬機模式MySqlServer
- 上手MySQL之解決問題:not allowed to connect to this MySQL serverMySqlServer
- mysql 遠端連結錯誤 ERROR 1130MySqlError
- 【Mysql】Slave_SQL_Running: No:Last_Error: Error :1032/1062MySqlASTError
- 從ERROR 1062 (23000) at line Duplicate entry 'R01' for key 'PRIMARY' 能看出什麼Error
- Question : ERROR 1130 (00000)Error
- mysql can't connect error about privilege----not root userMySqlError
- mysql 1130 問題MySql
- mysql error 2005 - Unknown MySQL server host 'localhost'(11001)MySqlErrorServerlocalhost
- Error: User gpmon is not allowed to login Command CenterError
- MIGO error:"Goods receipt for purch. order" is not allowedGoError
- ssh: connect to host localhost port 22: Connection refusedlocalhost
- Error: User gpmon is not allowed to login Command Center.Error
- Fatal NI connect error 12170Error
- 遠端連線MySQL資料庫提示:ERROR 1130 (HY000)的解決辦法MySql資料庫Error
- MySQL報錯'ERROR 2002 (HY000): Can't connect to local MySQL server through'MySqlErrorServer
- ERROR 2002(HY000):Can't connect to local MySQL socket '/tmp/mysql.sock'ErrorMySql
- Fatal NI connect error 12170.Error
- mysqldump: Got error: 2002: Can't connect to local MySQL server through.....MySqlGoErrorServer
- Error:Unknow host 'service.gradle.org'ErrorGradle
- 坑:ssh: connect to host github.com port 22: Connection refusedGithub
- psql: error: could not connect to server: No such file or directorySQLErrorServer