Step 1: Enable MySQL Apt Repositories
wget -c https://repo.mysql.com//mysql-apt-config_0.8.13-1_all.deb
Then install the MySQL repository package by using the below command.
sudo dpkg -i mysql-apt-config_0.8.13-1_all.deb
MySQL server version 8.0 will be auto selected, just scroll down and Click/Enter on OK
Check attached screenshot for your reference.
Optional: if you want to change the mysql version 8.0 to 5.7
Click on First Option and Select MySQL 5.7 and Press Tab Button
Press Tab Button and Enter
Step 2: Refresh the Repositories
When you install new packages, you should update the repository by run below command in the terminal.
sudo apt-get update
Step 3: Install the mysql package
Then run the following command to install packages for the community server
sudo apt-get install mysql-server
Through the installation process, you will be asked to enter a password for the root user for your MySQL server, re-enter the password to confirm it and press [Enter].
Afterwards, you will be asked to select the default authentication plugin to use, then use the right arrow to choose
Ok and press to complete the package configuration.
Step 4: MySQL Secure Installation
Execute the following command to adjust security to the MySQL Server:
It will prompt you some security options that you should choose in order to secure the MySQL server:
- Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y
- Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y
- Remove test database and access to it? (Press y|Y for Yes, any other key for No) : Y
- Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y
Step 5: Manage MySQL Server via Systemd
Start the MySQL service
Check status of MySQL service
sudo systemctl start mysql
sudo systemctl status mysql
Enable service: so that it can start automatically at system startup
sudo systemctl enable mysql
In this tutorial, you have learned step by step how to install MySQL on Ubuntu.