MySQL installation and uninstallation--WINDOWS

MySQL can go to the official website to download the corresponding version for installation, the version used here is "Mysql-5.5.40-win64.msi";

Installation

1. Double-click "Mysql-5.5.40-win64.msi" to enter the installation page.

There will be a waiting interface before entering this interface, where you need to wait patiently for a while.

2, agree to the agreement, next.

3. Select the type of installation

The installation type has "typical (default)", "Complete", "Custom (User Defined)" Three options, select "Custom", press "next" key to continue.

4. Set the installation path and files that need to be installed

Recommendations for PATH settings: Do not place the partition on the operating system to prevent system backups from being restored when the data is emptied.

After confirming the installation directory, click OK;

5. Click Istall to install

installation process

Installation Complete

Click Finish to complete the installation.

Configuration of MySQL Database

The configuration page of the database is entered when the installation is complete:

1, choose the configuration mode, "Detailed configuration (manual and precise)", "Standard configuration", we choose "Detailed configuration", easy to familiarize with the configuration process.

2, select the server type, "Developer Machine (Development test class, MySQL occupies very little resources)", "Server machine (server type, MySQL occupies more resources)", "dedicated MySQL server Machine (dedicated database server, MySQL occupies all available resources) "

3, choose the general purpose of MySQL database, "Multifunctional database (Universal multifunction, good)", "Transactional database only (server type, focus on transaction processing, general)", " Non-transactional Database only (non-transactional, simpler, mainly to do some monitoring, counting, MyISAM data type support is limited to non-transactional), press "Next" to continue.

4. Select the number of concurrent connections, decision Support (DSS)/olap (20 or so), Online Transaction Processing (OLTP) (500 or so), Manual Setting (manually set, lose a number yourself) ".

5, whether to enable TCP/IP connection, set the port, if not enabled, you can only access the MySQL database on their own machine, on this page, you can also select "Enable Standard mode" (enabled Strict mode), so that MySQL will not allow small syntax errors. If you are a novice, it is recommended that you remove the standard mode to reduce hassle. However, when you are familiar with MySQL, try to use standard mode as it can reduce the possibility of harmful data entering the database. Press "Next" to continue

6, the MySQL default database language encoding to set (important), the general election UTF-8, press "Next" to continue.

7, choose whether to install MySQL as a Windows service, you can also specify the service name (the Services identity name), whether to add the MySQL bin directory to Windows PATH (after joining, you can directly use the file under the bin, instead of indicating the directory name, such as connection, "Mysql.exe-uusername-ppassword;" You can, do not point out the full address of the Mysql.exe, very convenient), I have all ticked here, Service name unchanged. Press "Next" to continue.

8. Ask if you want to modify the password for the default root user (super Admin). "Enable root access from remote machines (whether to allow root users to log on to other machines, if it is safe, do not tick, if it is convenient, tick it)". Finally "Create an Anonymous account (create a new anonymous user, anonymous users can connect to the database, unable to manipulate data, including queries)", generally do not check, set up, press "Next" to continue.

9. Click "Execute" to configure

The installation and configuration of this database is complete.

MySQL Database uninstallation

1. Stop MySQL Service

Services, management tools, Control Panel, find MySQL stop backend service. or right-click My Computer--management--services to find MySQL stop backend service.

2. Uninstall MySQL

Control Panel, programs and features, find MySQL to uninstall.

3. Remove all files from the MySQL installation directory.

4, Show hidden files, and delete the C-drive Programdata hidden directory of the MySQL directory.

MySQL installation and uninstallation--WINDOWS