Install MySQL - huwenyuan/Linux GitHub Wiki

##Install MySQL (32-bit) on CentOS 6.5 using yum

1. Uninstall CentOS 6.5 built-in MySQL (version 5.1):

   # yum remove mysql mysql-*

2. Add EPEL and REMI repository:

   # rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm

   # rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

3. Install MySQL server:

   # yum --enablerepo=remi,remi-test install mysql mysql-server

4. Start MySQL service:

   # service mysqld start

5. Set root password:

   # /usr/bin/mysqladmin -u root password 'root'

6. Make MySQL service automatically start on startup:

   # chkconfig --levels 235 mysqld on

The following MySQL libraries (v5.5) will be installed by the above steps:

• mysql
• mysql-server
• mysql-libs
• perl-DBD-MySQL
• perl-DBI

##Install MySQL (32-bit) on CentOS 6.5 using rpm

1. Download:

   • MySQL-shared-compact-5.6.28-1.el6.i686.rpm
   • MySQL-server-5.6.28-1.el6.i686.rpm
   • MySQL-client-5.6.28-1.el6.i686.rpm

2. Install MySQL-shared-compact, it compatible with CentOS existing mysql-libs thus will not show error in next step.

   # rpm -ivh MySQL-shared-compact-5.6.28-1.el6.i686.rpm

3. Remove existing mysql-libs:

   # rpm -e mysql-libs.i686

4. Install MySQL Server:

   # rpm -ivh MySQL-server-5.6.28-1.el6.i686.rpm

5. Install MySQL Client:

   # rpm -ivh MySQL-client-5.6.28-1.el6.i686.rpm

6. Change root password:

   # service mysql stop
   # mysqld_safe --skip-grant-tables &
   # mysql -u root
   >use mysql;
   >update user set password=PASSWORD('root') where user='root';
   >flush privileges;
   >quit
   # service mysql start