qauser@qa-rhas3-ia64 michelle]$ rpm -qa | grep MySQL MySQL-advanced-gpl-debuginfo-5.1.29-0.rhel3 MySQL-server-advanced-gpl-5.1.29-0.rhel3 MySQL-client-advanced-gpl-5.1.29-0.rhel3 [qauser@qa-rhas3-ia64 michelle]$ sudo rpm -e MySQL-server-advanced-gpl-5.1.29-0.rhel3 [qauser@qa-rhas3-ia64 michelle]$ sudo rpm -ivh MySQL-server-advanced-gpl-5.1.29-0.rhel3.ia64.rpm Preparing... ########################################### [100%] 1:MySQL-server-advanced-g########################################### [100%] ERROR: 1136 Column count doesn't match value count at row 1 081024 1:29:12 [ERROR] Aborting 081024 1:29:12 [Note] /usr/sbin/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. You can try to start the mysqld daemon with: shell> /usr/sbin/mysqld --skip-grant & and use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com/. Please consult the MySQL manual section 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source are the MySQL email archives available at http://lists.mysql.com/. Please check all of the above before mailing us! And remember, if you do mail us, you MUST use the /usr/bin/mysqlbug script! Starting MySQL.[ OK ] Giving mysqld 2 seconds to start [qauser@qa-rhas3-ia64 michelle]$ ps -ef | grep mysql root 30044 1 0 01:29 pts/1 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/qa-rhas3-ia64.mysql.com.pid mysql 30099 30044 0 01:29 pts/1 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/qa-rhas3-ia64.mysql.com.err --pid-file=/var/lib/mysql/qa-rhas3-ia64.mysql.com.pid qauser 30121 29906 0 01:31 pts/1 00:00:00 grep mysql [qauser@qa-rhas3-ia64 michelle]$ mysql --user=root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.29-rc-advanced-gpl MySQL Advanced Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show tables -> ; ERROR 1046 (3D000): No database selected mysql> exit Bye [qauser@qa-rhas3-ia64 michelle]$ mysql -u root mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.1.29-rc-advanced-gpl MySQL Advanced Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show tables; +---------------------------+ | Tables_in_mysql | +---------------------------+ | columns_priv | | db | | event | | func | | general_log | | help_category | | help_keyword | | help_relation | | help_topic | | host | | ndb_binlog_index | | plugin | | proc | | procs_priv | | servers | | slow_log | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name | | time_zone_transition | | time_zone_transition_type | | user | +---------------------------+ 23 rows in set (0.00 sec) mysql> exit Bye [qauser@qa-rhas3-ia64 michelle]$ sudo rpm -e MySQL-server-advanced-gpl-5.1.29-0.rhel3 [qauser@qa-rhas3-ia64 michelle]$ sudo rpm -ivh MySQL-server-advanced-gpl-5.1.29-0.rhel3.ia64.rpm Preparing... ########################################### [100%] 1:MySQL-server-advanced-g########################################### [100%] ERROR: 1136 Column count doesn't match value count at row 1 081024 1:33:20 [ERROR] Aborting 081024 1:33:20 [Note] /usr/sbin/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. You can try to start the mysqld daemon with: shell> /usr/sbin/mysqld --skip-grant & and use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com/. Please consult the MySQL manual section 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source are the MySQL email archives available at http://lists.mysql.com/. Please check all of the above before mailing us! And remember, if you do mail us, you MUST use the /usr/bin/mysqlbug script! Starting MySQL.[ OK ] Giving mysqld 2 seconds to start [qauser@qa-rhas3-ia64 michelle]$ ps -ef | grep mysql root 30193 1 0 01:33 pts/1 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/qa-rhas3-ia64.mysql.com.pid mysql 30248 30193 0 01:33 pts/1 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/qa-rhas3-ia64.mysql.com.err --pid-file=/var/lib/mysql/qa-rhas3-ia64.mysql.com.pid qauser 30267 29906 0 01:36 pts/1 00:00:00 grep mysql [qauser@qa-rhas3-ia64 michelle]$ sudo rpm -e MySQL-server-advanced-gpl-5.1.29-0.rhel3 [qauser@qa-rhas3-ia64 michelle]$ ps -ef | grep mysql qauser 30293 29906 0 01:36 pts/1 00:00:00 grep mysql [qauser@qa-rhas3-ia64 michelle]$