avatar

Sqlyog error code 1045, mysql remote connection error code 1130

Sqlyog error code 1045, mysql remote connection error code 1130

bounty icon
$20
Single winner
Asked  9 months ago
Viewed  0 times

Error code 1045 or 1130 when sqlyog connects to the database remotely

  • add comment
avatar

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.

  • Taken
  • add comment
  • 0
Sign In
Sign In
avatar

Sqlyog error code 1045, mysql remote connection error code 1130

Sqlyog error code 1045, mysql remote connection error code 1130

bounty icon
$20
Single winner
Asked  9 months ago
Viewed  0 times

Error code 1045 or 1130 when sqlyog connects to the database remotely

  • add comment
avatar

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.

  • Taken
  • add comment
  • 0