Installing DBD on Perl: MySQL

Install DBD: MySQL on Perl, so it takes more than half a day. MySQL is really bad
First, when the DBD: MySQL module is installed, make and the error message is printed as follows:

GCC: Language strconst not recognized

GCC: dbdimp. C: Linker input file unused because linking not done

GCC: Language strconst not recognized

GCC: mysql. C: Linker input file unused because linking not done

After checking on the Internet for a long time, I finally found on the official MySQL website that this was a bug in MySQL itself. Why did the server and GCC versions happen to be consistent with the bug, this is too bad!
The problem is a bug on MySQL:

Bug #22430-xstrconst-MT in makefile for GCC- 4.1.1 On Solaris 10
How to repeat:
Perform configure then make using gcc-4.1.1 on Solaris 10.
Solution
Remove-xstrconst and-MT from makefiles.

Finally, you can install DBD!

Next we encountered a problem.
When logging on to MySQL, the correct user name and password cannot be logged on, and the error is: client does not support Authentication Protocol requested by server; consider upgrading MYSQL client
This is also a problem of MySQL, because the new password verification mechanism is used in the MySQL server version, which requires the Client Version above 4.0, the original password function is changed to old_password ();, which makes it difficult for the client to use the password () generated on the old version.
Solution
Mysql> set password for user1 @ "localhost" = old_password ('yourpassword ');

Another point is to record here, that is, when logging on to MySQL remotely, the user must be given the remote login permission in the database, that is, user1 @ %.