mysql database installation

mysql database installation

New installation of MySQL server

MySQL is a cross-platform server. It can be used under the Windows operating system and under Linux The usage is almost identical.

We will explain the installation of MySQL server based on the windows platform.

Note: The Linux operating system is difficult for many beginners. And windows has the widest range of users. This chapter focuses on windows installation. If you are familiar with the Linux operating system, you can also install it yourself and then follow the following courses.

1. Download the installation package

1. Baidu search keyword: mysql server download

2. Visit the official website to download: http://dev.mysql.com/downloads /mysql/

2. Open the installation package, agree to the agreement, next step

                                       

3. Select the server installation

1. develop Yes Refers to the server as a development machine [Recommended]

2. server only only installs the server

3. client only only installs the client operation terminal

4. full installs all

5. custom

##5. Server parameter modification

In this step, MySQL server will be displayed in the interface, and the user will select the final installation configuration file. automatic configuration.

Among them:

Config Type (configuration file type)

1. Development Machine refers to the development server

2. Server Machine server

3 . Dedicated Machine The dedicated server is only used as a database server

*TCP/IP * refers to the open port

The default port of mysql is 3306

6. Setting the password

will prompt the security status of the password

##7. Log file storage location confirmation

1. Bin log is a binary file

2. Error Log refers to the error file

3. Slow Query Log is the slow query log

8. Start the service

#The database installation is now successful.