For a small project, it is more economical to run MySQL server in Ubuntu 20.04 than to subscribe Amazon RDS. To install run the commands below.
sudo apt update
sudo apt upgrade -y
sudo apt install -y mysql-server
By default MySQL server bind address is set to 127.0.0.1. Run the command below to edit the configuration file and set it to 0.0.0.0 which binds to all addresses.
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
After the installation, run the below command to get into MySQL prompt.
sudo mysql -uroot
Run this command to check the available users in MySQL.
select user, host, plugin from mysql.user;
Lets change the MySQL user “root” to login with a password. At present “root” can only login from localhost even though the server bind address is set to all addresses.
Command below will allow “root” to login from anywhere with a “%”. I prefer to do this and control white listed IP through Amazon EC2 security group.
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
update mysql.user set host='%' where user='root';
Lastly restart the MySQL server.
sudo systemctl restart mysql