How to download, install and uninstall MySQL perfectly

1.MySQL installation

(1) Double-click the MySQL

that we downloaded from the official website ( 2) Keep clicking Next until you encounter the following interface

(3) Select Typical, it will jump, click Install

(4) Wait for the download to complete, click next

(5) Come to the following interface, click Finish to come to the configuration interface

(6) Click next to start the configuration

(7) Default options, detailed configuration

(8) Continue to select the default development machine

(9) Select default transaction support

(10) Keep defaulting to the next step until you encounter MySQL port 3306 (file download port: 21, Internet port: 80, MySQL port: 3306, Oracle port: 1521)

(11) Select database character set

## (12) Default MySQL service name ; Select the bin directory to configure PATH, and do not configure it manually later; you can also uncheck it and manually configure the environment variables later

(13 ) After setting the password of the super user root, continue to the next step:

# (14) Click Execute until all four check marks are marked. Successful installation!

2. Starting and stopping MySQL

When we install, MySQL is started by default, but you can also start it manually!

Method 1:

win r Enter services.msc; find MySQL, start and stop manually

Method 2:

Open the dos command window as an administrator and enter the following command

net stop MySQL  #停止
net start MySQL #启动

3. Customer Client connection

Method 1:

Use the client command line tool provided by MySQL; in the start menu, find the MySQL command line tool

You will get the following interface, just enter the password to log in:

Method 2: Use the dos window to log in

The first direct login method: mysql -uroot -p123456

Press Enter directly. If the following interface appears, the login is successful; but this method has disadvantages, others can see us Enter the password

Second login method: first enter: mysql -uroot -p and press Enter, then enter

Password, others can’t see our password

4. MySQL perfect uninstallation

Step 1: Re-open our installation package and find the following interface:

Finally click Remove

## Step 2: Delete two files

(1) The MySQL folder under our default installation path

(2) Delete the MySQL folder hidden under the ProgramData folder;

To make the hidden file ProgramData visible: Open the folder options and check the Show hidden files option

The above is the detailed content of How to download, install and uninstall MySQL perfectly. For more information, please follow other related articles on the PHP Chinese website!