Grant the access to remote IP address and login to MySQL. For example, if you want to allow access to the database called database for user user with password password and remote IP address 203.0.113.2:

CONFIG_TEXT: GRANT ALL ON database.* TO user@'203.0.113.2' IDENTIFIED BY 'password'; CONFIG_TEXT: FLUSH PRIVILEGES;

To create a user that has access to all databases, execute the following query:

Thank you for the feedback, the article was updated with additional details. Kindly note, that if the address is set to ::, the server accepts TCP/IP connections on all server host IPv4 and IPv6 interfaces.

hi, I tried several times to do this procedure, but with vi when he tells me that I do not have write permissions, in the root I have enabled all writing services, but when I use it tells me that I do not have the services and I do not does not even save with: w! o: wq! you can help me courteously