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
/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
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
So, I tried to run mysql_upgrade:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: 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: