MySQL 5.0升级问题

我已经将我的Ubuntu服务器从8.04 LTS更新到了10.04 LTS，并且面临着MySQL服务器安装的问题。我已经做的步骤：

1) Removed MySQL on Ubuntu 8.04 2) Updated OS to Ubuntu 10.04 LTS 3) Installed MySQL 5.1 from repositories 4) Stopped new MySQL server and ran mysql_upgrade

这是我得到的错误：

 Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect FATAL ERROR: Upgrade failed

这里是同时写入的日志条目：

 111205 2:56:56 [Note] Plugin 'FEDERATED' is disabled. 111205 2:56:56 InnoDB: Started; log sequence number 52 181390868 111205 2:56:56 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50051, now running 50141. Please use mysql_upgrade to fix this error. 111205 2:56:56 [ERROR] mysql.user has no `Event_priv` column at position 29 111205 2:56:56 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 111205 2:56:56 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.41-3ubuntu12.10' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 111205 2:56:57 [Note] /usr/sbin/mysqld: Normal shutdown 111205 2:56:57 InnoDB: Starting shutdown... 111205 2:56:57 InnoDB: Shutdown completed; log sequence number 52 181390868 111205 2:56:57 [Note] /usr/sbin/mysqld: Shutdown complete

至less有人能指出我正确的方向来解决这个问题吗？我GOOGLE了，花了很多时间自己来解决这个问题。感谢您的任何帮助。

更新1

我已经备份并删除了/var/lib/mysql/mysql
运行mysql_install_db
mysqld –skip-grant-tables –user = mysql
mysql_upgrade

我收到以下错误：

mysql_upgrade查找'mysql'as：mysql查找'mysqlcheck'as：mysqlcheck用连接参数运行'mysqlcheck'：'–port = 3306''–socket = / var / run / mysqld / mysqld.sock'mysqlcheck：出现错误：2002：尝试连接时无法通过套接字'/var/run/mysqld/mysqld.sock'（111）连接到本地MySQL服务器致命错误：升级失败

备份所有/ var / lib / mysql / *目录，然后删除/ var / lib / mysql / mysql并运行

 mysql_installdb

这将创build一个新的MySQL数据库，并允许您的服务器启动。那么首先要做的就是运行mysql_upgrade来迁移你的数据库。