Install / Configure / Manage MySQL on Centos

Intallation:
Install MySQL ==> yum install mysql mysql-server
start Mysql Service ==> service mysqld start
Create install and secure via ==>  mysql_secure_installation
login to MySQL ==> mysql -uroot -p
Show database ==> show databases;
Create new DB ==>  create database %DB_Name%;
Create and Grant rights ==> GRANT ALL ON %DB_Name%.* TO ‘%Usrn%’@’IP_or_FQDN%’ IDENTIFIED BY ‘%Password%’;
(ex : GRANT ALL ON DBTEST.* TO ‘DBtestusr’@’192.168.1.100’ IDENTIFIED BY ‘Password’; )
Exit – exit

Various command :

Show Databases;
Create database DBTEST;
Drop database DBTEST;

Create User and Grants :
CREATE USER ‘DBtestusr’@’%’ IDENTIFIED by ‘Password’;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON DBTEST.* TO ‘DBtestusr’@’%’;

Show all Users:
select * from mysql.user;
select User from mysql.user;

Delete User :
delete from mysql.user WHERE User=’name’;