Re: Mysqld fails to start

2009-01-27 Thread JD
Hey... Thanks a *LOT Walter!!!* *It WORKED!!!* The mysqld.log file now says: 090127 19:16:10 [Note] /usr/libexec/mysqld: Normal shutdown 090127 19:16:10 InnoDB: Starting shutdown... 090127 19:16:10 InnoDB: Shutdown completed; log sequence number 0 44044 090127 19:16:10 [Note] /usr/libexec/mysq

Re: Mysqld fails to start

2009-01-27 Thread Walter Heck
Actually, just restarting the server should do the trick. It seems like mysql_upgrade did it's job correctly. Can you restart teh server and check the logs? Walter OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Wed, Jan 28, 2009 at 4:

Re: Mysqld fails to start

2009-01-27 Thread JD
Problem with yum remove mysql is that it will also remove all it's dependents, whereas yum install mysql will not restore the dependents. Also, you are probably right re: 5.0.x and 5.1.x At anywho, I ran: }# mysql_upgrade --user=root --password='theNewPassword' Looking for 'mysql' as: mysql

Re: Mysqld fails to start

2009-01-27 Thread Walter Heck
mysql.user is a table name, it is in the form of database_name.table_name. Mysql has a "system database" conveniently called mysql :) > 090127 18:17:18 [ERROR] Column count of mysql.db is wrong. Expected 22, found > 20. Created with MySQL 50045, now running 50130. Please use mysql_upgrade to > f

Re: Mysqld fails to start

2009-01-27 Thread JD
OK, I located a weblog on how to change the password and it worked. I then stopped and started the serever, and this is what it belched out in the mysqld.log: 090127 18:17:16 [Note] /usr/libexec/mysqld: Normal shutdown 090127 18:17:16 InnoDB: Starting shutdown... 090127 18:17:17 InnoDB: Shu

Re: Mysqld fails to start

2009-01-27 Thread JD
I stopped mysqld. I removed those logfiles I did not copy any databe between servers. I only have one machine. I would not even know what to copy, as I know nothing about databases. I have no idea where the .pid and the .err files came from. I restarted the daemon, and this is what it wrote into

Re: Mysqld fails to start

2009-01-27 Thread JD
I did the chmod. Then # ls -latrR /var/lib/mysql /var/lib/mysql: total 20548K drwxrwxr-x 2 mysql mysql 4096 2007-12-15 15:36 test/ -rw-rw-r-- 1 mysql mysql 5242880 2007-12-15 15:36 ib_logfile1 drwxrwxr-x 2 mysql mysql 4096 2007-12-15 16:10 ampache/ drwxrwxr-x 2 mysql mysql 4096 20

Re: Mysqld fails to start

2009-01-27 Thread Claudio Nanni
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 > ls -altr /var/lib/mysql

Re: Mysqld fails to start

2009-01-27 Thread Walter Heck
Ah, try this: "chmod ug+rw ibdata1" and the same for your iblogfile0 and iblogfile1 files.. Walter OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Wed, Jan 28, 2009 at 12:48 AM, JD wrote: > ls -altr /var/lib/mysql -- MySQL General

Re: Mysqld fails to start

2009-01-27 Thread JD
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 mysq

Re: Mysqld fails to start

2009-01-27 Thread Claudio Nanni
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.

Re: Mysqld fails to start

2009-01-27 Thread JD
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.

Re: Mysqld fails to start

2009-01-27 Thread JD
I am running as root. I dont understand what rights or permissions mysqld needs beyond those of root. Also, ./ibdata1 is relative to what path? I get this message no matter what dir is my current working dir. I searched in my home dir and in /root home dir. There is no such file or directory cal

Re: Mysqld fails to start

2009-01-27 Thread Mark Goodge
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

Re: Mysqld fails to start

2009-01-27 Thread Andy Shellam
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

Re: Mysqld fails to start

2009-01-27 Thread Baron Schwartz
Hello JD, You need to look beyond the first error messages: > /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. but keep reading: > 090127 10:00:30 InnoDB: Operating system error number