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
