MySQL configuration under Windows

1. Unzip the ZIP package, modify the installation directory under the My-default.ini, save, modify the contents as follows

   [Mysqld]

   Basedir=c:\program files\mysql\mysql Server 5.6 (MySQL directory)

   Datadir=c:\program files\mysql\mysql Server 5.6\data (the directory where MySQL resides \data)

   port=3306

2. Enter the installation directory for MySQL C:\Program files\mysql\mysql Server 5.6\bin>mysql-u root-p

   Prompt for password, enter, zip install first login no password

3. Change Password:

   Mysql>use MySQL;

   Database changed
   

   Mysql>update user Set Password=password (' Your password ') where user= ' root ';

4. Modify password successfully

This article is from the "Farley" blog, make sure to keep this source http://10250691.blog.51cto.com/10240691/1843387

MySQL configuration under Windows