mysql upgrade to 4.1 fix
Posted on August 21, 2006
Filed Under Computing |
I recently did an emerge on this gentoo box that upgraded mysql to version 4.1. In turn, it broke mysql. If you are getting errors such as this in /var/log/mysqld.err:
Version: ‘4.1.19-log’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 Gentoo Linux mysql-4.1.19
060821 23:57:36 [Warning] ‘./mysql/user’ had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
060821 23:57:36 [Warning] ‘./mysql/host’ had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
060821 23:57:36 [Warning] ‘./mysql/db’ had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
060821 23:57:36 [Warning] ‘./mysql/tables_priv’ had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
060821 23:57:36 [Warning] ‘./mysql/columns_priv’ had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
060821 23:57:36 [Warning] ‘./mysql/func’ had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
060821 23:58:10 [Note] /usr/sbin/mysqld: Normal shutdown
Then as root do this:
mysqd_safe --skip-grant-tables --user=root &
mysql_fix_privilege_tables
pkill mysqld
/etc/init.d/mysql restart
Restart any other services that uses mysql and relax.
Huge thanks to Nathan.
Comments
Leave a Reply