Shulou(Shulou.com)06/01 Report--

This article is about how to install mysql 5.7. Xiao Bian thinks it is quite practical, so share it for everyone to make a reference. Let's follow the editor and have a look.

mysql5.7 installation and operation method: first extract the installation package to a directory, and initialize the database; then set the root random password, and start the mysqld service; then log in Mysql and reset the root password; finally install the windows service, and set remote access rights.

mysql5.7 installation and operation method:

1. Extract to a directory, such as D:\tools\mysql-5.7.11-winx64

2.mysql5.7 compressed package, no data folder by default, you need to initialize the database first, the command is as follows:

D:\tools\mysql-5.7.11-winx64\bin> mysqld --initialize

3. After initialization, the data folder will be generated under the mysql-5.7.11-winx64 folder. The root password of mysql version 5.7 is not empty by default, but a random password.

The password can be viewed in the "machine name.err" file under the data folder, as follows:

2016-02-26T03:23:56.025673Z 1 [Note] A temporary password is generated for root@localhost: yai/UnHse8Nu

4. Start mysqld service

D:\tools\mysql-5.7.11-winx64\bin> mysqld --console

5. Use this random password to log in to mysql and command as follows:

D:\tools\mysql-5.7.11-winx64\bin> mysql -uroot -pyai/UnHse8Nu

6. After logging in, you need to reset the root password to use the database. The command is as follows:

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

7. install as windows service

Installation: D:\tools\mysql-5.7.11-winx64\bin> mysqld --install

Uninstall: D:\tools\mysql-5.7.11-winx64\bin> mysqld --remove

8. Set remote access permissions

mysql> grant all PRIVILEGES on *.* to root@'%' identified by 'your_passwd';mysql> flush privileges; thank you for reading! About mysql5.7 installation and operation method to share here, I hope the above content can be of some help to everyone, so that everyone can learn more knowledge. If you think the article is good, you can share it so that more people can see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.