Yesterday in Navicat for MySQL import a script to execute. garbled characters appear.
Considering the possibility of a version number, you want to uninstall and install MySQL again, this uninstall is a problem. Causes the installation to not install at the time.
Later, it is not intended to be uninstalled when unloaded completely caused, the following gives the complete uninstall MySQL 5.1 Uninstall method:
1, in the Control Panel in the Add Delete program to delete
2, delete the MySQL directory My.ini file, fake device is good, can directly delete the directory all
3, start-to-do, regedit look at the list of these places delete no
Hkey_local_machine\system\controlset001\services\eventlog\application\mysql Directory Removal
Hkey_local_machine\system\controlset002\services\eventlog\application\mysql Directory Removal
Hkey_local_machine\system\currentcontrolset\services\eventlog\application\mysql Directory Deletion (I didn't find it when I uninstalled it, but it still achieves the purpose of completely unloading.)
)
4. This article is very critical
C:\Documents and Settings\All Users\Application Data\mysql (Win7, even if administrator rights are not open C:\Documents and Settings\All Users\, This path is equivalent to C:\user\All users\)
Let's say there's a MySQL file here. Must be deleted.
(There is nothing in my directory)
Note: The application Data directory is hidden. Need to open a directory select menu bar tools → directory options → view → hide files and directories an option to show all files and directories OK
After 4 steps have been completed. Restart ok! Install it again.
==================================
First of all. Check the encoding format you chose when installing MySQL database:
mysql> status;--------------D:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe Ver 14.12 Distrib 5.0.96, for Win32 (ia32)Connection id: 87Current database:Current user: [email protected]SSL: Not in useUsing delimiter: ;Server version: 5.0.96-community-nt MySQL Community Edition (GPL)Protocol version: 10Connection: localhost via TCP/IPServer characterset: utf8Db characterset: utf8Client characterset: utf8Conn. characterset: utf8TCP port: 3306Uptime: 4 hours 59 min 9 secThreads: 5 Questions: 8288 Slow queries: 0 Opens: 2234 Flush tables: 1 Open tables: 5 Queries per second avg: 0.462--------------
is the test installed successfully?
If you can log in, it proves that you have successfully installed it.
Uninstalling MySQL 5.0