MySql远程登陆

在项目中连接mysql报错：
java.sql.SQLException: null, message from server: “Host ‘DESKTOP-D1KC6TK’ is not allowed to connect to this MySQL server”

解决方法：要配置MySQL远程登陆与用户授权

配置方法：

mysql> use mysql;
mysql> CREATE USER 'userone'@'%' IDENTIFIED BY '123456';
mysql> UPDATE user set host='%' where user='userone';
mysql> GRANT all privileges on *.* to 'userone'@'%';

如果直接使用GRANT ALL PRIVILEGES ON *.* TO 'root'@'*' IDENTIFIED BY '123456' WITH GRANT OPTION;配置会报错：

1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near ‘IDENTIFIED BY ‘123456’ WITH GRANT OPTION’ at line 1