MySQL

My blog died some time ago. In order to explain why it died, here’s a little background:

I had 2 servers: a home server and a VPS. The VPS hosted my blog (a multi-site wordpress instance) and my IRC bouncer. My Home server hosted my ownCloud (now hosting NextCloud) and a bunch of media services. They are all configured with Docker using the official images from each project. When I started making this set-up, I didn’t know about docker-compose, so I made my own scripts that would run the docker commands needed to update and run my containers, including the back-up scripts for my blog.

This is a short an simple tutorial on how to enable remote access on MySQL on Ubuntu/Debian:

1. Edit the file /etc/mysql/my.cnf: at the line with: bind-address = …
2. Replace 127.0.0.1 with your server’s IP address.
3. Save the file!!!
4. Log in to MySQL: mysql -u root -p