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

Msyql database installation, for your reference, the details are as follows

① opens https://www.mysql.com/ in a browser and goes to MySQL's official website. Click DOWNLOADS.

②, in the tab that opens, find the following and click

On the page that ③ opens later, find the following and click.

④ will see the relevant download items on the page that opens later, as shown in the following figure.

After the ⑤ download is complete, unzip the downloaded installation package, and a file named mysql will appear after the decompression. It's a folder.

⑥ move this folder to the place where you want to install mysql, that is, the directory you moved to is the directory where mysql is installed.

⑦ configuration environment variables

The desktop finds "my computer" > > Open Properties > Open Advanced system Settings > Open Environment variables > in the user or system variables, find "PATH" > find "Edit".

Open "Edit", add the installation path of MySQL (this is my installation path E:\ mysql-8.0.13-winx64\ bin), and click OK. The figure below is as follows

⑧ creates a new folder data under the mysql directory and modifies the configuration file of mysql

Run the DOS window as a ⑨ administrator, otherwise you don't have enough privileges.

Enter ⑩ into the bin directory, and enter mysqld-- initialize-insecure-- user=mysql to enter.

Then enter mysqld-- install enter (install Mysql service)

The net start mysql command starts the mysql service, and the mysql-u root-p command logs in to the mysql database (just after installation without a password, enter directly)

Why configure environment variables?

The specified program can be accessed from any path, for example: access to the mysql.exe program just installed

1. Find the location of the mysql.exe program

2. Run the DOS window as an administrator

An error will be reported if found, because the mysql.exe program is not in the C:\ WINDOWS\ system32 path.

Solution: go to the installation path of the mysql.exe program and run it again.

But every time you need to go to the installation path of the mysql.exe program and then execute the program, it is obviously troublesome, time-consuming and laborious. Is there any way to solve this problem? Of course, the operating system provides users with the tool of environment variables. When the program we want to access is not under the path of the program, the system will automatically look in the environment variables we configured until we find it. If you don't find it, you will report an error.

3. Configure environment variables

See ⑦ above

4. View the results

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql8.0

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.