I compiled some experience about MySQL4.1_PHP tutorial

Author: Jeanx
[Solve the problems I encountered and share them with everyone]
Garbled character problem:
During the installation process of MySQL 4.1, there is a default character setting, which is shown in the figure below
If your server has chosen to default to GB, UFT8 will be used and garbled characters will appear
or
As long as you connect to the database, execute this sentence first
mysql_query("Set Names uft8" ; -------------------------------------------------- ---------------------------------------------
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
--------------------------------------- -------------------------------------------------- --
Due to the password hash algorithm change starting from MySQL version 4.1, the problem of Client does not support authentication protocol may occur when connecting to the database
.
This can be solved by the following two methods
One:
mysql> SET PASSWORD FOR
-> 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;

http://www.bkjia.com/PHPjc/532005.html

www.bkjia.com

truehttp: //www.bkjia.com/PHPjc/532005.htmlTechArticleAuthor: Jeanx [Solve the problems you encountered and share them with everyone] Garbled code problem: In MySQL4.1 During the installation process, the default character settings are shown in the picture below. If you are in...