List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:January 28 2009 12:46am
Subject:Re: Mysqld fails to start
View as plain text  
Hi JD,
just try a simple thing,

rm /var/lib/mysql/ib_logfile1
rm /var/lib/mysql/ib_logfile2


to remove the innodb log files, sometimes you can have this problems,
did you copy the database between servers?
where are the .pid and .err files?

Claudio






2009/1/28 JD <jd1008@stripped>

> 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
>>>>>
>>>>>
>>>>
>>>
>>
>>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>

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