MySQL installation, input password Flash back, workbench use

1. Installation

Installation will not elaborate on the internet a search a lot, but the tutorial recommended this:

WikiHow

Website is wikihow, very interesting website, more powerful than Baidu experience.

2. Enter password to flash back

After the installation is complete, on the Start menu, open

Start the program

The interface is as follows:

Password

Enter the root password you set at the time of installation, enter the program, you will find the program Flash back.

This is generally because the service is not turned on.

If you are win10, shout "Hello Cortana, open the service", Win7 and so on in the Start menu Search service.

Service

Right-click Start, or restart.

If it is manual mode, you can right-click the property to Automatic.

Again to open the MySQL Command line Client, enter the password, the interface is as follows, that is normal.

MySQL command Windows 3, Workbench

First search, workbench, and then download the installation on the official website.

Workbench

Here is a question such as:

Workbench

You must ensure that the computer has been installed before the installation of the two, if not installed, click on both, go to the Microsoft website, download the appropriate version of the installation. This installation is simple.

Open after installation, the interface is as follows:

Welcome Interface

Click the plus sign to create a new connection and connect to the new database. Click the rectangle to open the server directly, here you need to enter the password, that is, your MySQL password.

Password

Here is a question, if always appear improper name and other information, it may be the same as the above problem, your MySQL service does not open , to open, and then enter the password.

Interface

The arrows section creates databases, tables, and so on. Enter query directives on the right, statements about SQL, and so on. Click on the yellow lightning to execute the corresponding command.

Of course, you need to specify the database before querying, but you can also use the following command in addition to the menu bar on the left:

 Use test; -- test is the database you want to use, i.e.

databases

For example, view all current databases

show databases; -- View Current Database

Database

My public number, is basically my own learning diary, some gadgets.

MySQL installation, input password Flash back, workbench use