Installation and configuration tutorial for mysql5.7.17, and installation and configuration for mysql5.7.17

Installation and configuration tutorial for mysql5.7.17, and installation and configuration for mysql5.7.17

My SQL features:

MySQL is a relational database management system developed by MySQL AB in Sweden. It is currently a product of Oracle. MySQL is one of the most popular Relational Database Management systems. In terms of WEB applications, MySQL is the best RDBMS (Relational Database Management System) application software.

MySQL is a relational database management system. Relational databases store data in different tables, rather than placing all data in a large warehouse. This increases the speed and flexibility.

The SQL language used by MySQL is the most common standard language for accessing databases. MySQL adopts the dual Authorization Policy, which is divided into community edition and commercial edition. because of its small size, fast speed, and low total cost of ownership, especially open source code, generally, MySQL is used as the website database for the development of small and medium websites.

Compared with other large databases, such as Oracle, DB2, and SQL Server, MySQL has its own shortcomings, but this does not reduce its popularity. For individual users and small and medium-sized enterprises, MySQL provides more than enough functions, and because MySQL is open source software, it can greatly reduce the total cost of ownership.

Due to its superior performance, the Community edition works with PHP and Apache to form a good development environment.

Installation environment: Windows 10 Professional edition 【? 64]

1. Download:

Method: Download https://dev.mysql.com/?downloads-> Community-> MySQL on Windows-> MySQL Installer from the official website]

If you have an oracle account, you can click "log on to download". If you do not have an oracle account, you can register it or click "No thanks", and choose "just start my download" to download it directly.

2. installation:

Click the downloaded installation package [Suffix:. msi] to install the package.

Click the check box, agree to the installation protocol, and then click Next.

In the old version, three installation types are available: Typical (Typical installation), Complete (full installation), and Custom (Custom installation ).

Typical (Typical installation) Only installs MySQL server, mysql command line client, and command line utility. The command line client and utility include mysqldump, myisamchk, and several other tools to help you manage your MySQL server.

Complete installation installs all components included in the package. Components included in the fully-installed software package include the Embedded Server library, benchmarking suite, supporting scripts, and documentation.

Custom (Custom installation) Installation allows you to have full control over the packages and installation paths you want to install.

In the new version, the options are different, but I chose the first option by default. For other options, see:

Click Next to continue.

Click Next.

In this step, some programs will be automatically downloaded and installed. After the installation is complete, click next to continue.

Click Next.

For Cofig Type, select Development Machine, set the protocol and port content, and click Next.

Set Password

Select Standard System Account and click Next.

Click Execute to automatically install some programs.

Click Finis.

Click Next

Enter the password here, and then click Check and Next.

Click Execute

Click Finish

Click Next

Click Finish to complete the installation and run MySQL.

3. Verify login:

Method 1:Use the Workbench visualization tool:

When you click Finish to complete the installation and Check Start My SQL Workbench after Setup, the Workbench will automatically run. If this option is not selected, find the newly installed My SQL in the Start menu and click Workbench.

Click the light gray area in the upper left corner.

Enter the password and click OK to log on to MySQL.

The Workbench visualization platform is intuitive and convenient.

Method 2:With Command line:

Find the newly installed mysql in the Start menu and SELECT Command line client-Unicode.

Enter the password. The displayed interface indicates that the installation is successful. Enter show databases for verification. Method 3: Use cmd:

Set MySQL environment variables,

Enter mysql-h 127.0.0.1-u root-p or mysql-u root-p, and enter the password to log on.

 4. How to [change the storage path of database data] is included:

First stop mysql Service

(1) Run cmd as an administrator

Start-> Search cmd-> right-click the Administrator to run the command (or press "Win + R" and then "shift + ctrl + enter)

(2)> net stop MySQL57 (mysql service name: Find the method: Right-click my computer-> Manage-> service, and find the mysql service name)

(3) copy the files (usually C: \ ProgramData \ mysql \ MySQL Server 5.7 \ data) in the Data directory under the MySQL installation path to the desired storage path, for example: g: \ filecode \ mysqlData;

(4) copy the my. ini configuration file under C: \ ProgramData \ MySQL Server 5.7 to the desktop, and open the section Datadir in notepad.

# Path to the database root

Datadir = "C:/ProgramData/MySQL Server 5.7/Data /"

To:

Datadir = "G:/filecode/mysqlData/" [Note: here is "/" instead of "\". This is the case for common configuration files]

Save and put it back to the original path.

[Copy the file to the desktop first because, if you do not do this, the "Access Denied" warning will pop up when you save the modification so that it cannot be modified]

(5) restart the mysql service to verify whether it is successful. The Administrator will go to cmd à> net start MySQL57

Go to mysql and create a database.

mysql –u root –pinput passwdcreate database HelloWorld;

We can see that the original data directory does not generate the HelloWorld database, but the HelloWlorld database is added to the mysqlData directory we created.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.