Install and config MySQL

Installation
yum install mysql
yum install mysql-server
yum install mysql-administrator
Configuration
chkconfig --levels 235 mysqld on
Starting
/etc/init.d/mysqld start
Changing the root password
mysqladmin -u root password your_root_sql_password
Backup
One database
mysqldump --single-transaction nhungnguoibantot_db > backup_nhungnguoibantot_db.sql -p
All databases
mysqldump --single-transaction --all-databases > backup_all_databases.sql -p
Restore
One databases
mysql > create database nhungnguoibantot_db;
mysql -u root -p < backup_nhungnguoibantot_db.sql
All databases
mysql -u root -p < backup_all_databases.sql
Show all databases
mysql>show databases;
Connect to database
connect database_name;
Show all tables of a database
mysql>show tables;
Create a new user to manage database
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON database_name
TO 'username'@'localhost'
IDENTIFIED BY 'password';