Subhadip's Blog

My experience with the computing world!

Accessing Mysql database installed in an LXD container

This is my second post on LXD containers. Sometimes, using a container is a cleaner way to install and use applications for a number of reasons:

Last weekend I tried running mysql database from a local container and connect to it from my local system. Here's how:

  1. Create a brand new lxd container:
    lxc launch ubuntu:xenial mysql-test

  2. Create a bash session inside the container:
    lxc exec mysql-test bash

  3. Install mysql database server within the container:
    sudo apt install mysql-server

  4. Access the mysql database from inside the container as the root user:
    mysql -u root -p

  5. Allow remote access to root from any host:
    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password'
    where password is the password to be used while accessing mysql from outside of the container.

  6. Enable built-in firewall configurer and allow mysql access from outside:
    sudo ufw enable && sudo ufw allow mysql

  7. Exit the mysql client. Open the file '/etc/mysql/mysql.conf.d/mysqld.cnf' in your favourite text editor and comment the following line out by typing # at the starting of the line:
    #bind-address =

  8. Restart the mysql service:
    sudo service mysql restart

  9. Now exit the container. We need to check the IP of the container to access the database from the host. 'lxc list' should do the trick:
  10. Now from your host machine, try accessing the mysql server with the root password that you set in step #5:
    mysql -h -u root -p

You should be all set now. But the IP address of the container box will change every time you start your container. There's a way to stop it from changing. In my next post, I will share how to bind a static IP address to an lxd container.

Click here to load the comments. By clicking you agree to the Disqus privacy policy.