My experience on MySQL4.1

Author: Jeanx [solves the problem and shares it with you] garbled problem: during MySQL4.1 installation, the default character settings are displayed. if your server has selected the default value of GB, UFT8 will be used and garbled characters will appear, or after you connect to the database, syntaxHighlighter. all ();

Author: Jeanx
[Resolve your own problems and share them with you]
Garbled problem:
The default character settings are displayed during MySQL4.1 installation.
If the default value of GB is selected for your server, UFT8 will cause garbled characters.
Or
You only need to execute this statement after you connect to the database.
Mysql_query ("Set Names uft8 ");
Uft8 can be changed to the encoding you need, such as e.g. gb2312.
This command can also be used for mysql command lines to display correct text.
Database Connection
Bytes -------------------------------------------------------------------------------------------
Client does not support authentication protocol requested
By server; consider upgrading MySQL client
Bytes -------------------------------------------------------------------------------------------
Since the password hash algorithm changed since MySQL 4.1 started, the database is connected.
Client does not support authentication protocol may occur.
You can solve this problem in two ways:
1:
Mysql> SET PASSWORD
-> Some_user @ some_host = OLD_PASSWORD (newpwd );
Second:
Mysql> UPDATE mysql. user SET Password = OLD_PASSWORD (newpwd)
-> WHERE Host = some_host AND User = some_user;

Mysql> flush privileges;