Note that this is Not very secure, and should only be used for a local development box where you don’t feel like setting up individual permissions, but still need to connect from other machines.
请注意,这不是很安全,仅应用于您不想设置个人权限,但仍需要从其他计算机连接的本地开发箱。
To configure this feature, you’ll need to update the mysql user table to allow access from any remote host, using the % wildcard.
要配置此功能,您需要使用%通配符更新mysql用户表,以允许从任何远程主机进行访问。
Open the command-line mysql client on the server using the root account.
使用根帐户打开服务器上的命令行mysql客户端。
mysql -uroot
mysql -uroot
Then you will want to run the following two commands, to see what the root user host is set to already:
然后,您将需要运行以下两个命令,以查看root用户主机已设置为什么:
use mysql;select host, user from user;
使用mysql;从用户中选择主机,用