Troubleshooting:MySQL will not start

From MythTV Official Wiki
Revision as of 01:11, 24 April 2006 by Daragh (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Check Assumptions

Verify that MySQL is not running

gentoo# /etc/init.d/mysql start

#ps -aef|grep mysql
root     13817 13519  0 08:30 pts/1    00:00:00 grep mysql

Review Evidence

Investigate the logs

gentoo# less /var/log/mysql/mysqld.err

Identify Problem

What does the log say?

Verify Resolution

gentoo# /etc/init.d/mysql restart
:
# ps -aef|grep mysql
mysql    15475     1  0 08:46 ?        00:00:00 /usr/sbin/mysqld --defaults-  file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
:

Success!