connect to MySQL 10061 grant
- WBOYOriginal
- 2016-06-07 17:25:021271browse
在Ubuntu下安装了mysql数据库，用Navicat客户端不能链接上，报如下错误error:ERROR 2003 (HY000): Can
在Ubuntu下安装了mysql数据库，用Navicat客户端不能链接上，报如下错误error:ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
1)服务器上mysql -uroot -p123456 查询可以登录
2）ping OK
3）服务器上 mysql grant 外部权限 grant all privileges on *.* to 'root'@'%' identified by '123456'; flush privileges;进行授权
4)数据库配置my.cnt 注释掉skip。。。 和 bing 上服务器地址，，原理是127.0.0.1
5)/etc/init.d/mysql restart
//Navicat 8.2.12 , MySQL GUI Tools 5.0
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Liferea 1.8.12 发布，Linux的RSS阅读Next article：Oracle dblink的使用