我正在尝试设置远程访问Ubuntu主机192.168.1.139的MySql 5.5服务器,因此我在服务器的配置文件/etc/mysql/my.cf中添加了以下行:bind-address=192.168.1.139。当我尝试重新启动mysqld时,出现了以下错误:
[Note] Server hostname (bind-address): '192.168.1.139'; port: 3306
[Note] - '192.168.1.139' resolves to '192.168.1.139';
[Note] Server socket created on IP: '192.168.1.139'.
[ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
[ERROR] Do you already have another mysqld server running on port: 3306 ?
有人能帮忙解决问题的原因吗?如何允许来自任何主机/用户的连接打开MySQL服务器,例如,在my.cf文件中应该使用什么语法?