List:General Discussion« Previous MessageNext Message »
From:Walter Heck Date:January 28 2009 3:20am
Subject:Re: Mysqld fails to start
View as plain text  
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:13 AM, JD <jd1008@stripped> wrote:
> 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
> Looking for 'mysqlcheck' as: mysqlcheck
> Running 'mysqlcheck'...
> mysql.columns_priv                                 OK
> mysql.db                                           OK
> mysql.func                                         OK
> mysql.help_category
> error    : Table upgrade required. Please do "REPAIR TABLE `help_category`"
> to fix it!
> mysql.help_keyword
> error    : Table upgrade required. Please do "REPAIR TABLE `help_keyword`"
> to fix it!
> mysql.help_relation                                OK
> mysql.help_topic
> error    : Table upgrade required. Please do "REPAIR TABLE `help_topic`" to
> fix it!
> mysql.host                                         OK
> mysql.proc
> error    : Table upgrade required. Please do "REPAIR TABLE `proc`" to fix
> it!
> mysql.procs_priv                                   OK
> mysql.tables_priv                                  OK
> mysql.time_zone                                    OK
> mysql.time_zone_leap_second                        OK
> mysql.time_zone_name
> error    : Table upgrade required. Please do "REPAIR TABLE `time_zone_name`"
> to fix it!
> mysql.time_zone_transition                         OK
> mysql.time_zone_transition_type                    OK
> mysql.user                                         OK
>
> Repairing tables
> mysql.help_category                                OK
> mysql.help_keyword                                 OK
> mysql.help_topic                                   OK
> mysql.proc                                         OK
> mysql.time_zone_name                               OK
> Running 'mysql_fix_privilege_tables'...
> OK
>
> So, you want me to
>   1. Stop the server
>   2. Remove /var/lib/mysql/mysql  right?
>   3. Restart the server
> Correct?
>
>
>
> Walter Heck wrote:
>>
>> 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