解决方法如下:
本文远程连接的ubuntu下的数据库,原因是ubuntu系统的mysql不允许被远程连接操作
因此需要修改mysql配置文件
步骤:
(1)cd /etc/mysql (2)vim my.cnf (3)将bind-address = 127.0.0.1修改为bind-address = 0.0.0.0 (4)保存退出 (5)/etc/init.d/mysql restart (一定要重启数据库,不然没用)
ok,此时就可以远程连接此数据库了.
相关文章
- 09-28MySQL8.0报错Can't connect to MySQL server on 'localhost' (10061)的解决办法
- 09-28Mac端解决（含修改8.0.13版的密码）：Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- 09-28如何修复ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)。
- 09-28MySQL8.0报错Can't connect to MySQL server on 'localhost' (10061)的解决办法
- 09-28(2003, “Can‘t connect to MySQL server on ‘localhost‘ (10061)“)解决
- 09-28MySQL：Can't connect to MySQL server on 'localhost'（10061）
- 09-28Mysql登录出现Can‘t connect to MySQL server on localhost (10061)【解决】
- 09-28启动MySQL报错:ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost：3306' (1006
- 09-28【转】在命令行输入 mysql -u root -p 登录mysql，返回”Can't connect to MySQL server on localhost (10061)”错误
- 09-28Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)