MySQL not working by default

[Loïc Minier]

Hi,

When booting LAMP image, MySQL doesn't work by default:
% mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

% mysqladmin ping
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

No mysql process is running; if one restarts mysql, it fails to start in the same way as it fails to start on boot, from /var/log/mysqld.err:
121019 00:13:04 mysqld_safe Starting mysqld daemon with databases from /var/mysql
/usr/lib/mysql5/mysqld: Table 'mysql.plugin' doesn't exist
121019 0:13:04 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121019 0:13:04 [Warning] /usr/lib/mysql5/mysqld: unknown option '--loose-skip-innodb'
121019 0:13:04 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
121019 00:13:04 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended

I suspect either a config is missing, or some final installation step wasn't run.

Running mysql_upgrade fails with the /tmp sock error too.

Cheers,

[Marcin Juszkiewicz (hrw)]

Fix sent to OpenEmbedded ML

[Marcin Juszkiewicz (hrw)]

Need to rewrite fix.

[Marcin Juszkiewicz (hrw)]

updated patch sent to ML

[Marcin Juszkiewicz (hrw)]

fix got merged