# MySQL 8.0 Setup
# Step 1 — Installing MySQL
- Update the package index
```bash
sudo apt update
```
- Install the MySQL server package
```bash
sudo apt install mysql-server
```
- Start MySQL server
```bash
sudo systemctl start mysql.service
```
- Check MySQL server status
```bash
sudo systemctl status mysql
```
- The status should look like this
```shell
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: active (running) since Tue 2020-04-21 12:56:48 UTC; 6min ago
Main PID: 10382 (mysqld)
Status: "Server is operational"
Tasks: 39 (limit: 1137)
Memory: 370.0M
CGroup: /system.slice/mysql.service
└─10382 /usr/sbin/mysqld
```
# Step 2 — Configuring MySQL
- Open MySQL prompt
sudo mysql
- Change the root user’s authentication method to one that uses a password
```sql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
```
- Exit the MySQL prompt
```mysql
exit
```
- Authenticate as the root MySQL user using a password
mysql -u root -p
- Go back to using the default authentication method
```mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH auth_socket;
```
- Exit the MySQL prompt
```mysql
exit
```
- Run the security script
sudo mysql\_secure\_installation
- Following configuration is shown
```shell
Output
Securing the MySQL server deployment.
Connecting to MySQL using a blank password.
VALIDATE PASSWORD COMPONENT can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD component?
Press y|Y for Yes, any other key for No: Y
There are three levels of password validation policy:
LOW Length >= 8
MEDIUM Length >= 8, numeric, mixed case, and special characters
STRONG Length >= 8, numeric, mixed case, special characters and dictionary file
Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG:
2
```
```shell
Output
Please set the password for root here.
New password:
Re-enter new password:
```
```shell
Output
Estimated strength of the password: 100
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : Y
```
# Step 3 — Creating a Dedicated MySQL User and Granting Privileges
- Open MySQL prompt
```bash
mysql -u root -p
```
- Create a new User
```mysql
CREATE USER 'username'@'host' IDENTIFIED WITH authentication_plugin BY 'password';
```
or
```mysql
CREATE USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
```
- Grant privileges
```mysql
GRANT PRIVILEGE ON database.table TO 'username'@'host';
```
# MySQL Extra
- ##### Start MySQL server
```bash
sudo systemctl start mysql.service
```
- ##### Check MySQL status
```bash
sudo systemctl status mysql
```
- ##### Restart MySQL server
```bash
sudo systemctl restart mysql
```
- #### Uninstall MySQL
```bash
sudo systemctl stop mysql
sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-*
sudo rm -rf /etc/mysql /var/lib/mysql
```
- #### Unmask MySQL
```
sudo systemctl unmask mysql.service
```