Installing MySQL 5.7+
Install MySQL from the APT repository. Finally, something easy!
sudo apt-get install mysql-server
Remember the password you enter for the
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 = 127.0.0.1 bind-address = 0.0.0.0
sudo service mysql restart
$ mysql -u root -p -e 'create database openboxes default charset utf8;'
Grant permissions to new new database user
mysql -u root -p -e 'grant all on openboxes.* to '<username>'@'localhost' identified by "<password>";'
For security reasons, you will want to set a good password. These values should be used in the
dataSource.password configuration properties in