Menu
While connecting to database on remote server I got connection error related to known_hosts file.
It did not ask me to update the known_host file but simply reject to connect.
273
ipconfig and then just check the IP address and put it in place of localhost in the previous command. If this still doesn't works then put 127.0. 0.1:3306 . After this, it will prompt to add or save the password , enter a unique password there.
The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection. By default, the server closes the connection after 8 hours if nothing has happened. You can change the time limit by setting the wait_timeout variable when you start mysqld.
Check that MySQL is running on address localhost. Check that MySQL is reachable on port 3306 (note: 3306 is the default, but this can be changed). Check the user root has rights to connect to localhost from your address (MySQL rights define what clients can connect to the server and from which machines).
For Windows 10, MySQL Workbench appears to use a known_hosts file in a standard location:
C:\Users\%USERPROFILE%\.ssh\known_hosts
If you are happy that the server fingerprint has changed, you can remove the related line, and try the operation again in Workbench.
136
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
