Mysql1130 remote connection does not have permission solution, mysql1130 permission

Mysql1130 remote connection does not have permission solution, mysql1130 permission

There are two reasons why the remote connection has no permissions: mysql and firewall.

1. Solve firewall restrictions:

Shut down the firewall on the mysql service host or add inbound and outbound rules in the firewall advanced settings, and add the mysql port to allow access to the host through the mysql port.

2. Solve mysql restrictions and execute the following SQL statements on the mysql service host

-- Change the logon Host of the root User to any Host: update userset Host = '%' WHERE User = 'root'; -- change the permission (root is the account name, % is the host name (any host), 525099302 is the password) grant all privileges on *. * TO root @ '%' identified by "525099302"; -- refresh the permission, mysql takes effect directly BY flush privileges;

By breaking through the above two restrictions, you can access the mysql host smoothly and remotely.

I met this problem last year. I don't remember it very clearly this year. It seems that I overestimated my memory, but I still remember it.

MYSQL remote access problem, no permission

Add 192.168.0.250/phpmyadmin access settings like setting up a website.
Add permissions to the directory. For example, the visitor's access permission

Mysql is connected to the database. In 1130, I cannot connect to the database, so I cannot change the permission. In addition, I still report an error after the new installation.

Hi.
First, make sure that the error 1130 means that your database does not support remote connection. In other words, except for the default localhost and loopback addresses, you cannot use ip addresses to connect.
I see the description of your problem (
An error is reported after the new installation.
You should use your local database. Why do you need to use a remote address for connection? Log on directly using localhost, modify the permission table, and add the remote connection address you want to allow in the permission table. Remember to flush privileges.

You can.

You are welcome to ask.