Detailed MySql installation and uninstallation tutorials, mysql uninstallation tutorials

Detailed MySql installation and uninstallation tutorials, mysql uninstallation tutorials

This article provides you with a tutorial on installing and uninstalling MySql for your reference. The specific content is as follows:

1. Install MYSQL

1. Open the downloaded mysql Installation File and double-click Run mysql-5.5.40-win32.msi.

2. Select "Custom" for "Typical (default)", "Complete (Complete)", and "Custom (Custom ", press "next" to continue.

3. Click "Developer Components (Developer part)" and select "This feature,
And all subfeatures, will be installed on local hard drive. ", that is," This part and its sub-parts are all installed on the local hard disk ". The preceding operations include "MySQL Server", "Client Programs (mysql Client program)", and "Documentation (document)" to ensure that all files are installed. Click "Change..." to manually specify the installation directory.

4. Fill in the installation directory "E: \ software \ install \ mysql \" and do not place it in the same partition as the operating system. This prevents system backup and restoration, data is cleared. Press "OK" to continue.

Confirm the previous settings. If there is an error, press "Back" to return the redo. Click "Install" to start installation.

5. The installation is in progress. Please wait. After the installation is complete, a successful page is displayed. Click "next". The following page is displayed.

Check whether to continue configuring MySQL Data parameters. Then, click "Finish"

Ii. MYSQL Configuration

1. After the installation is complete, the following page appears to go To the mysql Configuration Wizard.

2. Select the Configuration method, "Detailed Configuration (manual precise Configuration)", and "Standard Configuration". Select "Detailed Configuration" to familiarize yourself with the Configuration process.

3. Select the Server type, "Developer Machine (development and testing class, mysql occupies a small amount of resources)", "Server Machine (Server type, mysql occupies a large amount of resources) "," Dedicated MySQL Server Machine (Dedicated database Server, mysql occupies all available resources )"

4. Select the general usage of the mysql Database, "Multifunctional Database (general multi-function type, good)" and "Transactional Database Only (server type, focusing on transaction processing, General) "," Non-Transactional Database Only (non-transaction processing type, relatively simple, mainly used for monitoring and recording, the support for MyISAM data types is limited to Non-transactional ), press "Next" to continue.

5. Select the number of concurrent connections to the website, including "demo-support (DSS)/OLAP (about 20 connections)" and "Online Transaction Processing (OLTP) (about 500 connections) "," Manual Setting (manually set, input a number by yourself )".

6. Whether to enable the TCP/IP connection and set the port. If the port is not enabled, you can only access the mysql database on your machine. on this page, you can also select Enable Strict Mode, so that MySQL will not allow small syntax errors. If you are a newbie, we recommend that you cancel the standard mode to reduce the trouble. However, if you are familiar with MySQL, try to use the standard mode because it can reduce the possibility of harmful data entering the database. Press "Next" to continue

7, is the default mysql database language encoding settings (important), generally select UTF-8, press "Next" to continue.

8. Select whether to install mysql as a windows Service. You can also specify the Service Name (Service ID Name) and add the mysql bin directory to the Windows Kernel-uusername-ppassword##directory. Then, the complete address of mysql.exe is displayed, it is very convenient), I have checked all of them here, and the Service Name remains unchanged. Press "Next" to continue.

9. Ask if you want to change the password of the default root user (Super management. "Enable root access from remote machines (whether to allow root users to log on to other machines. If you want security, do not check it. If you want convenience, check it )". Finally, "Create An Anonymous Account (Create An Anonymous user, and the Anonymous user can connect to the database, and cannot operate data, including queries)" is not checked. The settings are complete, press "Next" to continue.

Set the username and password:
Username: root
User Password: root

10. confirm that the settings are correct. Press "Execute" to make the settings take effect. This completes MYSQL installation and configuration.

Note:After the settings are complete, there is a common error after pressing "Finish", that is, the "Start service" is not allowed, which usually appears on the server where mysql was previously installed. The solution is as follows, first, ensure that the previously installed mysql server is completely uninstalled. If not, check whether the previous password has been modified as described above. If not, back up and delete the data folder under the mysql installation directory. After the installation is complete, delete the generated data folder and the backup data folder, restart the mysql service. In this case, you may need to check the database and fix it once to prevent data errors.

Iii. Uninstall

Take the Windows 7 operating system as an example to thoroughly Delete the MySQL database:

1) Stop the MySQL service of window.
Choose Control Panel> Administrative Tools> services to stop the MySQL background service.
2) uninstall the MySQL installer. Find Control Panel> Programs and functions and uninstall MySQL programs.
3) delete all files in the MySQL installation directory.
4) Delete the MySQL directory in the hidden directory of the C drive ProgramData.
4.1 open the "show hidden files" function of the window system to view all the hidden files in the system.
4.2 Find the ProgramData directory
4.3 Delete the MySQL directory

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.