Phpmyadmin prompts mbstring what to do

Editor to share with you phpmyadmin tips on how to do mbstring, I hope you will learn something after reading this article, let's discuss it together!

Phpmyadmin prompt mbstring

Win system:

Open c:\ windows\ php.ini

Put

; extension=php_mbstring.dll

Change to

Extension=php_mbstring.dll

Unix:

Open / etc/php.ini

Put

; extension=php_mbstring.so

Change to

Extension=php_mbstring.so

two。 Appears when logging in: "# 1251-Client does not support authentication protocol requested by server; consider upgrading MySQL client"

If you encounter the above problems after upgrading mysql to version 4.1 or later, please make sure that your mysql client is version 4.1 or later. (if you have a problem under WINDOWS, you can skip to the following to see the solution, because MYSQL is installed in WINDOWS by client and server.)

Solution:

Use one of the following four methods

One is:

Mysql > SET PASSWORD FOR

-> 'some_user'@'some_host' = OLD_PASSWORD (' newpwd')

Example: if the user name of the mysql database is' abc', password '123456password, the actual statement implemented in the server mysql command line window according to the above example is as follows:

Mysql > SET PASSWORD FOR

-> 'abc'@'localhost' = OLD_PASSWORD (' 123456')

Pay attention to the half-corner semicolon at the end of the sentence.

Second:

Mysql > UPDATE mysql.user SET Password = OLD_PASSWORD ('newpwd')

-> WHERE Host = 'some_host' AND User =' some_user'

Mysql > FLUSH PRIVILEGES

Example: if the user name of the mysql database is' abc', password '123456password, the actual statement implemented in the server mysql command line window according to the above example is as follows:

Mysql > UPDATE mysql.user SET Password = OLD_PASSWORD ('123456')

-> WHERE Host = 'localhost' AND User =' abc'

Mysql > FLUSH PRIVILEGES

Pay attention to the half-corner semicolon at the end of the sentence.

Third: (recommended, it is the same as the second one) mysql > UPDATE mysql.user SET Password = OLD_PASSWORD ('password to connect to the user')-> WHERE User = 'username to connect'; mysql > FLUSH PRIVILEGES Example: the mysql database user name is' abc', password is' 123456', then the actual statement implemented in the server mysql command line window according to the above example is as follows: mysql > UPDATE mysql.user SET Password = OLD_PASSWORD ('123456')-> WHERE User =' abc'; mysql > FLUSH PRIVILEGES; Note the semicolon after the statement " "indispensable. Fourth: update the version of the MySQL module in PHP to support the new version of MySQL

After reading this article, I believe you have a certain understanding of "phpmyadmin Tips what to do with mbstring". If you want to know more about it, please follow the industry information channel. Thank you for your reading!