Use text tutorials for installing and using mysql5.7.17 and mysql5.7.17

Use text tutorials for installing and using mysql5.7.17 and mysql5.7.17

MySQL is a relational database management system developed by MySQL AB in Sweden and currently belongs to Oracle. MySQL is an associated database management system that stores data in different tables rather than 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 (this term "Authorization Policy"). It 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, MySQL is generally used as the website database for the development of small and medium-sized websites. Due to its superior performance, the Community edition works with PHP and Apache to form a good development environment.

The following describes how to install MySQL for your reference only.

1. The first step is to download windows (x86, 64-bit) from http://dev.mysql.com/downloads/mysql ).

2. After the download is complete, decompress it to the path you want to install, for example, decompress my package to the D: \ MySql path. These folders should just be decompressed:

3. create a new my. ini configuration file, which overwrites the my-default.ini file under the current folder, the previous step sets the display file suffix to be prepared for this step, open this configuration file, add the following code to the file:

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] # set port 3306 to port 3306 # set the mysql installation directory basedir = D: \ MySql # Set the data storage directory of the mysql database datadir = D: \ MySql \ data # maximum number of connections max_connections = 200 # The default character set used by the server is the 8-bit latin1 character set character-set-server = utf8 # default storage used when creating a new table engine default-storage-engine = INNODB

4. Save the files after they are added, and create an empty data folder in this path. The data folder must be empty. The pattern of the entire process should be as follows:

5. preparations have been prepared, followed by the installation of the service. Run cmd.exe as an administrator. Remember to run cmd.exe as an administrator and go to the installed bin directory, the most important and important command is essential here. Otherwise, the service cannot be started after the service is installed. Enter the mysqld -- initialize-insecure -- user = mysql command and press Enter.

6. Enter mysqld install to install the service. If the installation is successful, a prompt is displayed, indicating that the installation is successful. Then, start the MySQL service.

7. configure the environment variable --> right-click on the computer "properties" --> "Advanced System settings" --> "environment variable" --> "path" --> copy the path of the bin directory to the path environment variable.

8. Open MySQL, open cmd.exe, and enter the mysql-uroot-p command. By default, there is no password. Press enter to enter. If you have already set a password, you must enter it. If you have a password, you can use mysql-uroot-p or mysql-uroot-p to press enter to enter the password. The second type is recommended.

The installation and use of mysql has been completed. Please forgive me for not writing well. You are welcome to give more comments and suggestions!

Highlights: mysql installation tutorials for different versions mysql5.7 installation tutorials for various versions mysql5.6 installation tutorials

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