MySQL 8不再允许您使用GRANT命令创建用户。您需要首先创建用户。

CREATE USER 'root'@'%' IDENTIFIED BY 'PASSWORD';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

请按照下面提到的步骤来设置MySQL用户的通配符远程访问。

(1) Open cmd. (2) navigate to path C:\Program Files\MySQL\MySQL Server 5.X\bin and run this command. mysql -u root -p (3) Enter the root password. (4) Execute the following command to provide the permission. GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD'; USERNAME: Username you wish to connect to MySQL server. IP: Public IP address from where you wish to allow access to MySQL server. PASSWORD: Password of the username used. IP can be replaced with % to allow user to connect from any IP address. (5) Flush the previleges by following command and exit. FLUSH PRIVILEGES; exit; or \q

这篇如何在局域网上安装MySQL服务器的博客将有助于从头开始安装MySQL

如果mysqld有一个绑定地址设置为环回/本地地址(例如127.0.0.1)，服务器将无法从远程主机到达，因为环回接口无法从任何远程主机到达。

将此选项设置为0.0.0.0(::对于IPv4+6)以接受来自任何主机的连接，如果您希望只允许在一个接口上连接，则将该选项设置为另一个外部可达地址。

源

关闭链接/etc/mysql/mysql.conf.d/mysqld.cnf或/etc/mysql/my.cnf的注释:

bind-address = 127.0.0.1  =>>  #bind-address = 127.0.0.1

修改主机名以便所有机器都可以访问它，在本地运行这个SQL命令:

UPDATE mysql.user SET Host='%' WHERE Host='localhost' AND User='root';
FLUSH PRIVILEGES;

重新启动服务:

sudo service mysql restart

打开mysql端口:

sudo ufw allow 3306

根据我的经验，你可以在这个路径下找到配置文件/etc/mysql/mysql.conf.d/mysqld.cnf。

(我挣扎了一段时间才找到这条路)