作者:
最后更新于 | 最初发布于 | 分类: 网站网络
原先使用的是MySQL 4.0.24,现在的最新版本是MySQL 4.1.13。
察看了官方网站的Upgrading MySQL on Windows:
Download the latest Windows distribution of MySQL from https://dev.mysql.com.Before upgrading MySQL, you must stop the server.
If the server is installed as a service, stop the service with the following command from the command prompt:
C:\> NET STOP MySQL
If you are not running the MySQL server as a service, use the following command to stop the server:C:\> C:\mysql\bin\mysqladmin -u root shutdown
When upgrading to MySQL 4.1.5 or higher from a previous version, or when upgrading from a version of MySQL installed from a Zip archive to a version of MySQL installed with the MySQL Installation Wizard, you must manually remove the previous installation and MySQL service (if the server is installed as a service).
To remove the MySQL service, use the following command:
C:\> C:\mysql\bin\mysqld --remove
If you do not remove the existing service, the MySQL Installation Wizard may fail to properly install the new MySQL service. (我就是这一步没有做,造成安装失败)后来运行了以下命令,删除了该服务
c:>sc delete mysql
所以我是先卸载MySQL 4.0.24,再安装的MySQL 4.1.13,安装时的默认字符集选用"latin1",虽然在BLOG中的字符集设为utf8,但是原先MySQL 安装时Server就是用的"latin1",如果现在改为"utf8",会造成数据库中的中文变成乱码。
原先root用户的密码是空,现在安装后就有密码了,所以要修改mt目录下,mt-db-pass.cgi文件中的密码。
现在运行MovableType,一切ok。
下载安装时间:一小时。
测试时间:15分钟。
难度:中。