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
>>>>
>>>>
>>>
>
>
