Mysql5.7.1 zip installation record, mysql5.7.1zip

Mysql5.7.1 zip installation record, mysql5.7.1zip

 

I haven't met a project using mysql for a long time. I downloaded a project today and found it changed a lot. After searching, I found that the basic information mentioned in http://www.cnblogs.com/wenthink/p/mysqlinstall.htmlcan be used:

1. After registering the windows service, do not start the mysql service directly. Otherwise, it cannot be started. Because the zip version does not contain the data folder now, it needs to be initialized. Use

Use one of the following for initialization. You can also add -- defaults-file = C: \ yourpath \ my. ini parameter C: \> bin \ mysqld -- initializeC: \> bin \ mysqld -- initialize-insecure difference: -- initialize generates a random root Password (which can be seen in a log file under data) -- initialize-insecure uses an empty password.

2. After initialization, you can start the service. After the initialization, you need to connect to the database and change the password.

Mysqld -- initialize is initialized using mysql-u root-p for connection. The password is the random password mysqld -- initialize-insecure initialized in the log, use mysql-u root -- skip-password for successful connection and then use alter user 'root' @ 'localhost' identified by 'new _ password'; change the password

The password change method mentioned in the Link has changed.

Mysql initialization and usage can refer to the http://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html