# MySQL on Linux

### 1. Install

### CentOS Stream *9:*

```
sudo dnf install mysql-server -y
```

Enable and start MySQL service:

```
sudo systemctl restart mysqld.service
sudo systemctl enable mysqld.service
```

### *Ubuntu* 

```
$ sudo apt install mysql-server -y
```

### 2.   Change the authentication parameters:

```
sudo mysql 
```

run command in mysql console:

```

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by '<mysql_root_password>';
```

Сhange `<mysql_root_password>` to a strong password,

To exit from the MySQL console, press Ctrl+D.

* run `mysql_secure_installation`, to complete the installation:

```
$ sudo mysql_secure_installation
```

### 3. Creating MySQL User and Database

3.1. Run MySQL client and enter your MySQL root password

<pre><code><strong>sudo mysql -h localhost -u root -p
</strong></code></pre>

3.2. The following lines create a database `hesdb`, the user with name `hesuser` and password `<user_password>`. Сhange `<user_password>` to a strong password, otherwise you may get a password validator error.

```
CREATE DATABASE hesdb;
CREATE USER 'hesuser'@'%' IDENTIFIED BY '<user_password>';
GRANT ALL ON hesdb.* TO 'hesuser'@'%';
FLUSH PRIVILEGES;
```

To exit from the MySQL console, press Ctrl+D.