MYSQL INSTALLATION

How to Install MySQL?

# yum install mysql-*

# /etc/init.d/mysqld status 

# /etc/init.d/mysqld start

# chkconfig mysqld on 

 

How to Connect to MySQL?

# mysql -u root -p

<No Password>           (For first time)

mysql> quit

 

How to configure MySQL?

# mysql_secure_installation

<Follow the instructions>                    (To set all the parameters)

 

* Note : Default DB for default parameters are “mysql” and for default schema it uses “information_schema”.