Web site appears MySQL version can not is less than 4.1 what to do

Recently met a lot of customers have said database problems, Web site open Hint Database 4.1, this is how it? Detailed inquiry, just know so, this side will give you to share a concrete solution case.

Website Data package Upload good, open appears MySQL version can not is less than 4.1, this is why?

Error content: Mysql version can not is less than 4.1 appears this hint we can translate what it means

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

Hint is the database has a problem, it seems that the database version of the problem, then we can specifically analyze the reasons for the occurrence.

First we can look at the database version, the result to the database panel, the space database version is 5.1.

Then it should not be the version of the problem, then how do you still have this hint?

In fact, there is another possibility, that is, our database is normal, but our site database configuration file may not be with the database, this will also appear this prompt.

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

We use the editor to open this configuration file, we can see the following database configuration file. The following for everyone to popularize the specific filling instructions: (The specific name may be some difference, the specific distinction to note)

1, the database address (database_address), the general program and database are on the same server, write localhost. If you are not on the same server, fill in the IP of the database server.

2, the database user name (Database_username), using the MySQL program, generally the default is to fill in the root, this is the initial user of MySQL database, direct use is not very safe, we are generally created another user to use.

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

4, the database password (database_password), the password of the database user name.

Compared to the database we saw before, we can see that the original is not right, then we can. We can modify the database configuration file to the current database account password, such as:

[Note that when modifying, be sure to note whether the input mode is English, copy without spaces]

After modifying, click Save, then upload overwrite source file. Then open the website, we can see our website can open normally. AC qq:2881064157

Web site appears MySQL version can not is less than 4.1 what to do