List:General Discussion« Previous MessageNext Message »
From:JD Date:January 27 2009 6:29pm
Subject:Mysqld fails to start
View as plain text  
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
Thread
Mysqld fails to startJD27 Jan
  • Re: Mysqld fails to startBaron Schwartz27 Jan
    • Re: Mysqld fails to startJD27 Jan
  • Re: Mysqld fails to startAndy Shellam27 Jan
    • Re: Mysqld fails to startJD27 Jan
      • Re: Mysqld fails to startClaudio Nanni27 Jan
        • Re: Mysqld fails to startJD28 Jan
          • Re: Mysqld fails to startWalter Heck28 Jan
            • Re: Mysqld fails to startJD28 Jan
          • Re: Mysqld fails to startClaudio Nanni28 Jan
            • Re: Mysqld fails to startJD28 Jan
  • Re: Mysqld fails to startMark Goodge27 Jan
Re: Mysqld fails to startJD28 Jan
  • Re: Mysqld fails to startWalter Heck28 Jan
    • Re: Mysqld fails to startJD28 Jan
      • Re: Mysqld fails to startWalter Heck28 Jan
    • Re: Mysqld fails to startJD28 Jan