This post will guide how to install MySQL server. After googling I found some solutions and wanted to share to everyone.
First you need putty, download tools here.
After downloading and installation you need to login to shell as sudo account.
Checking if MySQL already installed?
which mysql
rpm -qa | grep mysql
If found it will show some directory name otherwise not found
How to remove MySQL?
yum remove mysql-server
yum remove mysql
Now to install MySQL execute this command to shell.
yum install mysql-server
yum install mysql
yum install mysql-devel
Now let’s start mysql service
/sbin/service mysqld start
/sbin/chkconfig mysqld on
Inorder to use with php
yum install php-mysql
By default MySQL has the no passward. To change the password in command shell execute this commands.
mysql
mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD(‘new-password’) WHERE user=’root’;
mysql> FLUSH PRIVILEGES;
If anything is missing let me know…