Login to SSH and then MySQL (mysql -u root -p).
Execute following after replacing DATABASE, USERNAME and PASSWORD
For IPv4 (required)
GRANT ALL PRIVILEGES ON DATABASE.* TO 'USERNAME'@'149.56.201.230' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
You may also need to comment out following line in mysql config file.
In file /etc/mysql/my.cnf or /etc/mysql/mysql.conf.d/mysqld.cnf
Comment out following line from bind-address = 127.0.0.1
to #bind-address = 127.0.0.1
Once it's done you need to restart MySQL server by:service mysql restart
Comments
0 comments
Please sign in to leave a comment.