List:General Discussion« Previous MessageNext Message »
From:Walter Heck Date:January 28 2009 2:55am
Subject:Re: Mysqld fails to start
View as plain text  
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 fix this error.

I don't know how you got to where you are now, but it seems like your
system database is from MySQL 5.0.45, while you seem to be running
5.1.30.

couple of options:

1) try mysql_upgrade again, using root and it's password this time
2) remove the mysql dir inside /var/lib/mysql and then use
mysql_install_db to recreate them properly
3) just remove mysql completely and reinstall from scratch

Normally I would recommend 2, but in your case I would probably
recommend 3 since you just need mysql to run amarok2 (i would
recommend songbird anyway: http://www.getsongbird.com/ ;) ) and are
not planning on doing anything serious with mysql. Depending on the
distro you are using, it can be as simple as yum remove mysql and yum
install mysql (removing /var/lib/mysql in between). Your choice though
:)

good luck!

Walter

can you try running mysql_upgrade
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com



On Wed, Jan 28, 2009 at 3:21 AM, JD <jd1008@stripped> wrote:
> 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: Shutdown completed; log sequence number 0 44044
> 090127 18:17:17 [Note] /usr/libexec/mysqld: Shutdown complete
>
> 090127 18:17:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid
> ended
> 090127 18:17:18 mysqld_safe Starting mysqld daemon with databases from
> /var/lib/mysql
> /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
> 090127 18:17:18 [ERROR] Can't open the mysql.plugin table. Please run
> mysql_upgrade to create it.
> 090127 18:17:18  InnoDB: Started; log sequence number 0 44044
> 090127 18:17:18 [ERROR] Can't open and lock privilege tables: Table
> 'mysql.servers' doesn't exist
> 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 fix this error.
> 090127 18:17:18 [ERROR] mysql.user has no `Event_priv` column at position 29
> 090127 18:17:18 [ERROR] Cannot open mysql.event
> 090127 18:17:18 [ERROR] Event Scheduler: An error occurred when initializing
> system tables. Disabling the Event Scheduler.
> 090127 18:17:18 [Note] /usr/libexec/mysqld: ready for connections.
> Version: '5.1.30'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL
> Community Server (GPL) by Remi
>
> So, how do I fix those errors about 'mysql.plugin' and mysql.db and
> mysql.user
> For that matter why does it even have a mysql.user ??? Should it not be
> mysql.root?
>
>
>
>
>
> Walter Heck wrote:
>>
>> We're slowly getting there ;)
>> that is the root account for the mysql server, not the linux root account
>> :)
>> when you installed mysql, you chose a root password. If you didn't,
>> look up how to reset your mysql root account's password. Plenty of
>> info on the web :)
>>
>> good luck!
>>
>> Walter
>>
>> OlinData: Professional services for MySQL
>> Support * Consulting * Administration
>> http://www.olindata.com
>>
>>
>>
>> On Wed, Jan 28, 2009 at 1:47 AM, JD <jd1008@stripped> wrote:
>>
>>>
>>> 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 2009-01-21 14:12 mysql/
>>> drwxr-xr-x 53 root  root      4096 2009-01-27 14:14 ../
>>> srwxrwxrwx  1 mysql mysql        0 2009-01-27 16:35 mysql.sock=
>>> -rw-rw-r--  1 mysql mysql  5242880 2009-01-27 16:35 ib_logfile0
>>> -rw-rw-r--  1 mysql mysql 10485760 2009-01-27 16:35 ibdata1
>>> drwxrwxr-x  5 mysql mysql     4096 2009-01-27 16:35 ./
>>>
>>> /var/lib/mysql/test:
>>> total 12K
>>> drwxrwxr-x 2 mysql mysql 4096 2007-12-15 15:36 ./
>>> drwxrwxr-x 5 mysql mysql 4096 2009-01-27 16:35 ../
>>>
>>> /var/lib/mysql/ampache:
>>> total 16K
>>> -rw-rw-r-- 1 mysql mysql   65 2007-12-15 16:10 db.opt
>>> drwxrwxr-x 2 mysql mysql 4096 2007-12-15 16:10 ./
>>> drwxrwxr-x 5 mysql mysql 4096 2009-01-27 16:35 ../
>>>
>>> /var/lib/mysql/mysql:
>>> total 788K
>>> -rw-rw-r-- 1 mysql mysql  10330 2007-12-15 15:36 user.frm
>>> -rw-rw-r-- 1 mysql mysql   1024 2007-12-15 15:36
>>> time_zone_transition_type.MYI
>>> -rw-rw-r-- 1 mysql mysql      0 2007-12-15 15:36
>>> time_zone_transition_type.MYD
>>> -rw-rw-r-- 1 mysql mysql   8748 2007-12-15 15:36
>>> time_zone_transition_type.frm
>>> -rw-rw-r-- 1 mysql mysql   1024 2007-12-15 15:36 time_zone_transition.MYI
>>> -rw-rw-r-- 1 mysql mysql      0 2007-12-15 15:36 time_zone_transition.MYD
>>> -rw-rw-r-- 1 mysql mysql   8686 2007-12-15 15:36 time_zone_transition.frm
>>> -rw-rw-r-- 1 mysql mysql   1024 2007-12-15 15:36 time_zone_name.MYI
>>> -rw-rw-r-- 1 mysql mysql      0 2007-12-15 15:36 time_zone_name.MYD
>>> -rw-rw-r-- 1 mysql mysql   8606 2007-12-15 15:36 time_zone_name.frm
>>> -rw-rw-r-- 1 mysql mysql   1024 2007-12-15 15:36 time_zone.MYI
>>> -rw-rw-r-- 1 mysql mysql      0 2007-12-15 15:36 time_zone.MYD
>>> -rw-rw-r-- 1 mysql mysql   1024 2007-12-15 15:36
>>> time_zone_leap_second.MYI
>>> -rw-rw-r-- 1 mysql mysql      0 2007-12-15 15:36
>>> time_zone_leap_second.MYD
>>> -rw-rw-r-- 1 mysql mysql   8624 2007-12-15 15:36
>>> time_zone_leap_second.frm
>>> -rw-rw-r-- 1 mysql mysql   8636 2007-12-15 15:36 time_zone.frm
>>> -rw-rw-r-- 1 mysql mysql   1024 2007-12-15 15:36 tables_priv.MYI
>>> -rw-rw-r-- 1 mysql mysql      0 2007-12-15 15:36 tables_priv.MYD
>>> -rw-rw-r-- 1 mysql mysql   8947 2007-12-15 15:36 tables_priv.frm
>>> -rw-rw-r-- 1 mysql mysql   1024 2007-12-15 15:36 procs_priv.MYI
>>> -rw-rw-r-- 1 mysql mysql      0 2007-12-15 15:36 procs_priv.MYD
>>> -rw-rw-r-- 1 mysql mysql   8875 2007-12-15 15:36 procs_priv.frm
>>> -rw-rw-r-- 1 mysql mysql   1024 2007-12-15 15:36 proc.MYI
>>> -rw-rw-r-- 1 mysql mysql      0 2007-12-15 15:36 proc.MYD
>>> -rw-rw-r-- 1 mysql mysql   9691 2007-12-15 15:36 proc.frm
>>> -rw-rw-r-- 1 mysql mysql   1024 2007-12-15 15:36 host.MYI
>>> -rw-rw-r-- 1 mysql mysql      0 2007-12-15 15:36 host.MYD
>>> -rw-rw-r-- 1 mysql mysql   9416 2007-12-15 15:36 host.frm
>>> -rw-rw-r-- 1 mysql mysql  17408 2007-12-15 15:36 help_topic.MYI
>>> -rw-rw-r-- 1 mysql mysql 333276 2007-12-15 15:36 help_topic.MYD
>>> -rw-rw-r-- 1 mysql mysql   8770 2007-12-15 15:36 help_topic.frm
>>> -rw-rw-r-- 1 mysql mysql  15360 2007-12-15 15:36 help_relation.MYI
>>> -rw-rw-r-- 1 mysql mysql   7281 2007-12-15 15:36 help_relation.MYD
>>> -rw-rw-r-- 1 mysql mysql   8630 2007-12-15 15:36 help_relation.frm
>>> -rw-rw-r-- 1 mysql mysql  14336 2007-12-15 15:36 help_keyword.MYI
>>> -rw-rw-r-- 1 mysql mysql  77815 2007-12-15 15:36 help_keyword.MYD
>>> -rw-rw-r-- 1 mysql mysql   8612 2007-12-15 15:36 help_keyword.frm
>>> -rw-rw-r-- 1 mysql mysql   3072 2007-12-15 15:36 help_category.MYI
>>> -rw-rw-r-- 1 mysql mysql  20916 2007-12-15 15:36 help_category.MYD
>>> -rw-rw-r-- 1 mysql mysql   8700 2007-12-15 15:36 help_category.frm
>>> -rw-rw-r-- 1 mysql mysql   1024 2007-12-15 15:36 func.MYI
>>> -rw-rw-r-- 1 mysql mysql      0 2007-12-15 15:36 func.MYD
>>> -rw-rw-r-- 1 mysql mysql   8665 2007-12-15 15:36 func.frm
>>> -rw-rw-r-- 1 mysql mysql   9494 2007-12-15 15:36 db.frm
>>> -rw-rw-r-- 1 mysql mysql   1024 2007-12-15 15:36 columns_priv.MYI
>>> -rw-rw-r-- 1 mysql mysql      0 2007-12-15 15:36 columns_priv.MYD
>>> -rw-rw-r-- 1 mysql mysql   8820 2007-12-15 15:36 columns_priv.frm
>>> -rw-rw-r-- 1 mysql mysql    256 2007-12-15 16:10 user.MYD
>>> -rw-rw-r-- 1 mysql mysql   1314 2007-12-15 16:10 db.MYD
>>> -rw-rw-r-- 1 mysql mysql   2048 2007-12-17 00:03 user.MYI
>>> -rw-rw-r-- 1 mysql mysql   4096 2007-12-17 00:03 db.MYI
>>> drwxrwxr-x 2 mysql mysql   4096 2009-01-21 14:12 ./
>>> -rw-rw---- 1 mysql mysql  12288 2009-01-21 14:12 .swp
>>> drwxrwxr-x 5 mysql mysql   4096 2009-01-27 16:35 ../
>>>
>>>
>>> I restarted mysqld (service mysqld restart) and this is
>>> what got written in the mysql.log
>>>
>>>
>>> 090127 16:40:09 mysqld_safe Starting mysqld daemon with databases from
>>> /var/lib/mysql
>>> /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
>>> 090127 16:40:09 [ERROR] Can't open the mysql.plugin table. Please run
>>> mysql_upgrade to create it.
>>> 090127 16:40:09  InnoDB: Started; log sequence number 0 43655
>>> 090127 16:40:09 [ERROR] Can't open and lock privilege tables: Table
>>> 'mysql.servers' doesn't exist
>>> 090127 16:40:09 [ERROR] Column count of mysql.db is wrong. Expected 22,
>>> found 20. Created with MySQL 50045, now running 50130. Please use
>>> mysql_upgrade to fix this error.
>>> 090127 16:40:09 [ERROR] mysql.user has no `Event_priv` column at position
>>> 29
>>> 090127 16:40:09 [ERROR] Cannot open mysql.event
>>> 090127 16:40:09 [ERROR] Event Scheduler: An error occurred when
>>> initializing
>>> system tables. Disabling the Event Scheduler.
>>> 090127 16:40:09 [Note] /usr/libexec/mysqld: ready for connections.
>>> Version: '5.1.30'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL
>>> Community Server (GPL) by Remi
>>>
>>> So, I ssh'ed into localhost as user mysql and ran the command
>>> mysql_upgrade,
>>> and it belched out:
>>>
>>> -bash-3.2$ id
>>> uid=27(mysql) gid=27(mysql) groups=27(mysql)
>>> -bash-3.2$ mysql_upgrade
>>> Looking for 'mysql' as: mysql
>>> Looking for 'mysqlcheck' as: mysqlcheck
>>> Running 'mysqlcheck'...
>>> mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost'
>>> (using password: NO) when trying to connect
>>> FATAL ERROR: Upgrade failed
>>>
>>> I dont get it. I ssh'ed into localhost as follows:
>>> ssh mysql@localhost
>>> Why does it think I am root??
>>>
>>>
>>>
>>> Walter Heck wrote:
>>>
>>>>
>>>> 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 <jd1008@stripped> wrote:
>>>>
>>>>
>>>>>
>>>>> ls -altr /var/lib/mysql
>>>>>
>>>>>
>>>>
>>>>
>>
>>
>
Thread
Mysqld fails to startJD27 Jan
  • Re: Mysqld fails to startBaron Schwartz27 Jan
    • Re: Mysqld fails to startJD27 Jan
  • Re: Mysqld fails to startAndy Shellam27 Jan
    • Re: Mysqld fails to startJD27 Jan
      • Re: Mysqld fails to startClaudio Nanni27 Jan
        • Re: Mysqld fails to startJD28 Jan
          • Re: Mysqld fails to startWalter Heck28 Jan
            • Re: Mysqld fails to startJD28 Jan
          • Re: Mysqld fails to startClaudio Nanni28 Jan
            • Re: Mysqld fails to startJD28 Jan
  • Re: Mysqld fails to startMark Goodge27 Jan
Re: Mysqld fails to startJD28 Jan
  • Re: Mysqld fails to startWalter Heck28 Jan
    • Re: Mysqld fails to startJD28 Jan
      • Re: Mysqld fails to startWalter Heck28 Jan
    • Re: Mysqld fails to startJD28 Jan