且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

无法连接到任何指定的MySQL主机.与C#

更新时间:2023-02-08 14:53:18

尝试将逗号:"替换为逗号,"
50.62.22.108:8085
50.62.22.108,8085

并立即更改密码,因为您刚刚将其公开:)下次使用更改后的值myPassword,MyUID或其他内容替换您的真实连接字符串.
只是友好的建议:)
Try simply replacing colon ":" with comma ","
50.62.22.108:8085
50.62.22.108,8085

And immediately change the password since you just put it public :) Next time replace your real connection string with changed values myPassword, MyUID or something.

Just friendly advice :)


两件事:

-默认情况下,root用户不允许远程访问.这不是一个好主意,但是您可以通过运行以下命令来启用它:

2 things:

- Remote access is not allowed by default to root user. It''s not a good idea,but you can enable it by running this command:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;



-另一方面,检查my.cnf文件,找到此行



- On the other hand, check my.cnf file, find this line

bind-address = 127.0.0.1

并将其注释掉.

希望对您有帮助

and comment it out.

Hope it helps