mysql database installation

MySQL is a popular open source relational database management system that is widely used in website development, data analysis and other fields. Before performing any MySQL-related development, testing, or deployment tasks, you must first install MySQL server. This article will introduce how to install MySQL server on Windows and Linux operating systems, as well as basic configuration and management.

1. Install MySQL on Windows

There are two ways to install MySQL on Windows: use the official installer or use XAMPP.

1. Use the official installation program:

(1) Download the MySQL installation program

Visit the MySQL official website (https://dev.mysql.com/downloads/mysql/ ) and click Download the installer.

(2) Install MySQL

Right-click on the downloaded MySQL installer and select the "Run as administrator" option. Follow the steps in the wizard to install MySQL. During the installation process, you can set the password of the root user and the port of the MySQL service, etc.

(3) Start the MySQL service

After the installation is complete, you need to start the MySQL service. Press the "Win R" key, type "Services.msc" and press Enter key, select the MySQL service and click on the "Start" option.

2. Use XAMPP:

XAMPP is a commonly used web server software package that integrates Apache, PHP, MySQL and other tools. By installing XAMPP, you can easily install multiple web server software at once.

(1) Download the XAMPP installer

Visit the official website (https://www.apachefriends.org/zh_cn/index.html), and then download the XAMPP installer according to your Windows system type . The installation process is the same as for MySQL, and you can choose to install MySQL as part of XAMPP.

(2) Start the MySQL service

After installing XAMPP, you can start the XAMPP control panel and start the MySQL server.

2. Install MySQL on Linux

Installing MySQL on Linux requires the use of the command line. The following are the steps to install MySQL on Ubuntu Linux:

(1) Update the package list

Execute the following command in the terminal:

sudo apt-get update

(2) Install MySQL server

Execute the following command in the terminal:

sudo apt-get install mysql-server

During the installation process, you need Set the root user's password.

(3) Start the MySQL service

Execute the following command in the terminal:

sudo systemctl start mysql

(4) Enable the MySQL service

Execute the following command in the terminal:

sudo systemctl enable mysql

(5) Check whether the MySQL server is running

Execute the following command in the terminal:

sudo systemctl status mysql

If MySQL is running, you will see the "Active: active (running)" message.

3. Configure the MySQL server

1. Create a new user

By default, the MySQL server has only one root user, and the root user has all permissions. To strengthen security, we should create a new user and assign appropriate permissions to this user. Use the following command to create a new user:

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

2. Assign permissions to the new user

In order to make the new Users can execute SQL statements and manage databases, and we need to assign corresponding permissions to them. Grant new user permissions using the following command:

GRANT ALL PRIVILEGES ON . TO 'newuser'@'localhost';

3. Refresh permissions

After granting permissions to the new user, we need to refresh MySQL's permissions table for the changes to take effect immediately. Use the following command to refresh the permissions:

FLUSH PRIVILEGES;

4. Manage MySQL server

1. Start and stop the MySQL service

On Windows, you The MySQL service can be started and stopped using Windows Service Manager. On Linux, you can use the following commands to start and stop the MySQL service:

sudo systemctl start mysql

sudo systemctl stop mysql

2. Back up and restore the database

Data in the MySQL server needs to be backed up regularly to prevent data loss or damage. You can use the following command to back up and restore the MySQL database:

Backup database:

mysqldump -u root -p your_database_name > /path/to/backup/file.sql

Restore the database:

mysql -u root -p your_database_name

3. Monitor manual query

Executed on the MySQL server All queries are logged in the "mysql.general_log" table. You can enable the query log using the following command:

SET GLOBAL general_log = 'ON';

The query log will record all queries so that you can view the execution at any time.

Summary

MySQL is a powerful and flexible relational database. Whether you are developing web applications or performing data analysis, learn how to install and configure a MySQL server and how to manage a MySQL database. is crucial. Hopefully this article will help you solve problems if you encounter problems during the installation and configuration of MySQL.

The above is the detailed content of mysql database installation. For more information, please follow other related articles on the PHP Chinese website!