mySQL5.5 Install and Uninstall--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, select the configuration mode,"Detailed configuration (manual and precise)","standard configuration", we select "detailed Configuration "to make it easy to familiarize yourself with the setup 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 type, simpler, mainly to do some monitoring, counting, support for MyISAM data types 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, you lose a number)".

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 " (Enable Strict mode) So that MySQL does not allow for small grammatical 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 without pointing out the directory name, such asthe 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.

Note: Set up, press "Finish" after a more common error, is not "Start service", generally appear in the previous installation of MySQL server, the solution, the first to ensure that the previous installation of the MySQL server completely uninstalled out; Check whether the previous password has been modified as described in the previous step, and if it does not, back up the Data folder in the MySQL installation directory and delete it, after the installation is complete, the Data folder will be installed and the backup Data folder can be removed. Restart the MySQL service again, in which case you might need to check the database and fix it once to prevent data errors.

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.

mySQL5.5 Install and Uninstall--Windows