mysql连接报错：ERROR 2002 (HY000):Can't connect to MySQL server on '172.18.0....

littlestupid · 发表于 2021-9-9 10:00

EDA365欢迎您登录！

您需要登录才可以下载或查看，没有帐号？注册

x

使用MySQL客户端连接远程amoeba进行远程控制数据库报错：

root@uduntu:~# mysql -u root -P8066 -h 172.18.0.4 -p
Enter password:
ERROR 2002 (HY000): Can't connect to MySQL server on '172.18.0.4' (115)

求解答？？？？在线等谢谢，可进行远程协调

youOK · 发表于 2021-9-9 13:23

为啥一看到程序，就头大

thinkfunny · 发表于 2021-9-9 13:24

Maybe the root is not allowed to connect mysql server from a remoting host. I advise you to create a new user instead of root.

create user 'joey'@'%' identified by 'yourpassword';
grant all privileges on yourdb.* to 'joey'@'%'
you can replace '%' with your host（if not, connecting mysql server from every remoting host is allowed）

xiaogegepcb · 发表于 2021-9-9 13:26

是不是应该检查下 mysql服务是否开了远程权限

帐号		自动登录	找回密码
密码			注册

mysql连接报错：ERROR 2002 (HY000):Can't connect to MySQL server on '172.18.0....

EDA365欢迎您登录！

浏览过的版块

推荐内容 /1