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

How to download from mysql from the official website to install and log in to the client? This article tells you clearly.

Step 1: download it from MySQL's official website.

Find the required win10 64-bit mysql from [https://dev.mysql.com/downloads/mysql/](https://dev.mysql.com/downloads/mysql/)

Clicking download will take you to the download page, as shown below. In the past, it was downloaded directly with the browser default downloader, but now oracle wants more users to log in and download again, but there is still an entry for direct download without login, which is located in the red box below, no thanks,just start my download. Click on the browser to start downloading, as shown in the figure.

Download it to the hard drive, and that's it:

This is what happens after decompression: pay attention to the folder path after decompression, because this path determines that it is the path of the mysql database server. The red one is the self-defined path, and here is the unzipped folder.

Note: because MySQL is constantly improving, there are more and more things to consider, and the official website is constantly changing, but remember that downloading things will not change. Here we are looking for the home page-Community-mysql Community Service, download the zip format file; if you are in MySQL on windows, you will find the download msi format file. These two formats are very interesting. The zip format can be unzipped, but you need to configure a lot of things manually; the msi format is installed step by step through the pop-up wizard. Are two completely different ways, but the final result is the same, that is, after zip is decompressed, the result of manual configuration is the generation of step-by-step boot in msi format. Msi is the windows installers program installation package, much like exe files, zip files are compressed format files. We use the zip unzipped configuration and explain what is done during the msi installation process.

In the process of decompression, the compression package is 182m, after decompression 829m, quite big, in fact, decompression takes almost a minute, but also a long time. The msi installation package on the official website is only 15.9m, and the result is 829m after step-by-step installation. What does that mean? The zip package is the result folder after the msi installation package is installed, but in the end, we configure our own environment variables and add services, and the result is the same as the msi installation. And the zip compression package also better realizes the low coupling with the system.

Step 2: configure environment variables

The environment variable is a directory recognized by the system. The purpose of configuring the environment variable is to allow the system to find the commands under the configured path in any directory.

This is the mysql8.0 file directory, and what we're going to configure is the bin directory in this directory.

Press computer-Properties-Advanced system Settings-Environment variables to find the environment variables.

Click Path under the system variable, then click Edit, and then click New to copy and paste the bin path of mysql directly below. And make sure.

Step 3: configure the my.ini file for Mysql

Create a new my.ini file under the extracted mysql root file. The basket is the mysql root directory, and the green box is that we want to create a my.ini file, which is a file for configuration settings.

Copy the following section into the my.ini file

[client] port=3306default-character-set=utf8

[mysqld] # set the server's access port and character set port=3306character_set_server=utf8# the maximum number of connections allowed max_connections=20# is set to its own MYSQL installation directory basedir=C:\ application\ program\ mysql\ mysql-8.0.12-winx64# is set to the MYSQL data directory datadir=C:\ application\ program\ mysql\ mysql-8.0.12-winx64\ data# the default storage engine default-storage-engine=INNODB that will be used when creating new tables

Note that the basedir and datadir attribute values above are the root path of your own MySQL.

Step 4: initialize MySQL

Execute the-- initialize command. Open the cmd command window as an administrator. Enter: mysqld-- initialize-- user=mysql-- console and enter.

The red box below is the command you executed, and the green box you notice is your initial password. Be sure to keep this in mind, but copy it into the text and save it.

Then execute the mysqld-- install command. See below that service is installed successfully. That is, the service service for wins is installed.

The service service can be seen in the task manager, the service. My service name is mysqlSun. As long as you follow the service name you want when mysqld-install mysqlSun, you can use the service name, which is mysql by default. The command to delete the service is: mysqld-- remove mysqlSun. My mysql service is turned off at this time. Next, let's start the service.

Execute net start mysql to start the service. Only by opening the service can you link and operate the database. As shown below, the mysql server is turned on at this time.

Step 5: log in to the database

After enabling the service, continue to execute mysql-u root-p, and you will be asked to enter the password. At this time, you are about to copy the default password given to you by mysql above. Enter the password and enter enter.

Enter the password and enter, display the following Welcome... Congratulations on the words! This is when the mysql data is installed successfully. Or green installation, zip unzipped version, do not need to uninstall when you don't want it.

Don't forget, all you have to do at this time is to change the password. You can't always use the very complicated default password given to you by mysql, can you?

Execute set password='123'; at this time the password will be changed to the number 123, pay attention to the execution of the command with a semicolon, because when operating the data command.

At this point, you can execute the quit command to exit the database, then re-execute the previous step mysql-u root-p and enter the password to log in to the database again. This is exactly what it has to do with your database. The account number is root and the password is 123. If you only use this database to develop passwords that are not difficult to set, because if you forget the password, there is only one way to uninstall mysql completely and then reinstall it.

End: use the mysql client to link mysql

The mysql client can be navicat or SQLyog. Let me take SQLyog as an example. Download install crack SQLyog I will not say oh, here I only provide SQLyog activation code, because this is the most useful.

Name:xxxsn:dd987f34-f358-4894-bd0f-21f3f04be9c1

Open SQLyog, and then File-New connection-New

Create a new name clientTest, then confirm and enter the database password, etc.

Click the test link first. Generally, mysql is version 8.0, that is, a newer version. If the client version is not high, there will be a 1251 error. The reason is that the mysql version is too high, using the new client password verification method, while the old client does not have this password login method. So it needs to be solved.

Execute separately in the login state of the command window

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' your password; # modify encryption rules FLUSH PRIVILEGES; # refresh permissions

Then go to SQLyog, click on the test to condense, and it succeeds. It also shows your mysql version number.

Click OK, and then click the link, which connects to the outgoing database. Did you see that? Root@127.0.0.1 is your user, and your due root@localhost,localhost is 127.0.0.1, which is the IP address. Look at you and the user below mysql gives you four databases by default, each of which has a lot of tables. Let's create a database ourselves.

Right-click your user name-create a database. Name it firstdatabase. This creates a database called firstdatabase under your id.

From the download of the database to the final configuration client is in this article. I hope I can help you.

Summary

The above is the tutorial diagram of downloading and installing win10 64-bit MySQL8.0 introduced by the editor to you. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!

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.