Install mysql

Install MySQL
sudo apt-get install mysql-server

--------------------------------------------------------------------------------------------------------------------

Harden MySQL Server
sudo mysql_secure_installation
--------------------------------------------------------------------------------------------------------------------

Root Login
mysql -u root -p

--------------------------------------------------------------------------------------------------------------------

Create a New MySQL User and Database
create database testdb;
create user 'testuser'@'localhost' identified by 'password';
grant all on testdb.* to 'testuser';
grant all on testdb.* to 'testuser' identified by 'password';

--------------------------------------------------------------------------------------------------------------------

Create a Sample Table
mysql -u testuser -p
use testdb;
create table customers (customer_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, first_name TEXT, last_name TEXT);

--------------------------------------------------------------------------------------------------------------------

external access permission
sudo vim /etc/mysql/my.cnf

bind-address = 0.0.0.0

$ iptables -F
$ iptables -L
$ service iptables save

--------------------------------------------------------------------------------------------------------------------

Reset the MySQL Root Password
sudo service mysql stop
sudo dpkg-reconfigure mysql-server
sudo service mysql start

Remover permissões de usuários
revoke all on banco.* from usuario;

GRANT ALL ON . TO 'root'@'%' IDENTIFIED BY '[senha]' WITH GRANT OPTION;
FLUSH PRIVILEGES;

https://www.digitalocean.com/community/tutorials/como-instalar-a-pilha-linux-apache-mysql-php-lamp-no-ubuntu-14-04-pt