在virtualBox中安装虚拟机,但是mysql安装在宿主机中,虚拟机一直无法访问msql
KHost 'TSJ-014755.YTX.COM' is not allowed to connect to this MySQL serverConnection closed by foreign host.
解决方法如下:
在装有MySQL的机器上登录MySQL mysql -u root -p密码
执行use mysql;
执行update user set host = '%' where user = 'root';这一句执行完可能会报错,不用管它。
执行FLUSH PRIVILEGES;