Installing MySQL on Linux

Description: A guide to install and configure MySQL on Linux. Installation and configuration is done through command-line.

#Open up a terminal and login as root user.

su root

#Install MySQL

yum install mysql mysql-server

#Starting MySQL Server

/etc/init.d/mysqld start

#Stopping MySQL Server

/etc/init.d/mysqld stop

#Checking Status of MySQL Server

/etc/init.d/mysqld status

#Setting MySQL Administrator Password (the root user)
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h rayedchan password 'new-password'

/usr/bin/mysqladmin -u root password Password1

Alternatively you can run:

/usr/bin/mysql_secure_installation

#Access MySQL

mysql -uroot -p