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
>>>>
>>>
>>
>
>
