Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Executing the command to start the mysql service fails to start the mysql server.

[root@localhost]# service mysqld restart
Stopping mysqld:                                           [  OK  ]
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]

Ran an strace on it

I have mysql mysql-server php php-mysql all from remi for the latest centos available versions

Here is my my.cnf file

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

I think the strace is now linked in a comment

here is a dump of mysql_safe

[root@localhost var]# mysqld_safe
110209 15:11:47 mysqld_safe Logging to '/var/log/mysqld.log'.
110209 15:11:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110209 15:11:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
share|improve this question
    
    
[root@localhost var]# rpm -V mysql S.5..... d /usr/share/man/man1/my_print_defaults.1.gz S.5..... d /usr/share/man/man1/mysql.1.gz S.5..... d /usr/share/man/man1/mysql_config.1.gz S.5..... d /usr/share/man/man1/mysql_find_rows.1.gz S.5..... d /usr/share/man/man1/mysql_waitpid.1.gz S.5..... d /usr/share/man/man1/mysqlaccess.1.gz S.5..... d /usr/share/man/man1/mysqladmin.1.gz S.5..... d /usr/share/man/man1/mysqldump.1.gz S.5..... d /usr/share/man/man1/mysqlshow.1.gz –  coolestdude1 Feb 9 '11 at 21:30

3 Answers 3

Have you tried to start mysqld_safe right from a root console to check its output?

share|improve this answer
    
110209 15:11:47 mysqld_safe Logging to '/var/log/mysqld.log'. 110209 15:11:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 110209 15:11:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended is what i get from that –  coolestdude1 Feb 9 '11 at 20:14
    
OK, if /var/log/mysqld.log is not empty, could you please also post last 10-20 lines from there (you can use tail -n 10 /var/log/mysqld.log) –  Alex Feb 9 '11 at 20:28
    
-[Note] Plugin 'FEDERATED' is disabled. /usr/libexec/mysqld: Unknown error 1146 -[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. -InnoDB: Initializing buffer pool, size = 8.0M -InnoDB: Completed initialization of buffer pool -InnoDB: Started; log sequence number 0 405409 -[ERROR] Aborting -InnoDB: Starting shutdown... -InnoDB: Shutdown completed; log sequence number 0 405409 -[Note] -mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended –  coolestdude1 Feb 9 '11 at 20:33
    
Apparently you should run mysql_upgrade –  Alex Feb 9 '11 at 20:37
    
cant run it without the daemon working [root@localhost var]# mysql_upgrade 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 –  coolestdude1 Feb 9 '11 at 20:41

What does /var/log/mysqld.log have to say?

share|improve this answer
    
how do you want me to post this to you the file is rather large –  coolestdude1 Feb 9 '11 at 20:20
    
Last 10 lines should be OK –  Alex Feb 9 '11 at 20:26
    
    
Which mysql-libs do you have? rpm -qa | grep mysql –  HTTP500 Feb 9 '11 at 21:50

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.