Mysql_x64 installation version under Win10 configuration (ii)

Mysql_x64 installation version under Win10 configuration (ii)

Next to the Mysql_x64 installation version under Win10 configuration (i)

The sixth step is to set the MySQL password: There are three ways :

①: with SET PASSWORD Command : Log in to MySQLfirst.

format: mysql> Set Password for User name @localhost = password (' new password ');

Example: mysql> Set password for [email protected] = password (' 123 ');

② with mysqladmin

format: mysqladmin-u User name - P Old Password Password New Password

Example: mysqladmin-uroot-p123456 Password 123 method

③ with UPDATE Direct Editing User Table

Log In First MySQL .

mysql> use MySQL;

mysql> Update user set Password=password (' 123 ') where user= ' root ' and host= ' localhost ';

mysql> flush Privileges;

Here I changed the password is a little episode, took a little time to solve, stay here for your reference. I am in the change password is prompt: Can ' t find any matching row in the user table, later found no MySQL database: 650) this.width=650; "src="/http S3.51cto.com/wyfs02/m00/6e/ee/wkiol1wmkjxiu80raabvwcpvwjs863.jpg "/>

Only INFORMATION_SCHEMA library and test library, through the data, to the My.ini file [mysqld] added Skip-grant-tables, as follows: 650) this.width=650; "Src=" S3.51cto.com/wyfs02/m00/6e/f1/wkiom1wmkhnjp6lvaaceg7d6lnu636.jpg "/>

Then restart the database, after landing show databases; return to normal:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6E/EE/wKioL1WMKjWgQ2YUAABYziryXKI797.jpg "/>

Then use one of the three methods above to change the password.

seventh Add environment variable: The purpose of the environment variable is to open MySQL each time Instead of switching to the MySQL directory, open it directly in the cmd window. How to add an environment variable: Right-click on my Computer à properties à advanced system settings à Advanced tab à environment variable à path edit :

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6E/F1/wKiom1WMKHmziWm-AAF6zVffh2c139.jpg "/>

Put the full path of the bin directory under your MySQL software, and finally add an English semicolon (;) to the path behind that directory. such as D:\Program Files\mysql-5.6.25-winx64\bin;

Here, MySQL's free install version (Zip) configuration is over, if you like the Black Command window, you can directly operate the database directly in the MySQL command window, if you do not feel intuitive, download graphical management tools, recommended Navicat for MySQL.

This article is from the "calf to Daniel" blog, please be sure to keep this source http://niuked.blog.51cto.com/2863371/1665764

Mysql_x64 installation version under Win10 configuration (ii)