Reason: the root user of the mysql database forbids remote connections
Solution: add users
First log in to the mysql database on the machine where the database is located
1 mysql>GRANT ALL PRIVILEGES ON *.* TO'root'@'%' identyfied by 'password' with grant option
2 mysql>FLUSH PRIVILEGES;
ALL: Allow all remote machines to log in *.*: Allow all operations on the database'root'@'%': Allow remote login as root user,% means allow login as root user on all machines
The essence is that there is a mysql database on the server where mysql is located, and there is a user table in it. The above operation is added a piece of information to the user table.
Error code 1045 or 1130 when sqlyog connects to the database remotely
Reason: the root user of the mysql database forbids remote connections
Solution: add users
First log in to the mysql database on the machine where the database is located
1 mysql>GRANT ALL PRIVILEGES ON *.* TO'root'@'%' identyfied by 'password' with grant option
2 mysql>FLUSH PRIVILEGES;
ALL: Allow all remote machines to log in *.*: Allow all operations on the database'root'@'%': Allow remote login as root user,% means allow login as root user on all machines
The essence is that there is a mysql database on the server where mysql is located, and there is a user table in it. The above operation is added a piece of information to the user table.
Sqlyog error code 1045, mysql remote connection error code 1130
Sqlyog error code 1045, mysql remote connection error code 1130
Error code 1045 or 1130 when sqlyog connects to the database remotely