Adding MySQL to Ubuntu 16.04.02

Installation of MySQL to a DigitalOcean Ubuntu 16.04.02 Server

# apt install -y mysql-server mysql-client
# mysql_secure_installation

Test root login and MySQL
# mysql -uroot -proot_password


WordPress MySQL Configuration

# mysql -uroot -proot_password

Test wordpress login and MySQL
# mysql -uwordpress -pw_password


Magento MySQL Configuration

# mysql -uroot -proot_password

Test magento login and MySQL
# mysql -umagento -pm_password

This may need to be set higher than 16MB for larger product numbers


Configuring for MySQL WorkBench remote access

# vi /etc/mysql/mysql.conf.d/mysqld.cnf


Remote access from any host

Open firewall to any host
# ufw allow proto tcp from any to any port 3306

Remote access from specific host

Open firewall to specific host
# ufw allow proto tcp from to any port 3306