Solve MySQL database connection issues

xiaoxiao2021-03-06  34

This two days can be rest enough

Every day is 11 o'clock more

I haven't so cool for a long time.

I have a lot of things, I didn't feel tired before four hours in the afternoon, I also solved a problem that I have never solved for a long time.

Ha ha

Really cool

I used to give a forum with VBB before giving a college class.

I want to upgrade now

But I can't do it several times.

Download a newest 3.0

But to the database, there is always a problem.

Decided to give up

I stick to it today.

Finally

The reason for the emergence is

The second step is to prompt the Have Permission to Connect to Server, and I have seen it to the VBB official website but I can't solve it.

Finally, I think of a phpmyadmin, I want to use this management software to see.

The result is not connected with this, it is good to find the direction by one of them.

Error Tip 1251 - Client Does Not Support Authentication Protocol Requested by Server; Consider Upgrading MySQL Client

Finally at this website

Http://ww2.7747.net/Article/comp/pute/200411/2456.html

Specific solution

Although mysql 4.1.7 has been released and become official recommendation version, 4.0.x series does not stop updating and bug fix, in fact, Most of the mysql on the server is 3.x version, huh, huh. After updating to the version 4.1.17 version of MySQL, it is found that you need to use the MySQLI extension to use the database. Otherwise, 1251 - Client Does Not Support Authentication Protocol Requested by Server; Consider Upgrading MySQL Client Tips, this is very wonderful, I don't have Studying specific problems, just switching to mysqli extensions, actually using the mysql extension before adding the password, but after the password is added to the root, there is a tips that the above client version is too low. Log in to the mysql server with the root, execute mysql> set password for user1 @ "localhost" = Old_password ('YourPassword'); reason is because the new password verification mechanism is used in the MySQL server version you use, this requires the client's version to More than 4.0 or more, the original password function is changed to OLD_Password (); and thus using password () generated passwords are not good in the old version, and the MySQL client in PHP is 3.23 ( Of course, except mysqli extensions), the problem is here. Ugh

It's trouble.

I feel that many people will encounter.

The higher the version, the more troublesome

PS:

I still spent 100 oceans to buy Benq seaboard.

Really cool

转载请注明原文地址:https://www.9cbs.com/read-78953.html

New Post(0)