List:General Discussion« Previous MessageNext Message »
From:JD Date:January 28 2009 3:21am
Subject:Re: Mysqld fails to start
View as plain text  
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/mysqld: Shutdown complete

090127 19:16:10 mysqld_safe mysqld from pid file 
/var/run/mysqld/mysqld.pid ended
090127 19:16:11 mysqld_safe Starting mysqld daemon with databases from 
/var/lib/mysql
090127 19:16:11  InnoDB: Started; log sequence number 0 44044
090127 19:16:11 [Note] Event Scheduler: Loaded 0 events
090127 19:16:11 [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

Cool. Now Amarok2 cannot continue to  bitch at me, but I will try Songbird.

Cheers,

JD

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