I stopped mysqld.
I removed those logfiles
I did not copy any databe between servers.
I only have one machine. I would not even know
what to copy, as I know nothing about databases.
I have no idea where the .pid and the .err files
came from.
I restarted the daemon, and this is what it wrote into
the /var/messages/mysqd.log
090127 16:54:15 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090127 16:54:15 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
090127 16:54:15 InnoDB: Log file ./ib_logfile0 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090127 16:54:15 InnoDB: Log file ./ib_logfile1 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090127 16:54:15 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090127 16:54:15 InnoDB: Started; log sequence number 0 44044
090127 16:54:15 [ERROR] Can't open and lock privilege tables: Table
'mysql.servers' doesn't exist
090127 16:54:15 [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 this error.
090127 16:54:15 [ERROR] mysql.user has no `Event_priv` column at position 29
090127 16:54:15 [ERROR] Cannot open mysql.event
090127 16:54:15 [ERROR] Event Scheduler: An error occurred when
initializing system tables. Disabling the Event Scheduler.
090127 16:54:15 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306
MySQL Community Server (GPL) by Remi
Claudio Nanni wrote:
Hi JD,
just try a simple thing,
rm /var/lib/mysql/ib_logfile1
rm /var/lib/mysql/ib_logfile2
to remove the innodb log files, sometimes you can have this problems,
did you copy the database between servers?
where are the .pid and .err files?
Claudio
2009/1/28 JD <jd1...@gmail.com <mailto:jd1...@gmail.com>>
ls -altr /var/lib/mysql
total 20548K
drwxr-xr-x 2 mysql mysql 4096 2007-12-15 15:36 test/
-rw-r--r-- 1 mysql mysql 5242880 2007-12-15 15:36 ib_logfile1
drwxr-xr-x 2 mysql mysql 4096 2007-12-15 16:10 ampache/
-rw-r--r-- 1 mysql mysql 10485760 2007-12-17 00:03 ibdata1
drwxr-xr-x 2 mysql mysql 4096 2009-01-21 14:12 mysql/
srwxrwxrwx 1 mysql mysql 0 2009-01-27 14:13 mysql.sock=
-rw-r--r-- 1 mysql mysql 5242880 2009-01-27 14:13 ib_logfile0
drwxr-xr-x 53 root root 4096 2009-01-27 14:14 ../
drwxr-xr-x 5 mysql mysql 4096 2009-01-27 15:48 ./
Claudio Nanni wrote:
JD,
please post the ouput from:
ls -altr /var/lib/mysql
thanks
Claudio
JD wrote:
Deamon runs as root.
ls -ld /var/lib/mysql/
drwxr-xr-x 5 mysql mysql 4096 2009-01-27 10:00 /var/lib/mysql/
So what other perms does root need?
Andy Shellam wrote:
Hi JD,
I believe the error about mysql.plugin is a red
herring - it needs fixing, but it's not the reason
MySQL isn't starting. 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 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 table. Please run mysql_upgrade to
create it.
090127 10:00:30 InnoDB: Operating system error
number 13 in a file operation.
InnoDB: The error means mysqld does not have the
access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
090127 10:00:30 mysqld_safe mysqld from pid file
/var/run/mysqld/mysqld.pid ended
So, I tried to run mysql_upgrade:
# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck'...
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
So, it seems like a chicken and egg thing???
Cannot run mysql_upgrade bcause the server is not
running.
Cannot run the server because I must first run
mysql_upgrade.
PS: I know nothing about configuring and setting
up mysql.
Amarok2 needs a running mysqld in order to organize
music tracks collections ... etc.
I need help to get mysqld started and running and
to add users
that are allowed to access and modify their databases.
Could someone send me a set of user commands to
get thing going?
These are all the "mysql" related packages on my
system:
mysql-5.1.30-1.fc7.remi
mysql-libs-5.1.30-1.fc7.remi
sqlite-3.4.2-1.fc7
libdbi-dbd-pgsql-0.8.1a-2.fc7
sqlite-3.4.2-1.fc7
postgresql-libs-8.2.9-1.fc7
hsqldb-1.8.0.8-1jpp.5.fc7
postgresql-libs-8.2.9-1.fc7
mysql-server-5.1.30-1.fc7.remi
mysqlclient15-5.0.67-1.fc7.remi
mod_auth_mysql-3.0.0-3.1
mysqlclient15-5.0.67-1.fc7.remi
sqlite2-2.8.17-1.fc6
php-pgsql-5.2.8-1.fc7.remi
sqlite-devel-3.4.2-1.fc7
postgresql-python-8.2.9-1.fc7
postgresql-8.2.9-1.fc7
postgresql-server-8.2.9-1.fc7
mono-data-sqlite-1.2.3-5.fc7
mysql-devel-5.1.30-1.fc7.remi
mysqlclient15-devel-5.0.67-1.fc7.remi
mod_auth_pgsql-2.0.3-3
mysql-connector-odbc-3.51.12-2.2
libdbi-dbd-mysql-0.8.1a-2.fc7
mysqlclient15-devel-5.0.67-1.fc7.remi
php-mysql-5.2.8-1.fc7.remi
Cheers,
JD
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
