MySQL 1130 exception, unable to log in remotely solution

question:

mysql: 1130 is not allowed to connect to this MariaDB server (no remote login permission, note: MariaDB here is an extended version of MySQL)

1. Enable remote login permission:

Copy the localhost user data and rename localhost to % (that is, all links can log in to the server). You can also change it to the corresponding IP address of the server. The steps are as shown in the figure:

2. Refresh MySQL permissions:

The specific sql is as follows:

mysql> use mysql;
mysql> flush privileges; 

3. Test:

Login successful

This is the end of this article about the detailed solution to MySQL 1130 exception and unable to log in remotely. For more related MySQL 1130 exception and unable to log in remotely solution, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!