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=arch...@jab.org
