# 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';
```