Question

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

Posted March 8, 2019 2.1k views
MySQL LEMP Ubuntu 18.04

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

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.

4 answers

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

Hi Jarland,

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

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

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

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 :)

Submit an Answer