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!