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
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:
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
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
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
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 mess
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
>>
>>>> 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.
>>>>
>>
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
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.
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.
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,
mysql
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
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]
lly
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/m
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
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 o
ter-Id: [EMAIL PROTECTED]
>Originator: root
>Organization: Credics Technologies
>MySQL support: [none]
>Synopsis: mysqld fails to start
>Severity: critical
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: <[ sw-b
18 matches
Mail list logo
