centos mysql installation tutorial

CentOS Mysql Installation Tutorial

Mysql is a widely used database management system. As one of the infrastructures for web application development, it is known to more and more people. This article will introduce how to install and configure the Mysql database on CentOS systems.

1. Install Mysql

Open the terminal and enter the following command:

sudo yum install mysql-server

This command will automatically download the Mysql software package and All a series of related dependency packages start the installation process.

2. Start the Mysql service

After Mysql is successfully installed, use the following command to start the Mysql service:

sudo systemctl start mysqld

3. View the Mysql service status

Use the following command to check the Mysql service status:

sudo systemctl status mysqld

If it is displayed as running, it means that the Mysql service has been started successfully.

4. Configuring Mysql

After the installation is complete, you can use the following command to view the default root user password:

sudo grep 'temporary password' /var/log/mysqld.log

5. Log in to Mysql

After Mysql is installed, you can log in to the Mysql database through the following command:

sudo mysql -u root -p

Enter the temporary password in the password prompt box to enter the Mysql database.

6. Manage Mysql

In the Mysql database, you can create, modify, delete databases, and any other tasks that can perform SQL. Here are some useful Mysql commands:

• List all databases:

show databases;

• Create a new database:

create database db_name;

• Delete database:

drop database db_name;

• Use database:

use db_name;

• List all tables in the current database:

show tables;

• Create new table:

create table table_name (columns_definition);

• Delete table:

drop table table_name;

• Insert new data record:

insert into table_name (column1, column2, ...) values (value1, value2, ...);

• Query data records:

select column1, column2, ... from table_name where some_column=some_value;

• Update data records:

update table_name set some_column=some_value where some_column=some_value;

7. Optimize Mysql

Mysql database performance optimization can greatly improve database performance in production environments. The following are several suggestions for optimizing Mysql database:

• Configuring Mysql buffer pool

Mysql buffer pool Query efficiency can be improved in the database, thereby reducing the load on the database server.

sudo vi /etc/my.cnf

# 在[mysqld]下添加以下两行：
innodb_buffer_pool_size=1G
innodb_flush_method=O_DIRECT

• Limit the number of Mysql threads

In Mysql, the default maximum number of threads is relatively high. If it is not reduced appropriately, it may cause insufficient system resources, thus affecting the system performance. It can be modified through the following command:

sudo vi /etc/my.cnf

# 在[mysqld]下添加以下一行：
max_connections=500

• Optimize the query statement

In order to better use the Mysql database, we need to optimize the query statement as much as possible.

Executing the "explain" command can help us determine the bottlenecks in the query statement. This can better optimize query statements and improve Mysql performance.

• Disable Mysql DNS reverse lookup

This is a small trick to optimize Mysql. It can disable Mysql DNS reverse lookup, thereby improving the response speed of the Mysql database. .

sudo vi /etc/my.cnf

# 在[mysqld]下添加以下一行：
skip-name-resolve

8. Summary

Mysql database is an excellent open source database management system that provides powerful background support for web application developers. However, it should be noted that When installing and configuring the Mysql database, we need to pay special attention to the security, stability and reliability of the data to improve the performance and availability of Mysql.

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