External access to MySQL database

To gain external access to MySQL database (f.e. in PHPSTorm or an external PHPMyAdmin) you can do: GRANT necessary privileges:

If the user already exists, you can leave the first line. Allow access from outside localhost:

On CentOS the my.cnf usually is directly located in /etc/ and the service name is mysqld. Check […]