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 <jd1...@gmail.com> 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 <jd1...@gmail.com> 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 my...@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 <jd1...@gmail.com> wrote:


ls -altr /var/lib/mysql



Reply via email to