Install MySQL on Ubuntu 18.04

mysql_setup.md

First Install MySQL on your ubuntu server

  sudo apt install mysql-server

Create new MySQL user

Login to MySQL and create a new user with the following command

  CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

change newuser and password with your desired username and password

Grant all privileges

  GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost';

again, change the newuser with the user specified in the previous step.

Allow Connection to this User over the internet

  Grant ALL PRIVILEGES ON *.* TO 'newuser'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

Allow connection to MySQL server

Now you need to edit the mysql config file to allow connection to the MySQL server. Open the config file using the below command.

  cd /etc/mysql/mysql.conf.d/
  sudo nano mysqld.cnf

comment out the line below from the mysqld.cnf file with '#' symbol and save the file.

  bind-address = 127.0.0.1

Restart MySQL Server

  sudo service mysql restart

Note: Make sure port '3306' is open in your security group.