Login Database.
mysql -u root mysql -p
Create Database.
CREATE DATABASE dbname;
Create Database User.
CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'password';
Give permission for dbname on db user.
GRANT ALL PRIVILEGES ON dbname.* TO 'dbuser'@'localhost';
Notice changes and reload the grant tables immediately.
FLUSH PRIVILEGES;
[…] 1- Install MySQL database on Centos ( I promise add this document ASAP 🙂 ) 2- How to Create MYSQL Database in SSH […]