Today, because of my work, I configured the MYSQL5 environment on my computer and installed a
phpMyAdmin management tools, after the installation is completed, found in the phpMyAdmin input characters, always mention
The following error is shown:
Datatype too large
Later think of MySQL installed without setting the character set! After uninstalling MySQL in Add/Remove Programs, there is still a MySQL service in the service that has not been lost! After uninstalling the tool with the uninstall service.
After reinstalling MySQL, MySQL service will not start, appear: 1607 Error! Read a lot of relevant information on the Internet, most of the solution to change Basedir and DataDir, following this method operation, the error is still not lifted, and finally after the test, reinstall the MySQL database port to 3309 (default 3306), the MySQL service starts normally.
When finished, modify $cfg[' Server ' in phpmyadmin/libraries/config.default.php file
[$i] [' Port ']= ' 3309 '; phpMyAdmin Normal, then build a data table, add a record with Chinese characters,
The error disappears. All runs are displayed as normal.