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 <jd1...@gmail.com> > 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=claudio.na...@gmail.com > >
