MySQL 5.7 version of the installation and simple use (graphics and text tutorial) _mysql

MySQL 5.7 version of the installation using a detailed tutorial

Write or more detailed, even some cumbersome, there are many steps in the other tutorial documents are omitted, but I still have to write out, because I went a lot of detours, I hope you can avoid the detours I go. Of course, know the students can skip, choose you want to know where to see.

Because seeing mysql5.7 adds a new feature documentation

So reinstall the mysql5.7 version of the, and by the way put the steps to post a

(i) Download:

Website download.

Step: "Downloads–>community–>mysql on Windows–>mysql Installer"

Note: If you do not have an Oracle account to register one, and then login to this interface, download

(ii) Installation:

Double-click Install after download completes:

Next way.

Here we need to create our own user password, set the next

Cofig type Select development machine, set protocol, port related content, next

Follow the following figure to modify:

Select Standard SYSTEM Account

Click Execute

Next

Here you need to enter a password, and then click the Check button

Click Execute

Installation Completion Interface:

Finish

(iii) Verification login:

Method one: Using command line:

Then start the menu to find the newly installed MySQL, select command line Client-unicode

Enter the password, the interface appears to indicate a successful installation, enter show databases: Verify

Method Two: With the help of CMD

Set the MySQL environment variable, as shown in the figure

Enter Mysql-h 127.0.0.1-u root-p or direct mysql-u root-p

Enter the password, you can log in

(iv) Use of Workbench visualization tools:

Then start the menu to find the newly installed MySQL, click Workbench to open

Note: Click the gray area:

Workbench Visualization platform is more intuitive and convenient

Here, our entire MySQL installation is over, sprinkle flowers!

Next, we'll teach you how to change the way MySQL stores paths:

(a): Stop MySQL Service

(1) Admin identity run cmd

Start –> search cmd–> Right key admin run (or win+r input cmd shift+ctrl+enter)

(2) >>net stop MySQL57 (MySQL service Name: Find method: Right button My Computer –> admin –> Service, and then find MySQL service name can)

(3) Copy the files (usually C:\ProgramData\MySQL\MySQL Server 5.7\data) under the MySQL installation path to the path you want to store, such as: G:\filecode\mysqlData;

(4) Copy the My.ini configuration file under C:\ProgramData\MySQL\MySQL Server 5.7 to the desktop, Notepad to open the part that finds DataDir

#Path to the database root 
datadir= "C:/programdata/mysql/mysql Server 5.7/data/" 

Modified to:

Datadir= "g:/filecode/mysqldata/" Note: This is "/" instead of "\", the general configuration file is like this "

Save and return to original path

"The reason to copy to the desktop is because if you do not, the change will pop up the" access denied "warning so that it cannot be modified.

(5) Restart the MySQL service to verify the success of the administrator into the cmdà>>net start MySQL57

Then go to MySQL, create a database, look at it.

Mysql–u root–p
input passwd
CREATE database HelloWorld;

You can see the original data directory did not generate HelloWorld database, and in our new Mysqldata path directory more than Hellowlorld database, to this end

Thank you for reading, I hope to help you, thank you for your support for this site!