Hi,
I messed something up in my FreeBSD Jail.
Now MySQL doesn't start anymore.
Regards
bsus
I messed something up in my FreeBSD Jail.
Now MySQL doesn't start anymore.
Code:
cat /var/db/mysql/*.err
110814 19:20:53 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
/usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
110814 19:20:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110814 19:20:53 InnoDB: The InnoDB memory heap is disabled
110814 19:20:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110814 19:20:53 InnoDB: Compressed tables use zlib 1.2.3
110814 19:20:53 InnoDB: Initializing buffer pool, size = 128.0M
110814 19:20:53 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
110814 19:20:53 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
110814 19:20:53 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...
110814 19:20:53 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: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
110814 19:20:54 InnoDB: Waiting for the background threads to start
110814 19:20:55 InnoDB: 1.1.8 started; log sequence number 0
110814 19:20:55 [ERROR] /usr/local/libexec/mysqld: unknown option '--safe-show-database'
110814 19:20:55 [ERROR] Aborting
110814 19:20:55 InnoDB: Starting shutdown...
110814 19:20:56 InnoDB: Shutdown completed; log sequence number 1595675
110814 19:20:56 [Note] /usr/local/libexec/mysqld: Shutdown complete
110814 19:20:56 mysqld_safe mysqld from pid file /var/db/mysql/famp.fritz.box.pid ended
110814 19:24:11 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
/usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
110814 19:24:11 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110814 19:24:11 InnoDB: The InnoDB memory heap is disabled
110814 19:24:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110814 19:24:11 InnoDB: Compressed tables use zlib 1.2.3
110814 19:24:11 InnoDB: Initializing buffer pool, size = 128.0M
110814 19:24:11 InnoDB: Completed initialization of buffer pool
110814 19:24:11 InnoDB: highest supported file format is Barracuda.
110814 19:24:11 InnoDB: Waiting for the background threads to start
110814 19:24:12 InnoDB: 1.1.8 started; log sequence number 1595675
110814 19:24:12 [ERROR] /usr/local/libexec/mysqld: unknown option '--safe-show-database'
110814 19:24:12 [ERROR] Aborting
110814 19:24:12 InnoDB: Starting shutdown...
110814 19:24:13 InnoDB: Shutdown completed; log sequence number 1595675
110814 19:24:13 [Note] /usr/local/libexec/mysqld: Shutdown complete
110814 19:24:13 mysqld_safe mysqld from pid file /var/db/mysql/famp.fritz.box.pid ended
[root@famp /usr/local/etc/rc.d]# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=29912'
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
Regards
bsus