The installation steps of MySQL5.6 are illustrated in the text and the installation steps of mysql5.6

The installation steps of MySQL5.6 are illustrated in the text and the installation steps of mysql5.6

MySQL is an open source small relational database management system. Currently, MySQL is widely used in small and medium websites on the Internet. Because of its small size, fast speed, and low total cost of ownership, especially the open source code, many small and medium websites have chosen MySQL as their website database to reduce their total cost of ownership. However, if you are new to the MySQL database server, you may feel unfamiliar and have errors. The following is a tutorial on installing MySQL 5.6 compiled by the blogger, check whether the database is available in the doscommand window after installation, so that more people can better master the operations of the database management system.

1. Click the downloaded installation file. The following interface is displayed.

 

2. Click Install MySQL Products in the red box to go to the installation page.

 

3. Check I accept the license terms and click Next.

 

4. Find latest products to check whether there is a new version. You can ignore it. Check the red box below and click Next.

5. Set. The first develel‑default is selected by Default. The Installation Path and Data Path of Installation Path can use the default Path or be modified by yourself.

6. Verify the environment before installation. After loading, click Execute.

 

7. After detecting the program, click Next.

8. Click Excute to execute and wait for the download to complete! Wait patiently if the network is not good...

9. After the download is complete, click Next.

10. click Next.

11. Select the check box and click Next.

12. Set the Password, as shown in the Root Account Password column above. MySQL Root Password: enter the Password and Repeat Password: duplicate Password.

13. For example, in MySQL service configuration, Start the MySQL Server at Systen Startup indicates whether to automatically Start the MySQL service when it is started. Generally, to save resources, we set it to manual, that is, cancel the check, when using the database, right-click my computer and choose manage> services and applications> enable the service.

14. You can cancel the check and click Next.

15. click Next.

16. Click Next again.

17. Click Finish.

After the above installation is complete, we will check whether the installed MySQL database is available:

1. the shortcut key Windows + R opens the command window, for example:

2. Enter cmd To Go To The doscommand window, find the bin directory under the MySQL installation folder, and press enter in cd C: \ Program Files \ MySQL Server 5.6 \ bin, go to the bin directory installed by MySQL.

3. Enter mysql-hlocalhost-uroot-p and press Enter. Then, enter the password set during installation.

4. As shown in, the MySQL database is successfully connected.

5. Enter show databases; (the MySQL statement must end with a semicolon) to display the database.

6. After the database is verified, enter exit and press enter to exit the database.

7. Enter exit again to close the doscommand window.

If you use the MySQL graphical tool, open the graphical tool, click Connect, enter the password, and connect to the MySQL database.

Highlights: mysql installation tutorials for different versions mysql5.7 installation tutorials for various versions mysql5.6 installation tutorials

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