Download required MySQL rpm packages
MySQL-client-community-5.1.25-0.rhel5.i386.rpm
MySQL-server-community-5.1.25-0.rhel5.i386.rpm
MySQL-devel-community-5.1.25-0.rhel5.i386.rpm
Install the downloaded MySQL rpm packages
rpm -ivh MySQL-server-community-5.1.25-0.rhel5.i386.rpm MySQL-client-community-5.1.25-0.rhel5.i386.rpm
Set the root password
/usr/bin/mysqladmin -u root password 'root123'
How to stop and start MySQL
service mysql status
service mysql stop
service mysql start
# /sbin/service mysqld restart
Log into MySQL
mysql -u root -p
How to check the MySQL version
SHOW VARIABLES LIKE "%version%";
How to create a database and granting permission
CREATE DATABASE test;
GRANT ALL ON test.* TO user1@'%' IDENTIFIED BY "user123";
How to drop a database and user
DROP DATABASE test;
SELECT host, user, password FROM mysql.user;
DROP USER 'user1'@'localhost';
or
DROP USER 'user1'@'%';