MySQL安装提示错误Host '127.0.0.1' is not allowed to connect to this MySQL server
程序员文章站
2022-03-02 23:37:08
MySQL连接数据库出现错误:Host '127.0.0.1' is not allowed to connect to this MySQL server...
MySQL连接数据库出现错误:Host '127.0.0.1' is not allowed to connect to this MySQL server
实际登录访问本机mysql,后来查找是因为:
MySQL数据库的配置文件my.ini中设置了参数: skip-name-resolve,从而导致使用“localhost”不能连接到数据库。
关闭此配置,#skip-name-resolve,
重新启动mysql
停止:net stop mysql 启动:net start mysql此时就可以解决连接报错问题!
上一篇: 一不小心就做错的JS闭包面试题_javascript技巧
下一篇: JAVA使用随机数实现概率抽奖
推荐阅读
-
Mysql远程连接 Host * is not allowed to connect to this MySQL server
-
MySQL 1130 - Host 127.0.0.1 is not allowed to connect to this MySQL server
-
Navicat 连接 MySQL 失败 : 1130 - Host xxx is not allowed to connect to this MySQL server
-
MYSQL Error 1130:Host '计算机名' is not allowed to connect to this MySQL server
-
转:mysql远程连接 Host * is not allowed to connect to this MySQL server
-
Ubuntu安装MySQL及使用Xshell连接MySQL出现的问题(2003-Can't connect to MySql server及1045错误)
-
MySQL安装提示错误Host '127.0.0.1' is not allowed to connect to this MySQL server
-
关于对连接数据库时出现1130-host “**” is not allowed to connect to this MySql/mariadb server 的错误解决方法
-
host...is not allowed to connect to this MySql server开放mys_MySQL
-
mysql连接提示"Host 'XXX' is not allowed to connect to this MySql server"