I have two droplets with lamp installation.I enabled private networking to both instances.
I referred links given below and configured them according to mentioned steps.
Then I started Mysql service and I have created user and granted it full permission via these commands.
CREATE USER 'webadmin'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'webadmin'@'localhost';
CREATE USER 'webadmin'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'webadmin'@'%';
I want to enable remote access to Mysql Server that's why I need to change the bind-address in /etc/mysql/my.cnf file.
I have changed to
bind-address = 0.0.0.0
Then I restarted mysql service.
now I am trying to connect to mysql server from another droplet.
mysql -u webadmin -p -h xx.xx.xx.xx
I got error 2003(HY000).
lsof -i -P | grep :3306 command returns nothing.
Am I making any mistake??
These answers are provided by our Community. If you find them useful, show some love by clicking the heart.
If you run into issues leave a comment, or add your own answer to help others.