I've been using RPM every time i will install MySQL server in my Linux boxes. But today i will show you on how to install MySQL 5.5 on Centos 6.5 via Yum.
First, to set up the yum repository, install the webtatic-release RPM based on your CentOS/RHEL release.
[root@localhost ~]# rpm -Uvh http://mirror.webtatic.com/yum/el6/latest.rpm
Retrieving http://mirror.webtatic.com/yum/el6/latest.rpm
warning: /var/tmp/rpm-tmp.q3Y9pR: Header V4 DSA/SHA1 Signature, key ID cf4c4ff9: NOKEY
Preparing... ########################################### [100%]
1:webtatic-release ########################################### [100%]
After installing, the commands needed to activate it to run at system startup depend on your operating system. On Linux, you can use chkconfig:
[root@localhost ~]# chkconfig --add mysqld
On some Linux systems, the following command also seems to be necessary to fully enable the mysql script:
You can now start MySQL as a service.
[root@localhost bin]# service mysqld start
Starting mysqld: [ OK ]
[root@localhost bin]# ps ax | grep mysql
26597 pts/2 S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
26804 pts/2 Sl 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
26836 pts/2 S+ 0:00 grep mysql
[root@localhost bin]#
First, to set up the yum repository, install the webtatic-release RPM based on your CentOS/RHEL release.
[root@localhost ~]# rpm -Uvh http://mirror.webtatic.com/yum/el6/latest.rpm
Retrieving http://mirror.webtatic.com/yum/el6/latest.rpm
warning: /var/tmp/rpm-tmp.q3Y9pR: Header V4 DSA/SHA1 Signature, key ID cf4c4ff9: NOKEY
Preparing... ########################################### [100%]
1:webtatic-release ########################################### [100%]
Remove the pre-installed mysql-libs with no dependecy.
[root@localhost ~]# rpm -e mysql-libs
error: Failed dependencies:
libmysqlclient.so.16()(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
mysql-libs is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
[root@localhost ~]# rpm -e --nodeps mysql-libs
After removing the previous version of mysql-libs you can now start the installation of MYSQL via Yum
[root@localhost ~]# yum install mysql55 mysql55-server
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: centos.corenetworks.net
* extras: centos.mirror.freedomvoice.com
* updates: mirrors.usinternet.com
* webtatic: sp.repo.webtatic.com
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql55.x86_64 0:5.5.34-1.w6 will be installed
--> Processing Dependency: mysql55-libs = 5.5.34-1.w6 for package: mysql55-5.5.34-1.w6.x86_64
---> Package mysql55-server.x86_64 0:5.5.34-1.w6 will be installed
--> Processing Dependency: perl-DBI for package: mysql55-server-5.5.34-1.w6.x86_64
--> Processing Dependency: perl-DBD-MySQL for package: mysql55-server-5.5.34-1.w6.x86_64
--> Processing Dependency: perl(DBI) for package: mysql55-server-5.5.34-1.w6.x86_64
--> Running transaction check
---> Package mysql55-libs.x86_64 0:5.5.34-1.w6 will be installed
--> Processing Dependency: libmysqlclient16 for package: mysql55-libs-5.5.34-1.w6.x86_64
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
--> Running transaction check
---> Package libmysqlclient16.x86_64 0:5.1.69-1.w6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
==================================================================================================================================================
Package Arch Version Repository Size
==================================================================================================================================================
Installing:
mysql55 x86_64 5.5.34-1.w6 webtatic 5.5 M
mysql55-server x86_64 5.5.34-1.w6 webtatic 10 M
Installing for dependencies:
libmysqlclient16 x86_64 5.1.69-1.w6 webtatic 1.0 M
mysql55-libs x86_64 5.5.34-1.w6 webtatic 778 k
perl-DBD-MySQL x86_64 4.013-3.el6 base 134 k
perl-DBI x86_64 1.609-4.el6 base 705 k
Transaction Summary
==================================================================================================================================================
Install 6 Package(s)
Total download size: 18 M
Installed size: 82 M
Is this ok [y/N]: y
Downloading Packages:
(1/6): libmysqlclient16-5.1.69-1.w6.x86_64.rpm | 1.0 MB 00:06
(2/6): mysql55-5.5.34-1.w6.x86_64.rpm | 5.5 MB 00:45
(3/6): mysql55-libs-5.5.34-1.w6.x86_64.rpm | 778 kB 00:05
(4/6): mysql55-server-5.5.34-1.w6.x86_64.rpm | 10 MB 01:13
(5/6): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm | 134 kB 00:02
(6/6): perl-DBI-1.609-4.el6.x86_64.rpm | 705 kB 00:06
--------------------------------------------------------------------------------------------------------------------------------------------------
Total 130 kB/s | 18 MB 02:22
warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID cf4c4ff9: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-webtatic-andy
Importing GPG key 0xCF4C4FF9:
Userid : Andy Thompson
Package: webtatic-release-6-4.noarch (installed)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-webtatic-andy
Is this ok [y/N]: y
warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID c105b9de: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
Importing GPG key 0xC105B9DE:
Userid : CentOS-6 Key (CentOS 6 Official Signing Key)
Package: centos-release-6-5.el6.centos.11.1.x86_64 (@anaconda-CentOS-201311272149.x86_64/6.5)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : perl-DBI-1.609-4.el6.x86_64 1/6
Installing : libmysqlclient16-5.1.69-1.w6.x86_64 2/6
Installing : mysql55-libs-5.5.34-1.w6.x86_64 3/6
Installing : mysql55-5.5.34-1.w6.x86_64 4/6
Installing : perl-DBD-MySQL-4.013-3.el6.x86_64 5/6
Installing : mysql55-server-5.5.34-1.w6.x86_64 6/6
Verifying : libmysqlclient16-5.1.69-1.w6.x86_64 1/6
Verifying : perl-DBD-MySQL-4.013-3.el6.x86_64 2/6
Verifying : mysql55-libs-5.5.34-1.w6.x86_64 3/6
Verifying : perl-DBI-1.609-4.el6.x86_64 4/6
Verifying : mysql55-5.5.34-1.w6.x86_64 5/6
Verifying : mysql55-server-5.5.34-1.w6.x86_64 6/6
Installed:
mysql55.x86_64 0:5.5.34-1.w6 mysql55-server.x86_64 0:5.5.34-1.w6
Dependency Installed:
libmysqlclient16.x86_64 0:5.1.69-1.w6 mysql55-libs.x86_64 0:5.5.34-1.w6 perl-DBD-MySQL.x86_64 0:4.013-3.el6 perl-DBI.x86_64 0:1.609-4.el6
Complete!
[root@localhost ~]# chkconfig --level 345 mysqld on
You can now start MySQL as a service.
[root@localhost bin]# service mysqld start
Starting mysqld: [ OK ]
[root@localhost bin]# ps ax | grep mysql
26597 pts/2 S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
26804 pts/2 Sl 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
26836 pts/2 S+ 0:00 grep mysql
[root@localhost bin]#
1 comment:
hi Mike, very help. I'm almost there but getting an error on mysqlclient:
mysql: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory
Any ideas on how to resolve?
Thanks,
Jeff
Post a Comment