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

Today, because I want to install mysql, then go to the official website to download the latest community version of mysql.

But! Download is a compressed package, which means that we need to manually configure the mysql environment.

The steps are as follows:

1. Unpack the package to your path (do not include Chinese). My path is: F:\ software\ mysql-5.7.11-winx64\

two。 Configure environment variables: my computer-> Properties-> Advanced-> environment variables, configure the path of the bin folder under mysql to the PATH of the user variable, so that you can directly execute mysql-related instructions in cmd.

3. Modify the configuration file my-default.ini under the root directory of mysql, and configure the path of mysql for a total of three lines. The operation after the data directory will be generated automatically. Enter it like this first.

4. Open the command line window as an administrator, and there is a command prompt in the attachment in the start menu. Right-click it to run as an administrator.

5. Locate the current path of the command line window to the bin folder in the mysql directory (be sure to locate it in the bin directory) and enter three instructions at a time

Mysqld-install installs the mysql service

Mysqld-- initialize must be initialized

Net start mysql starts the mysql service.

6. Next, you need to enter mysql, so what is the user name and password? Mysql has changed the way passwords are generated in the new version, using random generation. Open the data folder under the root of mysql (generated by initialize), find a file that ends .err, and open it.

There is a line that records your user name (root) and randomly generated temporary password (I (drANkaq1rf))

Then you can log in by command (mysql-u root-p)

7. You need to change the password to log in

5.7.6 and later, the command to change the password is:

ALTER USER 'root'@'localhost' IDENTIFIED BY' MyNewPass'

Prior to 5.7.6, the instructions for changing the password are:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD (' MyNewPass')

This completes the basic configuration.

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support 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.