Arch Linux

Llama

Banned

From: St.-Petersburg, Russia

Registered: 2008-03-03

Posts: 1,379

[SOLVED] MySQL won't start

Hi,

I'm trying to configure MySQL: ArchWiki

mysqld won't start. My /var/lib/mysql/stovepipebox.err:

120310 16:24:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/bin/mysqld: Table 'mysql.plugin' doesn't exist
120310 16:24:31 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120310 16:24:31 InnoDB: The InnoDB memory heap is disabled
120310 16:24:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120310 16:24:31 InnoDB: Compressed tables use zlib 1.2.6
120310 16:24:32 InnoDB: Initializing buffer pool, size = 128.0M
120310 16:24:32 InnoDB: Completed initialization of buffer pool
120310 16:24:32 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120310 16:24:32  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...
120310 16:24:32  InnoDB: Waiting for the background threads to start
120310 16:24:33 InnoDB: 1.1.8 started; log sequence number 1595675
120310 16:24:33 [Note] Recovering after a crash using mysql-bin
120310 16:24:33 [Note] Starting crash recovery...
120310 16:24:33 [Note] Crash recovery finished.
120310 16:24:33 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120310 16:24:33 mysqld_safe mysqld from pid file /var/lib/mysql/stovepipebox.pid ended

Any ideas?

Last edited by Llama (2012-03-11 15:35:41)

Gcool

Member

Registered: 2011-08-16

Posts: 1,456

Re: [SOLVED] MySQL won't start

Try running:

# mysql_install_db --user=mysql --ldata=/var/lib/mysql/

And afterwards try to start mysqld again. More detailed info can be found here.

Last edited by Gcool (2012-03-10 13:39:07)

---

Burninate!

Llama

Banned

From: St.-Petersburg, Russia

Registered: 2008-03-03

Posts: 1,379

Re: [SOLVED] MySQL won't start

Thanks! Unfortunately, I'm quite new to MySQL...

# mysql_install_db --user=mysql --=/var/lib/mysql/

FATAL ERROR: Could not find ./bin/my_print_defaults Why the leading period?

If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.

If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.

BTW, it exists:

$ locate my_print_defaults
/usr/bin/my_print_defaults

Last edited by Llama (2012-03-10 14:08:19)

Gcool

Member

Registered: 2011-08-16

Posts: 1,456

Re: [SOLVED] MySQL won't start

Try specifying the basedir. It's probably trying to look for /bin/my_print_defaults instead of /usr/bin/my_print_defaults. So that would be something among the lines of:

# mysql_install_db --user=mysql --basedir=/usr/ --ldata=/var/lib/mysql/

---

Burninate!

Llama

Banned

From: St.-Petersburg, Russia

Registered: 2008-03-03

Posts: 1,379

Re: [SOLVED] MySQL won't start

Thanks, Gcool! mysqld starts and runs, but Joomla Web Installer still says

Database Support: No

This can be another story, though.

UPD:

Another story all right: I've turned out to be sloppy about the PHP part of LAMP. Thank you again, Gcool!

Last edited by Llama (2012-03-11 15:35:03)