Skip to content

Installing MySQL 5.7+

Install MySQL from the APT repository. Finally, something easy!

sudo apt-get install mysql-server-5.7


Remember the password you enter for the root user as you will need that password to create the database and grant permissions in the following steps. If mysql-server was already installed then the root password is probably blank (just hit <Enter> when prompted for a password).

Create database

sudo mysql -u root -e "CREATE DATABASE openboxes default charset utf8;"

Create openboxes db user

sudo mysql -u root -e "CREATE USER 'openboxes'@'localhost' IDENTIFIED BY '<password>'"

Grant permissions to the new database user

sudo mysql -u root -e "GRANT ALL on openboxes.* to openboxes@localhost IDENTIFIED BY '<password>';"


For security reasons, you will want to set a good password. These values should be used in the dataSource.username and dataSource.password configuration properties in

Login into MySQL

$ mysql -u openboxes -p
Enter password: <enter password from earlier>

Execute a simple command

mysql> show tables;
Empty set (0.00 sec)

Configure MySQL Server

Allow external connections [optional]

If you need to allow external connections to MySQL then you'll need to edit the bind-address mysqld configuration. This is a security risk so please ensure that you set passwords and grant permissions in a way that does not leave you vulnerable to attacks.


# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address           =
bind-address            =


If you do enable external connections, please remember to change the root password!

Restart MySQL

sudo service mysql restart