Hello List,
mysqld fails to start, and emits the following
error messages in /var/log/mysqld.log
090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090127 10:00:30 [ERROR] Can't open the mysql.plugin
Hello JD,
You need to look beyond the first error messages:
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090127 10:00:30 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
but keep reading:
090127 10:00:30 InnoDB: Operating system error number 13
.) Make sure this is done, then MySQL will start, then you can run
mysql_upgrade.
HTH,
Andy
JD wrote:
Hello List,
mysqld fails to start, and emits the following
error messages in /var/log/mysqld.log
090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
/usr
JD wrote:
Hello List,
mysqld fails to start, and emits the following
error messages in /var/log/mysqld.log
090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090127 10:00:30 [ERROR] Can't open
I am running as root.
I dont understand what rights or permissions mysqld needs
beyond those of root. Also, ./ibdata1 is relative to what path?
I get this message no matter what dir is my current working dir.
I searched in my home dir and in /root home dir. There is no such
file or directory
. The second
error is the one about InnoDB not having access rights to the directory.
Check that /var/lib/mysql is writeable by the MySQL user (usually
MySQL.) Make sure this is done, then MySQL will start, then you can
run mysql_upgrade.
HTH,
Andy
JD wrote:
Hello List,
mysqld fails
, then you can
run mysql_upgrade.
HTH,
Andy
JD wrote:
Hello List,
mysqld fails to start, and emits the following
error messages in /var/log/mysqld.log
090127 10:00:30 mysqld_safe Starting mysqld daemon with databases
from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't
will start, then you can
run mysql_upgrade.
HTH,
Andy
JD wrote:
Hello List,
mysqld fails to start, and emits the following
error messages in /var/log/mysqld.log
090127 10:00:30 mysqld_safe Starting mysqld daemon with databases
from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't
Ah, try this:
chmod ug+rw ibdata1 and the same for your iblogfile0 and iblogfile1 files..
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Wed, Jan 28, 2009 at 12:48 AM, JD jd1...@gmail.com wrote:
ls -altr /var/lib/mysql
--
, then MySQL will start, then you can run
mysql_upgrade.
HTH,
Andy
JD wrote:
Hello List,
mysqld fails to start, and emits the following
error messages in /var/log/mysqld.log
090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
/usr/libexec/mysqld: Table
I did the chmod. Then
# ls -latrR /var/lib/mysql
/var/lib/mysql:
total 20548K
drwxrwxr-x 2 mysql mysql 4096 2007-12-15 15:36 test/
-rw-rw-r-- 1 mysql mysql 5242880 2007-12-15 15:36 ib_logfile1
drwxrwxr-x 2 mysql mysql 4096 2007-12-15 16:10 ampache/
drwxrwxr-x 2 mysql mysql 4096
, then you can run mysql_upgrade.
HTH,
Andy
JD wrote:
Hello List,
mysqld fails to start, and emits the following
error messages in /var/log/mysqld.log
090127 10:00:30
OK, I located a weblog on how to change the password
and it worked.
I then stopped and started the serever, and this is what it belched out
in the mysqld.log:
090127 18:17:16 [Note] /usr/libexec/mysqld: Normal shutdown
090127 18:17:16 InnoDB: Starting shutdown...
090127 18:17:17 InnoDB:
mysql.user is a table name, it is in the form of database_name.table_name.
Mysql has a system database conveniently called mysql :)
090127 18:17:18 [ERROR] Column count of mysql.db is wrong. Expected 22, found
20. Created with MySQL 50045, now running 50130. Please use mysql_upgrade to
fix
Problem with yum remove mysql is that it will also remove all it's
dependents,
whereas yum install mysql will not restore the dependents.
Also, you are probably right re: 5.0.x and 5.1.x
At anywho, I ran:
}# mysql_upgrade --user=root --password='theNewPassword'
Looking for 'mysql' as: mysql
Actually, just restarting the server should do the trick. It seems
like mysql_upgrade did it's job correctly.
Can you restart teh server and check the logs?
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Wed, Jan 28, 2009 at
Hey... Thanks a *LOT Walter!!!* *It WORKED!!!*
The mysqld.log file now says:
090127 19:16:10 [Note] /usr/libexec/mysqld: Normal shutdown
090127 19:16:10 InnoDB: Starting shutdown...
090127 19:16:10 InnoDB: Shutdown completed; log sequence number 0 44044
090127 19:16:10 [Note]
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: root
To: mysql@lists.mysql.com
Subject: MySQL daemon fails to start
Description:
mysqld fails with error
070827 10:52
18 matches
Mail list logo