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 >>>>> >>>>> >>>> >>>> >> >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
