1. Home > programming >

mysql5.7.15 version installation and configuration method graphic tutorial

This article shares a detailed tutorial on the installation and use of MySQL 5.7 version for everyone, and changes the storage path of the database data for your reference. The specific content is as follows

Because I saw that mysql5.7 has added a new feature documentation< /p>

So re I installed the mysql5.7 version, and post the steps by the way.

(1) Download:

Official website link

Steps: [Downloads–>Community–>MySQL on Windows–>MySQL Installer]

Note: If you don’t have an oracle account, register one, then go to this interface to log in and download

(2) Installation:

After the download is complete, double-click to install:< /p>

Next All the way next

Here we need to create our own user Password, after setting next

cofig type select development machine, set protocol, port related content, next

Modify as follows:

Select standard system account

Click execute

next

You need to enter a password here, and then click the check button

Click execute

Installation completion interface:

finish

(3) Verify login :

Method 1: With the help of command line: and then start menu to find the newly installed mysql, select command line client-Unicode< /p>

Enter password , The interface that appears at this time indicates successful installation, enter show databases: verify

Method 2: Use cmd to set mysql environment variables, as shown in the figure

< img title="" alt="" src="htt ps://img.php1.cn/3cccf/189d8/8fd/648f92e915edc77e.jpeg" />

Enter mysql -h 127.0.0.1 -u root -p or mysql -u root -p directly Password, you can log in

( Four) Use the workbench visualization tool:

Restart the menu to find the newly installed mysql, click workbench to open

Note: Click the gray area:

The workbench visualization platform is more intuitive and convenient

Here, our entire mysql The installation is over, sprinkle!

Next, by the way, I will teach you how to change the mysql storage path:

(1): Stop mysql service

( 1) Run cmd as an administrator to start -> search for cmd -> right-click to run as an administrator (or Win+R and enter cmd and then shift+ctrl+enter)

(2)>>net stop MySQL57 (mysql Service name: Finding method: Right-click my computer -> Manage -> Service, and then find the mysql service name)

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

(4) Change C:\ProgramData\MySQL\MySQL Server Copy the my.ini configuration file under 5.7 to the desktop, open the Notepad and find the part of Datadir #Path to the database root datadir=”C:/ProgramData/MySQL/MySQL Server 5.7/Data/” Amend to: Datadir=” G: /filecode/mysqlData/" [Note: This is "/" instead of "\", the general configuration file is like this]

Save and put it back to the original path [The reason why it was first copied to the desktop is because If you don’t do this, the “Access Denied” warning will pop up when you save the modification, so you can’t modify it.]

(5) Restart the mysql service to verify whether it is successful, the administrator enters cmdà >>net start MySQL57 Then enter mysql to create a database to see

 mysql –u root –p input passwd create database HelloWorld;

This article is published by www.internetweblist.com and does not represent the position of www.internetweblist.com/:http://www.internetweblist.com/programming/82411.html

Contact Us

Online consultation:click here to give a message