WINDOWS10 Installation and Configuration MySQL-5.7.11 Note:: This blog for bloggers to learn notes, part of the content from the network, hope to understand.1. Download MySQL:http://downloads.mysql.com/archives/community/,here is the free version of the community, free installation version (recommended), you can choose a variety of historical version number.
Select the appropriate version of the operating system and download:
2, unzip and configure the system environment variables to extract to the path you want to install, the author installation path is: C:\software\mysql
Enter the bin directory under the Unzip directory,
and copy this directory
Then add the directory to the system path system variable, mouse to the lower left corner--right--system--Advanced system settings--environment variable--Find the PATH variable in the system variable (S)---edit--new
Determine and exit 3, install the MySQL service to the administrator into the DOS interface, switch to the extracted bin directory, the specific operation: mouse to the lower left corner-right--command prompt (administrator)--CD C:\software\mysql\mysql-5.7.11-winx64 See the following steps after \bin--:
mysqld Install
In this step, the installation succeeds, and the following command is: Initialize the MySQL data directory (no such directory after mysql-5.7 decompression) and generate the password:
mysqld--initialize-insecureNo prompt after successful execution:
4, start the MySQL service in the DOS interface (any directory) execution
net start MySQL,The following interface appears to indicate a successful start
5. Change the root user password: (Previous operation root login without password)Execute in DOS interface (any directory)
mysql-uroot
, that is, log in with the root user
After the general operation for the database:
show databases;-
Use MySQL;
-Update user set Authentication_string=password (' 123456 ') where user= ' root ' and Host = ' localhost '; Here are some points to note: SQL statement syntax must be correct, that is, '; ' End, mysql-5.7There are no password fields in the user table under the database .Instead, the encrypted user password is stored in the authentication_string field
The result shows that the password modification succeeded: Continue with the following actions:
flush Privileges;
OK, end; 6, test connection open a DOS command window again: Enter:
mysql-uroot-p; (log in to MySQL with a password)
after entering the password,
Success!
Note: The installation of the author mysql-5.7 with the previous version of the installation is different, at the same time with other online users of the tutorial has a little discrepancy, and did not modify the My-default,ini process, etc., only for reference learning, if the installation failed, Please re-enter the previous Bin directory as Administrator, execute, net stop MySQL (stop MySQL)--mysqld remove (remove MySQL), try to install again.
or leave a message to the blogger. Part of this article comes from the web, looking to understand and appreciate.
From for notes (Wiz)
WINDOWS10 Installation and Configuration MySQL-5.7.11