MySQL database built under Windows platform

Source: Internet
Author: User

1. Download and install MySQL database: (1)---My tags, software download, computer-related professional software---baidu cloud link download Mysql-installer-community-5.7.18.1msi (the installation version of the current time is the latest version of) non-installed version requires the use of command configuration, a little cumbersome, recommended to use the installation version, more convenient. (2) can also download the latest version of the MySQL official website: https://dev.mysql.com/downloads/installer/(official website)

Note: In the process of installing MySQL database, remember the user name and password, it is recommended to use easy-to-remember user name and password, the installation path is best to choose non-system disk, remember the path, easy access to the database, in addition to MySQL database completely free of charge.

2. Test whether the database is available. First step: Check whether the MySQL database starts:-> run (win+r), input services.msc-> Local service, start mySQL57 The second step: check that the MySQL database is configured successfully:-> run- Enter cmd (case can), go to the bin directory of the MySQL database: d:->cd D:\MySql\MySQL Server 5.7\bin (go to the bin directory according to your MySQL installation path, my installation is: D:\MySql\ MySQL Server 5.7\bin)

Command: mysql-u root-p-> Enter the password for the login database if you see the following prompt for configuration success Note: If you do not want to log in to the database every time, you can configure environment variables, in the environment variable-system variable path to add url:d:\mysql\ MySQL Server 5.7\bin

When you are finished, you can enter the MySQL command directly under the current computer User:

Note: The article for my original, reproduced please indicate the source! The article will inevitably have flaws, but also hope that we contain more, there is advice or suggestions can contact with me; I qq:2187093468 (non-sincerity, please add friends where the note where to see)

MySQL database built under Windows platform

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.