i ran yum update now i cant start mysql please help! log file is
150916 06:21:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 481 error messages,
but it should contain at least 641 error messages.
Check that the above file is the right version for this program!
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
/usr/libexec/mysqld: Unknown error 1146
150916 6:21:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
150916 6:21:19 InnoDB: Initializing buffer pool, size = 2.0M
150916 6:21:19 InnoDB: Completed initialization of buffer pool
150916 6:21:20 InnoDB: Started; log sequence number 0 78431534
150916 6:21:20 [ERROR] /usr/libexec/mysqld: unknown option '--skip-bdb'
150916 6:21:20 [ERROR] Aborting
150916 6:21:20 InnoDB: Starting shutdown...
150916 6:21:25 InnoDB: Shutdown completed; log sequence number 0 78431534
150916 6:21:25 [Note]
150916 06:21:25 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
mysql problem after yum update
Re: mysql problem after yum update
You've almost certainly installed mixed versions of your mysql packages. Post the output from rpm -qa \*mysql\* | sort so we can see what you have.
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke
Re: mysql problem after yum update
Looks like I have 5 versions
[root@vps ~]# rpm -qa \*mysql\*
mysqlclient15-5.0.91-1.jason.1
mysql-server-5.1.58-jason.1
mysql-5.0.95-5.el5_9
php-mysql-5.3.25-1.w5
mysql-5.1.58-jason.1
[root@vps ~]# rpm -qa \*mysql\*
mysqlclient15-5.0.91-1.jason.1
mysql-server-5.1.58-jason.1
mysql-5.0.95-5.el5_9
php-mysql-5.3.25-1.w5
mysql-5.1.58-jason.1
Re: mysql problem after yum update
Yes, you've installed some weird third party repo that supplies an incompatible version of mysql. Worse, bits of it are actually older than the one that CentOS supplies. You need to get them in sync so I'd start by trying yum upgrade mysql\* and see if that offers to correct the problem. What you should have installed on a 5.11 system is
Oh, right, so mysql-server is the problem package here in that it is 5.1.58 and the CentOS supplied version is 5.0.95 so try yum downgrade mysql-server mysql and see if that offers you 5.0.95. If it does then say yes. You could also try with --disablerepo=\* --enablerepo=base,updates to see if that allows the downgrade correctly.
You've really got quite a mess there - php-mysql 5.3.25? CentOS 5 ships 5.1.6 not 5.3 and w5 presumably means webtatic I don't believe that either utterramblings (the jason stuff) or webtatic are listed in the additional repos page on the wiki and they're not ones we generally recommend to anyone. https://wiki.centos.org/AdditionalResou ... positories
Code: Select all
mysql-5.0.95-5.el5_9
mysql-server-5.0.95-5.el5_9
You've really got quite a mess there - php-mysql 5.3.25? CentOS 5 ships 5.1.6 not 5.3 and w5 presumably means webtatic I don't believe that either utterramblings (the jason stuff) or webtatic are listed in the additional repos page on the wiki and they're not ones we generally recommend to anyone. https://wiki.centos.org/AdditionalResou ... positories
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke