Melisa Barrera

Asked 4 questions

taken 0 answers

Sqlyog error code 1045, mysql remote connection error code 1130

$20

Single winner

Asked a year ago

Viewed 0 times

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

add comment

Pierre Mccoy

a year ago

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

Check More Bounty Question

$15 conn.execute"delete from upfile where FilePath in('"&FilePath&"')" cannot delete multiple records --Alyssa Wall

$20 firebase login failed behind proxy --Byron Miles

$50 Any one succeed to host production level Nextjs project on firebase? --Deshaun Sims

$15 In Python, How to check if a file is occupied or not ? --Javonte Armstrong

$25 Why Firebase introduced custom claim? --Keagan Faulkner

$50 Best practice for real-time backup firebase firestore data. --TING ManLok

$50 How to provide fast global service with firebase for every firebase accessable region in the world? --Kenneth Park

$20 Can anyone point me to documentation related to the reliability (or durability) of firestore documents -- Johan Morse

$30 SEO Friendly pagination with Firebase Firestore query --TING ManLok

$35 Failed to implement firebase emulator --Perry Wall

$45 Best practice to implement count or likes on Firestore? --Ahmad Anthony

$50 Android Java sort files by type --Henry Miles