Bug #76104 Mysql refuses to start
| Submitted: | 2 Mar 2015 17:11 | Modified: | 9 Mar 2015 22:31 |
|---|---|---|---|
| Reporter: | Fabrizio Bartolomucci | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | OS: | Other (Centos) | |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | Mysql server refuses to start and even the mysql command gives erros | ||
[2 Mar 2015 17:11]
Fabrizio Bartolomucci
[2 Mar 2015 17:14]
Fabrizio Bartolomucci
I also tried to renistall mysql by removing and replacing the DBs but the problem remained unresolved.
[2 Mar 2015 23:19]
MySQL Verification Team
Thank you for the bug report. MySQL server version? CentOS version? Are you able to attach the err log file /var/log/mysqld.log?. Thanks.
[3 Mar 2015 10:31]
Fabrizio Bartolomucci
Server is Centos 6. The mysql version is the one found by yum install: namely:
mysql i686 5.1.73-3.el6_5 @base 2.3 M
mysql-server i686 5.1.73-3.el6_5 @base 24 M
At present I moved the support to another mysql server and trying to reinstall it. Yet after the reinstall it fails on restart with:
sudo /etc/init.d/mysqld start
Initializing MySQL database: Installing MySQL system tables...
150303 11:03:33 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
150303 11:03:33 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'
150303 11:03:33 [ERROR] Aborting
150303 11:03:33 [Note]
Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.
You can try to start the mysqld daemon with:
shell> /usr/libexec/mysqld --skip-grant &
and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.
Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.
Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!
[FAILED]
[3 Mar 2015 21:19]
MySQL Verification Team
Please check if your my.cnf has the correct paths of basedir and datadir. Thanks.
[3 Mar 2015 21:26]
Fabrizio Bartolomucci
I checked all kinds of cnf files including those in the distribution. At any rate what should be the correct paths for those basedir and datadir things?
[9 Mar 2015 22:27]
MySQL Verification Team
Thank you for the feedback. This issue looks like a wrong process of install/upgrade and not MySQL bug.
[9 Mar 2015 22:31]
MySQL Verification Team
miguel@miguelbr ~]$ cat /etc/redhat-release CentOS release 6.6 (Final) [miguel@miguelbr ~]$ mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.1.73 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.057 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.