mysql database installation

MySQL in XAMPP

If you are not using the XAMPP installation package to install the MySQL server, please skip this block. Take a look at "New Installation of MySQL Server".

If you learn through the "PHP Beginner's Bible", we will teach you to install the XAMPP integrated environment package during installation.

Everyone has installed the MySQL database server in the environment package. No further installation is required.

New installation of MySQL server

MySQL is a cross-platform server, and its use under the Windows operating system is almost exactly the same as that under Linux.

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 keywords: 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

develop means that the server is a development machine [recommended]
server only only installs the server
client only only installs the client operation terminal
full Install all
custom Custom

##5. Server parameter modification

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

Among them:

Config Type (configuration file type)

Development Machine refers to the development server

1. Server Machine server
2. Dedicated Machine The dedicated server is only used as a database server

*TCP/IP *

refers to the open portmysql default port is 3306

6. Set 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 a slow query log

8. Start the service

Congratulations on the successful installation!

If you don’t want to have too much trouble, you can install phpstudy to install the environment package with one click. You can quickly build the environment without cumbersome configuration. Comes with mysql database.