Mysql version can not be less than 4.1 error resolution _MYSQL

Web site appears MySQL version can not be less than 4.1 how to do

Recently encountered a lot of customers have said database problems, Web site open Prompt Database 4.1, this is how it? inquired in detail, just know that so, this side will give you to share a specific solution case.

Website Data package upload good, open appear MySQL version can not be less than 4.1, this is why?

Error content: Mysql version can not be less than 4.1 appears this hint we can translate what is the meaning of

This Baidu translation is: MySQL database version can not be less than 4.1

Hint is the database has a problem, looks like a database version of the problem, then we can specifically analyze the reasons for the occurrence.

First we can look at the database version, the results to the database panel to see, the Space database version is 5.1.

Then it should not be a version of the problem, then how will this hint?

In fact, there is another possibility, that is, our database is normal, but our site inside the database configuration file may not be the same as the database, there will be this hint.

Then we need to look at the database configuration file, with FTP open the site root directory, we find the database configuration file, is generally config.inc.php. (can also be other files, here to illustrate)

We use the editor to open this profile and we can see the following database configuration file. Below to give you a general description of the specific fill out: (Specific names may be some differences, specific distinction to note)

1, the database address (database_address), general procedures and databases are on the same server, write localhost can. If not on the same server, complete the IP of the database server.

2, database user name (Database_username), the use of the MySQL program, the general default is to fill in the root, this is the original MySQL database users, direct use is not very safe, we are generally set up a separate user to use.

3, the database name (database_tablename), this need and database user name distinguish, one is the name of the database itself, a permission to use the database user name, can not be confused.

4, Database password (Database_password), this database username password.

Compared with the database we saw before, we can see that the original is not right, that is OK. We can modify the database configuration file for the current database account password, as shown below:

[Note that the change must pay attention to whether the English input mode, copy do not take spaces]

Thank you for reading, I hope to help you, thank you for your support for this site!