List:General Discussion« Previous MessageNext Message »
From:JD Date:January 27 2009 11:48pm
Subject:Re: Mysqld fails to start
View as plain text  
ls -altr /var/lib/mysql
total 20548K
drwxr-xr-x  2 mysql mysql     4096 2007-12-15 15:36 test/
-rw-r--r--  1 mysql mysql  5242880 2007-12-15 15:36 ib_logfile1
drwxr-xr-x  2 mysql mysql     4096 2007-12-15 16:10 ampache/
-rw-r--r--  1 mysql mysql 10485760 2007-12-17 00:03 ibdata1
drwxr-xr-x  2 mysql mysql     4096 2009-01-21 14:12 mysql/
srwxrwxrwx  1 mysql mysql        0 2009-01-27 14:13 mysql.sock=
-rw-r--r--  1 mysql mysql  5242880 2009-01-27 14:13 ib_logfile0
drwxr-xr-x 53 root  root      4096 2009-01-27 14:14 ../
drwxr-xr-x  5 mysql mysql     4096 2009-01-27 15:48 ./


Claudio Nanni wrote:
> 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
>>>>
>>>
>>
>
>
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