A story about how easy it is to set up a LAMP server with DigitalOcean [mysql connection]

I set up a LAMP server on DigitalOcean, and it started up really quickly, which was great.

I recommend it because you can set up a fairly complete server in just a minute or two.

I only had trouble connecting to mysql, so I'll summarize it here.

I couldn't log in when I tried to connect from Sequel Pro.

When I try to log in to mysql as root, I can't connect because I can't set a password.

Change the plugin used for authentication from auth_socket to mysql_native_password.

You can also set a password and that's it.

For more details, please read the following URL:

MySQL Remote Connection Issues on Digital Ocean

December 18th, 2018 MySQL Remote Connection Issues on Digital Ocean

www.matthewhoelter.com

For now, this is just a memo, so that's it.