UseFUL(L) SQLCommanDS

Login as root from UNIX shell:
sudo su;
Open a MySQL shell as root user:
mysql -u root -p;
How to Create a MySQL Database?
CREATE DATABASE dbname;
How to create a MySQL User?
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
How to grant all permission for a specific user for a specific database?
GRANT ALL PRIVILEGES ON database.* TO 'username'@'localhost';
Flush User Permissions to be effective
FLUSH PRIVILEGES;
Show Comments