> Please login to your SSH into your server as root
> Please Log in to MySQL as root:
mysql -u root
> Please create a new database user using this command:
GRANT ALL PRIVILEGES ON *.* TO 'db_user'@'localhost' IDENTIFIED BY 'P@s$w0rd123!';
> Please make sure to replace db_user
with the database username, you would like to give the database user, as well as, P@s$w0rd123!
with the password to be given to the user.
> Please log out of MySQL by typing: \q
.
> Please log in as the new database user you just created:
mysql -u db_user -p
> Please type the new database user’s password and press Enter.
> Please create a new database with this command:
CREATE DATABASE db_name;