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 <jd1008@stripped <mailto:jd1008@stripped>>
>
> 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=1
>
>
