Upgrade to MySQL 5.0.17 four problems that you must encounter

mysql| problem

1 Chinese questions

When using the MySQL instance Configuration tool, the character set used is set to GBK

2 password problem: the password set at installation cannot be used with phpMyAdmin access

Mysql> SET PASSWORD for
-> ' root ' @ ' localhost ' = old_password (' root ');

3 field Strictly check the problem

Remove the Enable Strict mode from the instance Configuration tool

4 phpMyAdmin garbled problem

Language:chinese Simplified (zh-utf-8)

MySQL Connection Proofing: Gbk_chinese_ci

The new database and varchar fields such as the collation of: Gbk_chinese_ci