Saturday, May 17, 2014

How to install mysql 5.6.15 in centos and redt hat 32 bit OS

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 5.6.15 on centos 32 bit OS follow the steps below.

If your not sure if your OS is 32 bit or 64 use the link  to check you OS is 32 bit or 64 bit version.

  • yum install wget 
  • yum install perl
  • yum install libaio
For installation steps of mysql 5.6.15 on a 64 bit O.S Click here 

For Installation of 32 bit mysql 5.6.15 in Centos follow the steps below.

  • wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-client-5.6.17-1.linux_glibc2.5.i386.rpm
  • wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-server-5.6.17-1.linux_glibc2.5.i386.rpm
  • wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-5.6.17-1.linux_glibc2.5.i386.rpm

If you are facing any issue in downloading rpm packages from above URL you can download from here.

  • rpm -ivh MySQL-shared-5.6.17-1.linux_glibc2.5.i386.rpm
  • rpm -ivh MySQL-client-5.6.17-1.linux_glibc2.5.i386.rpm
  • rpm -ivh MySQL-server-5.6.17-1.linux_glibc2.5.i386.rpm

In MySQL 5.6 root has a default password assigned and its located at /root/.mysql_secret file as mention in MySQL server Installation log, To get the temporary password run the command below.
  • cat /root/.mysql_secret
  • service mysql start
  • chkconfig --levels 235 mysqld on
  • mysql -u root -p
It will ask for password give the password mentioned in mysql_secret file and the set the new password of mysql.
  • SET PASSWORD FOR 'root'@'localhost' = PASSWORD('secret12password');
I have used secret12password as my root password for mysql.

No comments:

Post a Comment

Do Write about the Blog and Welcome to the world where open source is every thing :-)