[root@garey-mysql1 local]# rpm -ivh
MySQL-server-5.6.24-1.linux_glibc2.5.x86_64.rpm
Preparing...
########################################### [100%]
file /etc/init.d/mysql from install of MySQL-server-5.6.24-1.linux_glibc2.5.x86_64 conflicts with
file from
package Percona-Server-server-57-5.7.11-4.1.el6.x86_64
file /etc/logrotate.d/mysql from install of MySQL-server-5.6.24-1.linux_glibc2.5.x86_64
conflicts with file
from package Percona-Server-server-57-5.7.11-4.1.el6.x86_64
。。。。。。。。。。。。。。。。。。。。。。
[root@garey-mysql1 local]# yum remove percona-server-server
Loaded plugins:
fastestmirror
Setting up Remove
Process
No Match for argument: percona-server-server
Loading mirror speeds from
cached hostfile
* base: mirror.digistar.vn
* extras: centos.exabytes.com.my
* updates: mirror.digistar.vn
base
| 3.7 kB 00:00
No Packages marked for
removal
[root@garey-mysql1 local]# yum remove Percona-Server-server-57-5.7.11-4.1.el6.x86_64
Loaded plugins:
fastestmirror
Setting up Remove
Process
Resolving Dependencies
--> Running transaction check
---> Package
Percona-Server-server-57.x86_64 0:5.7.11-4.1.el6 will be erased
--> Finished Dependency Resolution
Dependencies Resolved
=======================================================================================
Package
Arch
Version
Repository Size
=======================================================================================
Removing:
Percona-Server-server-57 x86_64 5.7.11-4.1.el6 @percona-release-x86_64 173 M
Transaction Summary
=======================================================================================
Remove 1
Package(s)
Installed size: 173 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction
Test
Transaction Test Succeeded
Running Transaction
error reading information on
service mysql: No such file or directory
error: %preun(Percona-Server-server-57-5.7.11-4.1.el6.x86_64) scriptlet failed, exit status 1
Error in PREUN
scriptlet in rpm package Percona-Server-server-57
Percona-Server-server-57-5.7.11-4.1.el6.x86_64 was
supposed to be removed but is not!
Verifying : Percona-Server-server-57-5.7.11-4.1.el6.x86_64
1/1
Failed:
Percona-Server-server-57.x86_64 0:5.7.11-4.1.el6
Complete!
[root@garey-mysql1 local]# rpm -qa | grep percona
percona-release-0.1-3.noarch
[root@garey-mysql1 local]# rpm -e --noscripts percona-release-0.1-3.noarch
[root@garey-mysql1 local]# rpm -qa | grep percona-server-server
[root@garey-mysql1 local]# rpm -qa | grep -i percona-server-server
Percona-Server-server-57-5.7.11-4.1.el6.x86_64
[root@garey-mysql1 local]# rpm -e --noscripts
Percona-Server-server-57-5.7.11-4.1.el6.x86_64
[root@garey-mysql1 local]# rpm -qa | grep -i percona-server-server
[root@garey-mysql1 local]# rpm -ivh
MySQL-server-5.6.24-1.linux_glibc2.5.x86_64.rpm
Preparing...
########################################### [100%]
1:MySQL-server
########################################### [100%]
2016-05-24 11:15:17 0 [Warning] TIMESTAMP
with implicit DEFAULT
value is deprecated.
Please use --explicit_defaults_for_timestamp
server option (see documentation for more details).
2016-05-24 11:15:17 0 [Note] /usr/sbin/mysqld (mysqld 5.6.24) starting as process
4675 ...
A random root password has been set. You will find it in
'/root/.mysql_secret'.
2016-05-24 11:15:26 0 [Warning] TIMESTAMP
with implicit DEFAULT
value is deprecated.
Please use --explicit_defaults_for_timestamp
server option (see documentation for more details).
2016-05-24 11:15:26 0 [Note] /usr/sbin/mysqld (mysqld 5.6.24) starting as process
4697 ...
A RANDOM PASSWORD HAS
BEEN SET FOR
THE MySQL root USER
!
You will find that password
in '/root/.mysql_secret'.
。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
--defaults-file argument to mysqld_safe
when starting the server
[root@garey-mysql1 local]# ls -lah
total 107M
drwxr-xr-x. 2 root root 4.0K Sep 23
2011 lib
-rw-r--r--. 1 root
root 22M Mar 26 2015
MySQL-client-5.6.24-1.linux_glibc2.5.x86_64.rpm
-rw-r--r--. 1 root
root 85M Mar 26 2015
MySQL-server-5.6.24-1.linux_glibc2.5.x86_64.rpm
[root@garey-mysql1 local]# rpm -ivh
MySQL-client-5.6.24-1.linux_glibc2.5.x86_64.rpm
Preparing...
########################################### [100%]
file /usr/bin/mysql from install of
MySQL-client-5.6.24-1.linux_glibc2.5.x86_64 conflicts with file from package
Percona-Server-client-57-5.7.11-4.1.el6.x86_64
file /usr/bin/mysql_config_editor from install of
MySQL-client-5.6.24-1.linux_glibc2.5.x86_64 conflicts with file from package
Percona-Server-client-57-5.7.11-4.1.el6.x86_64 。。。。。。。。。。。。。。。。。。
[root@garey-mysql1 local]# rpm -qa | grep -i Percona-Server-client
Percona-Server-client-57-5.7.11-4.1.el6.x86_64
[root@garey-mysql1 local]# rpm -e --noscripts
Percona-Server-client-57-5.7.11-4.1.el6.x86_64
[root@garey-mysql1 local]# rpm -qa | grep -i Percona-Server-client
[root@garey-mysql1 local]# rpm -ivh
MySQL-client-5.6.24-1.linux_glibc2.5.x86_64.rpm
Preparing...
########################################### [100%]
1:MySQL-client ###########################################
[100%]
[root@garey-mysql1 local]# rpm -ivh
MySQL-shared-compat-5.6.24-1.linux_glibc2.5.x86_64.rpm
Preparing...
########################################### [100%]
file /usr/lib64/libmysqlclient.so.16.0.0 from install of
MySQL-shared-compat-5.6.24-1.linux_glibc2.5.x86_64 conflicts with file from
package Percona-Server-shared-51-5.1.73-rel14.12.625.rhel6.x86_64
file /usr/lib64/libmysqlclient_r.so.16.0.0 from install of
MySQL-shared-compat-5.6.24-1.linux_glibc2.5.x86_64 conflicts with file from
package Percona-Server-shared-51-5.1.73-rel14.12.625.rhel6.x86_64
[root@garey-mysql1 local]# rpm -e
Percona-Server-shared-51-5.1.73-rel14.12.625.rhel6.x86_64
error: Failed dependencies:
libmysqlclient.so.16()(64bit) is needed by (installed)
postfix-2:2.6.6-6.el6_7.1.x86_64
libmysqlclient.so.16()(64bit) is needed by (installed)
perl-DBD-MySQL-4.013-3.el6.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed)
postfix-2:2.6.6-6.el6_7.1.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed)
perl-DBD-MySQL-4.013-3.el6.x86_64
mysql-libs is needed by (installed) postfix-2:2.6.6-6.el6_7.1.x86_64
[root@garey-mysql1 local]# rpm -e --nodeps
Percona-Server-shared-51-5.1.73-rel14.12.625.rhel6.x86_64
[root@garey-mysql1 local]# service mysql start
Starting MySQL. ERROR! The server quit without updating PID file (/var/run/mysqld/mysqld.pid).
[root@garey-mysql1 log]# tail -n 20 mysqld.log
2016-05-24 12:06:38 5317 [Note] InnoDB:
Highest supported file
format is
Barracuda.
2016-05-24 12:06:38 5317 [Note] InnoDB:
128 rollback segment(s) are active.
2016-05-24 12:06:38 5317 [Note] InnoDB:
Waiting for purge to
start
2016-05-24 12:06:38 5317 [Note] InnoDB:
5.6.24 started;
log sequence number 1625987
2016-05-24 12:06:38 5317 [Note] Server
hostname (bind-address): '*'; port: 3306
2016-05-24 12:06:38 5317 [Note] IPv6 is
available.
2016-05-24 12:06:38 5317 [Note]
- '::'
resolves to '::';
2016-05-24 12:06:38 5317 [Note] Server
socket created on IP:
'::'.
2016-05-24 12:06:38 5317 [ERROR] /usr/sbin/mysqld: Can't create/write to
file '/var/run/mysqld/mysqld.pid' (Errcode: 2 - No such file or directory)
2016-05-24 12:06:38 5317 [ERROR] Can't start server: can't create PID
file: No such file or directory
160524 12:06:38 mysqld_safe mysqld from pid
file /var/run/mysqld/mysqld.pid ended
[root@garey-mysql1 log]# chown mysql:mysql
/var/run/mysqld
chown: cannot access `/var/run/mysqld': No such file or directory
[root@garey-mysql1 log]# cd /var/run/
[root@garey-mysql1 run]# mkdir mysqld
[root@garey-mysql1 run]# chown mysql:mysql /var/run/mysqld
[root@garey-mysql1 run]# ls -lah
total 72K
drwxr-xr-x. 12 root root 4.0K May
24 12:11 .
drwxr-xr-x. 18 root root 4.0K May
23 18:32 ..
-rw-r--r--. 1 root root
5 May 23 16:55 auditd.pid
drwxr-xr-x. 2 mysql mysql 4.0K May 24 12:11 mysqld
drwxrwxr-x. 2 root root 4.0K
May 4 03:23
netreport
[root@garey-mysql1 run]# service mysql start
Starting
MySQL. SUCCESS!
