VIKHOST Tech Blog
Useful Technical Articles, Notes and Instructions.
MySQL - Enable Remote Access | VIKHOST

MySQL Server-Enable Remote Access

Enable remote access to MySQL database server If you try to connect to server mysql from remote server, you will get an error. Initially, mysql uses the standard localhost connection (127.0.0.1). It needs to be fixed this in the configuration file my.cnf (usually in Linux the file is located /etc/mysql/my.cnf) In my.cnf we need to find line: bind-address = 127.0.0.1 It needs to be changed to: bind-address = 0.0.0.0 Now after service mysql restart we can connect to mysql from any IP (if the user is created). At the same time, for the root user, remote access remains under the ...
Read more