MySQL4File 'C:/mysql/share/charsets /?. Conf 'notfound (Er_MySQL

MySQL4File 'C: mysql1_charsets ?. Conf 'notfound (Errcode: 22) solution bitsCN.com

The following prompt appears in the PHP 4.4.1 + MySQL 5.1 environment:

File 'C:/mysql/share/charsets /?. Conf 'not found (Errcode: 22) Character set' # 33' is not a compiled character set and is not specified in the 'C:/mysql/share/charsets/index' file

After checking this information, you can see that the reason is that the compatibility between the lower version of PHP and the higher version of MySQL is caused.

The easiest way is to upgrade PHP to PHP5.3 and perform an unknown test. Because the server is not my configuration, do not dare to tamper with it, for fear of getting into trouble, so keep the lower version of PHP and find other methods.

The following describes the solutions found on multiple networks for your reference:

It is said that basedir is not set in MySQL configuration. check that my. ini and basedir under the MySQL installation directory are correct. this is not the reason.

It is said that the default-character-set = utf8 in MySQL configuration my. ini should be added before # Comment out. I changed it and it is invalid.

I copied all the files in the/share/charsets Directory of the MySQL installation directory to the c:/mysql/share/charsets/directory, which is also invalid.

Finally, find a method to change output_buffering = Off in PHP. ini to output_buffering = On. The above prompt is missing.

I don't know why. Which of the following prawns knows? thank you!

Temporarily solve.../charsets /?. Conf 'not found (Errcode: 22) Character set' #33'

The php program prompts the following error message: File 'C:/mysql/share/charsets /?. Conf 'not found (Errcode: 22) Character set' # 33' is not a compiled character set and is not specified in the 'C: the/mysql/share/charsets/index' file error does not affect the running of the program, but does not affect the interface.

The possible cause is that the encoding rules of Mysql 4.1 and later versions are changed. if the default character set of the server is UTF8, this type of prompt appears in the DOS window.
There are not a few people who have such problems, but from the search results, there are very few people who finally solve the problem. it is said that some people have solved the problem by using php5. But I don't want to upgrade to php5, and it took a lot of time to see a person's good suggestions (because there was no record during the company's search, so the source could not be well studied ), that person probably means to see the following information from the Myslq official website: "Someone said on the Mysql official website that the error message does not mean you want to find a file in that directory, create a directory "! The better thing is that The Post also provides related files. I specially loaded them into the USB drive and shared them! PS: After decompression, replace the Charsets directory in the mysql folder with the Charsets directory in mysql! Download the compressed package: Click here to download the attachment (mysql.zip)

Images in apache + php + mysql cannot be displayed.

A php web page showing images in the database is created, but the page cannot be displayed. Check the log in Apache and find the following prompt:
File 'C:/mysql/share/charsets /?. Conf 'not found (Errcode: 2)
Character set '#24' is not a compiled character set and is not specified in the 'C:/mysql/share/charsets/index' file
File 'C:/mysql/share/charsets /?. Conf 'not found (Errcode: 2)
Character set '#24' is not a compiled character set and is not specified in the 'C:/mysql/share/charsets/index' file
File 'C:/mysql/share/charsets /?. Conf 'not found (Errcode: 2)

Solution:
Determine the mysql version displayed in phpinfo. If the displayed version is different from the mysql version running on the machine, it indicates a problem. My machine runs version 4.1, but it displays version 3.23.49. It may be that the previously installed mysql version has not been fully uninstalled. Re-compile PHP,
./Configure -- with-mysql =/$ {MYSQL}. check the mysql version in phpinfo () again. Refresh the page to display the image.

BitsCN.com