mysql wont start after upgrade

Installing, Configuring, Troubleshooting server daemons such as Web and Mail
Post Reply
prezaeis
Posts: 5
Joined: 2012/01/06 01:54:28

mysql wont start after upgrade

Post by prezaeis » 2012/01/08 06:56:06

hi guys

I upgraded my mysql and php on centos 5.5 to the latest version
php seems to be working fine but my mysql will not start

typing:

service mysqld start

gives this error:

MySQL Daemon failed to start.
Starting mysqld: [FAILED]

Accessing my site gives this error:

The mysqli error was: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2).

Iv tried yum update mysql and restarting, nothing seems to be working

i also checked the following 2 directories and i cannot find a mysql.sock file in either of them

/var/lib/mysql and
/tmp/

Can anyone help me? im desperate

i really appreciate it

pschaff
Retired Moderator
Posts: 18276
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America
Contact:

mysql wont start after upgrade

Post by pschaff » 2012/01/08 16:20:46

If you are going to replace a core package then you probably need to get support from the source from which you acquired the replacement. You don't even say where you got that version. I see mysql 5.5 packages from Remi and Atomic.


If more help is needed then please [url=http://www.centos.org/modules/newbb/viewtopic.php?topic_id=28723&forum=54]provide more information about your system[/url] by running "./getinfo.sh package" and showing us the output file, along with
[code]rpm -qa mysql\* | sort[/code]

prezaeis
Posts: 5
Joined: 2012/01/06 01:54:28

Re: mysql wont start after upgrade

Post by prezaeis » 2012/01/09 05:06:54

hi

my apologies for not being clear in my original post

i have included the results of what you asked for, along with the content of my mysql.log file

1.

The getinfo.sh script outputs the following:

[code]

Information for general problems.
[code]
== BEGIN uname -rmi ==
2.6.18-194.26.1.el5xen x86_64 x86_64
== END uname -rmi ==

== BEGIN rpm -qa \*-release\* ==
centos-release-notes-5.5-0
epel-release-5-4
atomic-release-1.0-14.el5.art
webtatic-release-5-2
centos-release-5-5.el5.centos
rpmforge-release-0.5.2-2.el5.rf
remi-release-5-8.el5.remi
== END rpm -qa \*-release\* ==

== BEGIN cat /etc/redhat-release ==
CentOS release 5.5 (Final)
== END cat /etc/redhat-release ==

== BEGIN getenforce ==
Disabled
== END getenforce ==

== BEGIN free -m ==
total used free shared buffers cached
Mem: 1536 1478 57 0 30 127
-/+ buffers/cache: 1320 215
Swap: 2047 0 2047
== END free -m ==

== BEGIN rpm -qa yum\* rpm-\* python | sort ==
python-2.4.3-27.el5_5.3
rpm-build-4.4.2.3-20.el5_5.1
rpm-devel-4.4.2.3-20.el5_5.1
rpm-devel-4.4.2.3-20.el5_5.1
rpm-libs-4.4.2.3-20.el5_5.1
rpm-libs-4.4.2.3-20.el5_5.1
rpm-python-4.4.2.3-20.el5_5.1
yum-3.2.22-26.el5.centos
yum-fastestmirror-1.1.16-14.el5.centos.1
yum-metadata-parser-1.1.2-3.el5.centos
yum-updatesd-0.9-2.el5
== END rpm -qa yum\* rpm-\* python | sort ==

== BEGIN ls /etc/yum.repos.d ==
atomic.repo
CentOS-Base.repo
CentOS-Media.repo
CentOS-Testing.repo
epel.repo
epel-testing.repo
kbsingh-CentOS-Extras.repo
mirrors-rpmforge
mirrors-rpmforge-extras
mirrors-rpmforge-testing
remi.repo
rpmforge.repo
webtatic.repo
== END ls /etc/yum.repos.d ==

== BEGIN cat /etc/yum.conf ==
[main]
cachedir=/var/cache/yum
keepcache=0
debuglevel=2
logfile=/var/log/yum.log
distroverpkg=redhat-release
tolerant=1
exactarch=1
obsoletes=1
gpgcheck=1
plugins=1

# Note: yum-RHN-plugin doesn't honor this.
metadata_expire=1h

# Default.
# installonly_limit = 3

# PUT YOUR REPOS HERE OR IN separate files named file.repo
# in /etc/yum.repos.d
== END cat /etc/yum.conf ==

== BEGIN yum repolist all ==
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* atomic: www7.atomicorp.com
* base: mirror.de.leaseweb.net
* centosplus: mirror.de.leaseweb.net
* epel: mirror.de.leaseweb.net
* extras: mirror.de.leaseweb.net
* rpmforge: ftp-stud.fht-esslingen.de
* updates: mirror.de.leaseweb.net
repo id repo name status
addons CentOS-5 - Addons enabled: 0
atomic CentOS / Red Hat Enterprise Linux 5 - ato enabled: 997
atomic-testing CentOS / Red Hat Enterprise Linux 5 - ato disabled
base CentOS-5 - Base enabled: 3,566
c5-media CentOS-5 - Media disabled
c5-testing CentOS-5 Testing enabled: 913
centosplus CentOS-5 - Plus enabled: 51
contrib CentOS-5 - Contrib enabled: 0
epel Extra Packages for Enterprise Linux 5 - x enabled: 6,850
epel-debuginfo Extra Packages for Enterprise Linux 5 - x disabled
epel-source Extra Packages for Enterprise Linux 5 - x disabled
epel-testing Extra Packages for Enterprise Linux 5 - T disabled
epel-testing-debuginfo Extra Packages for Enterprise Linux 5 - T disabled
epel-testing-source Extra Packages for Enterprise Linux 5 - T disabled
extras CentOS-5 - Extras enabled: 266
kbs-CentOS-Extras CentOS.Karan.Org-EL5 - Stable enabled: 0
kbs-CentOS-Testing CentOS.Karan.Org-EL5 - Testing enabled: 1,102
remi Les RPM de remi pour Enterprise Linux 5 - disabled
remi-test Les RPM de remi en test pour Enterprise L disabled
rpmforge RHEL 5 - RPMforge.net - dag enabled: 10,900
rpmforge-extras RHEL 5 - RPMforge.net - extras disabled
rpmforge-testing RHEL 5 - RPMforge.net - testing disabled
updates CentOS-5 - Updates enabled: 534
webtatic Webtatic Repository 5 - x86_64 disabled
webtatic-debuginfo Webtatic Repository 5 - x86_64 - Debug disabled
webtatic-source Webtatic Repository 5 - x86_64 disabled
repolist: 25,179
== END yum repolist all ==

== BEGIN egrep 'include|exclude' /etc/yum.repos.d/*.repo ==
/etc/yum.repos.d/CentOS-Base.repo:exclude=postfix
/etc/yum.repos.d/CentOS-Base.repo:exclude=postfix
/etc/yum.repos.d/CentOS-Base.repo:includepkgs=postfix
/etc/yum.repos.d/CentOS-Testing.repo:includepkgs=php*
== END egrep 'include|exclude' /etc/yum.repos.d/*.repo ==

== BEGIN sed -n -e "/^\[/h; /priority *=/{ G; s/\n/ /; s/ity=/ity = /; p }" /etc/yum.repos.d/*.repo | sort -k3n ==
priority = 1 [atomic]
#priority = 1 [atomic-testing]
priority = 1 [atomic-testing]
== END sed -n -e "/^\[/h; /priority *=/{ G; s/\n/ /; s/ity=/ity = /; p }" /etc/yum.repos.d/*.repo | sort -k3n ==

== BEGIN cat /etc/fstab ==
/dev/sda1 / ext3 defaults,usrquota,grpquota 1 1
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
/dev/sda2 swap swap defaults 0 0
== END cat /etc/fstab ==

== BEGIN df -h ==
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 99G 32G 62G 35% /
tmpfs 768M 0 768M 0% /dev/shm
== END df -h ==

== BEGIN fdisk -l ==
Disk /dev/sda1 doesn't contain a valid partition table
Disk /dev/sda2 doesn't contain a valid partition table

Disk /dev/sda1: 107.3 GB, 107374182400 bytes
255 heads, 63 sectors/track, 13054 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes


Disk /dev/sda2: 2147 MB, 2147483648 bytes
255 heads, 63 sectors/track, 261 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

== END fdisk -l ==

== BEGIN blkid ==
/dev/sda1: UUID="c00c975d-e9fc-4955xxxxxxxxxx" TYPE="ext3"
/dev/sda2: TYPE="swap"
== END blkid ==

== BEGIN cat /proc/mdstat ==
Personalities :
unused devices: <none>
== END cat /proc/mdstat ==

== BEGIN pvs ==
== END pvs ==

== BEGIN vgs ==
== END vgs ==

== BEGIN lvs ==
== END lvs ==

== BEGIN rpm -qa kernel\* | sort ==
kernel-devel-2.6.18-194.26.1.el5
kernel-headers-2.6.18-194.26.1.el5
kernel-xen-2.6.18-194.26.1.el5
kernel-xen-2.6.18-194.3.1.el5
kernel-xen-2.6.18-194.el5
== END rpm -qa kernel\* | sort ==

== BEGIN lspci -nn ==
== END lspci -nn ==

== BEGIN lsusb ==
== END lsusb ==

== BEGIN rpm -qa kmod\* kmdl\* ==
== END rpm -qa kmod\* kmdl\* ==

== BEGIN ifconfig -a ==
eth0 Link encap:Ethernet HWaddr 00:16:xx:xx:xx:xx
inet addr:94.xxx.xxx.xxx Bcast:94.xxx.xxx.xxx Mask:255.255.255.0
inet6 addr: fe80::216:xxxx:xxxx:e4e8/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:1579247 errors:0 dropped:0 overruns:0 frame:0
TX packets:41374 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:128064969 (122.1 MiB) TX bytes:6160924 (5.8 MiB)

lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:376 errors:0 dropped:0 overruns:0 frame:0
TX packets:376 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:18800 (18.3 KiB) TX bytes:18800 (18.3 KiB)

sit0 Link encap:IPv6-in-IPv4
NOARP MTU:1480 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)

== END ifconfig -a ==

== BEGIN brctl show ==
./getinfo.sh: line 87: brctl: command not found
== END brctl show ==

== BEGIN route -n ==
Kernel IP routing table
Destination Gateway Genmask Flags Metric Ref Use Iface
94.xxx.xxx.0 0.0.0.0 255.255.255.0 U 0 0 0 eth0
169.254.0.0 0.0.0.0 255.255.0.0 U 0 0 0 eth0
0.0.0.0 94.249.191.1 0.0.0.0 UG 0 0 0 eth0
== END route -n ==

== BEGIN cat /etc/resolv.conf ==
########### Automatically generated by OnApp (2.0.rc6)
domain
nameserver 94.xxx.xxx.xxx
nameserver 94.xxx.xxx.xxx
== END cat /etc/resolv.conf ==

== BEGIN grep net /etc/nsswitch.conf ==
#networks: nisplus [NOTFOUND=return] files
#netmasks: nisplus [NOTFOUND=return] files
netmasks: files
networks: files
netgroup: nisplus
== END grep net /etc/nsswitch.conf ==

== BEGIN chkconfig --list | grep -Ei 'network|wpa' ==
NetworkManager 0:off 1:off 2:off 3:off 4:off 5:off 6:off
network 0:off 1:off 2:on 3:on 4:on 5:on 6:off
wpa_supplicant 0:off 1:off 2:off 3:off 4:off 5:off 6:off
== END chkconfig --list | grep -Ei 'network|wpa' ==
[/code]

2. My mysql log file outputs this:

[code]

120108 06:19:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:19:17 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:19:17 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:19:17 InnoDB: The InnoDB memory heap is disabled
120108 6:19:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:19:17 InnoDB: Compressed tables use zlib 1.2.3
120108 6:19:17 InnoDB: Using Linux native AIO
120108 6:19:17 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:19:17 InnoDB: Completed initialization of buffer pool
120108 6:19:17 InnoDB: highest supported file format is Barracuda.
120108 6:19:17 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:19:17 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:19:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:22:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:22:29 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:22:29 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:22:29 InnoDB: The InnoDB memory heap is disabled
120108 6:22:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:22:29 InnoDB: Compressed tables use zlib 1.2.3
120108 6:22:29 InnoDB: Using Linux native AIO
120108 6:22:29 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:22:29 InnoDB: Completed initialization of buffer pool
120108 6:22:29 InnoDB: highest supported file format is Barracuda.
120108 6:22:29 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:22:29 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:22:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:22:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:22:39 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:22:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:22:39 InnoDB: The InnoDB memory heap is disabled
120108 6:22:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:22:39 InnoDB: Compressed tables use zlib 1.2.3
120108 6:22:39 InnoDB: Using Linux native AIO
120108 6:22:39 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:22:39 InnoDB: Completed initialization of buffer pool
120108 6:22:39 InnoDB: highest supported file format is Barracuda.
120108 6:22:39 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:22:39 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:22:39 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:27:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:27:07 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:27:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:27:07 InnoDB: The InnoDB memory heap is disabled
120108 6:27:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:27:07 InnoDB: Compressed tables use zlib 1.2.3
120108 6:27:07 InnoDB: Using Linux native AIO
120108 6:27:07 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:27:07 InnoDB: Completed initialization of buffer pool
120108 6:27:07 InnoDB: highest supported file format is Barracuda.
120108 6:27:07 InnoDB: Waiting for the background threads to start
120108 6:27:08 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:27:08 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:27:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:29:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:29:39 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:29:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:29:39 InnoDB: The InnoDB memory heap is disabled
120108 6:29:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:29:39 InnoDB: Compressed tables use zlib 1.2.3
120108 6:29:39 InnoDB: Using Linux native AIO
120108 6:29:39 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:29:39 InnoDB: Completed initialization of buffer pool
120108 6:29:39 InnoDB: highest supported file format is Barracuda.
120108 6:29:40 InnoDB: Waiting for the background threads to start
120108 6:29:41 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:29:41 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:29:41 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:30:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:30:12 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:30:12 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:30:12 InnoDB: The InnoDB memory heap is disabled
120108 6:30:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:30:12 InnoDB: Compressed tables use zlib 1.2.3
120108 6:30:12 InnoDB: Using Linux native AIO
120108 6:30:12 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:30:12 InnoDB: Completed initialization of buffer pool
120108 6:30:12 InnoDB: highest supported file format is Barracuda.
120108 6:30:12 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:30:12 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:30:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:31:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:31:45 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:31:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:31:45 InnoDB: The InnoDB memory heap is disabled
120108 6:31:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:31:45 InnoDB: Compressed tables use zlib 1.2.3
120108 6:31:45 InnoDB: Using Linux native AIO
120108 6:31:45 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:31:45 InnoDB: Completed initialization of buffer pool
120108 6:31:45 InnoDB: highest supported file format is Barracuda.
120108 6:31:45 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:31:45 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:31:45 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:36:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:36:39 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:36:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:36:39 InnoDB: The InnoDB memory heap is disabled
120108 6:36:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:36:39 InnoDB: Compressed tables use zlib 1.2.3
120108 6:36:39 InnoDB: Using Linux native AIO
120108 6:36:39 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:36:39 InnoDB: Completed initialization of buffer pool
120108 6:36:39 InnoDB: highest supported file format is Barracuda.
120108 6:36:39 InnoDB: Waiting for the background threads to start
120108 6:36:40 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:36:40 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:36:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:40:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:40:04 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:40:04 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:40:04 InnoDB: The InnoDB memory heap is disabled
120108 6:40:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:40:04 InnoDB: Compressed tables use zlib 1.2.3
120108 6:40:04 InnoDB: Using Linux native AIO
120108 6:40:04 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:40:04 InnoDB: Completed initialization of buffer pool
120108 6:40:04 InnoDB: highest supported file format is Barracuda.
120108 6:40:04 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:40:04 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:40:04 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:43:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:43:48 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:43:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:43:48 InnoDB: The InnoDB memory heap is disabled
120108 6:43:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:43:48 InnoDB: Compressed tables use zlib 1.2.3
120108 6:43:48 InnoDB: Using Linux native AIO
120108 6:43:48 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:43:48 InnoDB: Completed initialization of buffer pool
120108 6:43:48 InnoDB: highest supported file format is Barracuda.
120108 6:43:48 InnoDB: Waiting for the background threads to start
120108 6:43:49 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:43:49 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:43:49 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:45:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:45:54 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:45:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:45:54 InnoDB: The InnoDB memory heap is disabled
120108 6:45:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:45:54 InnoDB: Compressed tables use zlib 1.2.3
120108 6:45:54 InnoDB: Using Linux native AIO
120108 6:45:54 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:45:54 InnoDB: Completed initialization of buffer pool
120108 6:45:54 InnoDB: highest supported file format is Barracuda.
120108 6:45:54 InnoDB: Waiting for the background threads to start
120108 6:45:55 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:45:55 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:45:55 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:52:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108 6:52:45 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108 6:52:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108 6:52:45 InnoDB: The InnoDB memory heap is disabled
120108 6:52:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108 6:52:45 InnoDB: Compressed tables use zlib 1.2.3
120108 6:52:45 InnoDB: Using Linux native AIO
120108 6:52:45 InnoDB: Initializing buffer pool, size = 128.0M
120108 6:52:45 InnoDB: Completed initialization of buffer pool
120108 6:52:45 InnoDB: highest supported file format is Barracuda.
120108 6:52:45 InnoDB: 1.1.8 started; log sequence number 1595675
120108 6:52:45 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:52:45 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120109 04:46:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120109 4:46:10 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120109 4:46:10 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120109 4:46:10 InnoDB: The InnoDB memory heap is disabled
120109 4:46:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120109 4:46:10 InnoDB: Compressed tables use zlib 1.2.3
120109 4:46:10 InnoDB: Using Linux native AIO
120109 4:46:10 InnoDB: Initializing buffer pool, size = 128.0M
120109 4:46:10 InnoDB: Completed initialization of buffer pool
120109 4:46:10 InnoDB: highest supported file format is Barracuda.
120109 4:46:11 InnoDB: Waiting for the background threads to start
120109 4:46:12 InnoDB: 1.1.8 started; log sequence number 1595675
120109 4:46:12 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120109 04:46:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[/code]

3. rpm -qa mysql\* | sort outputs:

[code]
mysql-5.5.19-1.el5.art
mysql-5.5.19-1.el5.art
mysqlclient15-5.0.90-1.el5.art
mysql-devel-5.5.19-1.el5.art
mysql-devel-5.5.19-1.el5.art
mysql-libs-5.5.19-1.el5.art
mysql-libs-5.5.19-1.el5.art
mysql-server-5.5.19-1.el5.art
mysql-server-5.5.19-1.el5.art
[/code]

4. Also when i run mysql_upgrade i get this error:
[code]
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
[/code]

Im so sorry about this hassle and i really appreciate ur help 8-)

pschaff
Retired Moderator
Posts: 18276
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America
Contact:

Re: mysql wont start after upgrade

Post by pschaff » 2012/01/10 16:51:30

As far as I can see your problem is related to the use of Atomic repo packages, and is not a CentOS issue [i]per se[/i]. Unless someone else here can suggest a solution, all I can advise is to try to get help from Atomicorp [url=http://www.atomicorp.com/forum/]forum[/url] or [url=http://www.atomicorp.com/support.html]support[/url].

Post Reply