Question

Using the LEMP Marketplace image, what's the step by step way of allowing MySQL access from remote connections?

Using the LEMP Marketplace image, what’s the step by step way of allowing MySQL access from remote connections?

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

Giving this up now. I’m clearly missing something obvious. SequelPro still throwing an error having completed those steps on a brand new droplet. Thanks for your help though :)

PS I started by simply creating from an image and then logging in, no other steps.

Hi Jarland,

That series of commands to create a user don’t quite work…

ERROR 1396 (HY000): Operation CREATE USER failed for ‘username’@‘ipaddress’

Hey friend!

Great question. These steps should do it.

Setting MySQL to allow remote connections:

sed -i 's/127.0.0.1/0.0.0.0/g' /etc/mysql/mysql.conf.d/mysqld.cnf
systemctl restart mysql

Creating a remote user:

mysql
create user 'username'@'ipaddress' identified by 'password';
quit

Jarland