New version of MySQL Server 5.7 free install version settings

Reconfiguration of the computer today, the installation of Java development related environment, in the process of installing MySQL, encountered some problems.

Because downloading a free-install version of MySQL 5.7 on the website, you only need to unzip the zip archive during the installation process.

After that, you need to modify the data modifications of the Basedir and datadir two items in the My-default.ini file under the decompression root.

This is going to be the relevant data to be modified, the middle directory address according to their own MySQL file storage address to modify.

After entering the MySQL bin directory in cmd, type the command mysqld-install

After starting the MySQL service: net start MySQL

< In this step, there is often a problem that shows that starting the MySQL server failed, but no specific exception problems

This can be based on, mysqld--initialize to initialize the work, is to re-create the data directory

>

After landing mysql:mysql-u Root-p

Because it is created for the first time, you do not need a password to log into the MySQL database.

Finally, change the password of the root login account

Set password for [email protected] = password (' 123456f ');

Learn from http://www.jb51.net/article/39454.htm

New version of MySQL Server 5.7 free install version settings