How to Install mysql server in centos

MySQL is open-source relational database management system (RDBMS), The SQL phrase stands for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements, MySQL is a popular choice of database for use in web applications.

 To install MYSQL server on centos follow the steps below.

SSH server

 yum install mysql-server

yum install mysql-devel 

Set the MySQL service to start on boot

chkconfig --levels 235 mysqld on

/etc/init.d/mysqld start
or
service mysqld start

 If this doesent work use below command to find location.

 find / -name mysql

 output will be like we are looking for init.d 

 ==========
/etc/chkserv.d/mysql
/etc/logrotate.d/mysql
/etc/rc.d/init.d/mysql
/home/cpeasyapache/src/php-5.4.20/ext/mysql
/var/run/restartsrv/startup/mysql
===========

 Run the Command.

 /etc/rc.d/init.d/mysql start

T set the MYSQL password run the command below.

   mysqladmin -u root password “New – password”

Mysql should be running before you proceed to change the root password