Windows MySQL installation, configuration

One, MySQL download:

, we select the community version of the Red box section to download and MySQL supports many platforms:

My operating system is 64-bit, select the corresponding version of the MSI version of the download , pop-up login interface, select No thanks,just start my download direct download can:

Second, the installation of MySQL:

Once the software download is complete, start the installation.

, it is recommended that you select custom for the second item, and then customize the installation. The following screen appears:

Third, the configuration of MySQL:

Explanation: In Java development in the future, to access this server, it is related to the communication protocol, where the use of TCP/IP protocol, this time involves the port, MySQL default port number is 3306, using the default. Continue to the next step:

, the encoding of the database is selected. The first is Latin, only English is supported, Chinese is not supported, and the second seems to be related to Japanese. Here we choose the third type: Custom. Then set the encoding mode to: Utf-8. Next:

, we tick "add path to environment variable" and continue:

, the password is set for the root user. Here, I set the password to SMYH. In addition, check "Allow user remote (network) Access", otherwise only local access, continue:

The above tick will be automatically played:

, we can see that our configuration is written in the My.ini file.

Click Finish to complete the installation. Let's go to the corresponding directory and look at the contents of the My.ini file:

View Code

At the same time, we can see the installed programs in the Start menu program as well:

Click on it to start running:

Open Computer Management to see that the MySQL service is started:

You can also see in the process:

Iv. MySQL Uninstall:

1, to the control panel inside the first to remove the MySQL software;

2, delete the MySQL installation directory (if the other disk also has a set directory to be deleted, empty directory also to delete);

3. Delete the following files in the registry: (Press "Win+r" key, enter Regedit, enter the registry):

• Hkey_local_machine/system/controlset001/services/eventlog/applications/mysql
• Hkey_local_machine/system/controlset002/services/eventlog/applications/mysql
• Hkey_local_machine/system/currentcontrolset/services/eventlog/applications/mysql

Some words all delete (tip: Use F3 loop to find "MySQL");

4, if it is a Windows 7 system, also need to find C:\ProgramData\MYSQL to delete it; if it is an XP system, remove C:\Documents and Settings\All Users\Application Data\ Mysql

Once you are done, you can install again without rebooting the system.

Windows MySQL installation, configuration