我在Ubuntu 12.04上运行了MySQL Server 5.5.32.Ubuntu正在VM上运行.主机平台是Windows 7. 如何从Windows连接Ubuntu的MySQL?
到目前为止我做了以下事情:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
运行show grant for root;显示:
+-------------------------------------------------------------+
| Grants for root@% |
+-------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION |
+-------------------------------------------------------------+
但是,当我尝试从Windows上运行的SQLYog连接到此服务器时,出现错误Error 2003 Cannot connect to mysql server on '192.168.xxx.xxx'.
IP正在向SQLYog提供,我从中得到了它ifconfig.提供了inet addr.
inet addr:192.168.226.xxx Bcast:192.168.226.yyy
使用的地址是不正确的还是这些授权问题?请指教.