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