Mysql 5.7.9 windows x64 Installation Problems, 5.7.9winx64

Mysql 5.7.9 windows x64 Installation Problems, 5.7.9winx64

When installing MySQL 5.7.9 or later on windwos, you may encounter a problem that cannot be started, but no error is reported. This is because 5.7.9 or later versions lack the data directory in the MySQL directory:

Some table files are stored in the Data directory to describe data and structure. The Data directory cannot be self-built and must be produced automatically, but can be copied from the normal version.

In fact, the modification is very simple. Just run one command: # mysql -- initialize

And then start again.

After MySQL is installed, normally there is no password (unless you add it yourself). Run the command # mysql-uroot-p, and press enter without entering the password, however, when I use 5.7.11, the password will be input, and you do not know what the password is. The solution is very simple. There is a my-default file in the MySQL directory, add skip-grant-tables under [mysqld] in this file, and restart MySQL. Then, there is no pressure to enter MySQL.

The above is a small Editor to introduce you to mysql 5.7.9 winx64 Installation Problems on windows, I hope to help you, if you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!