centos7 install mysql

CentOS 7 system is a very common server operating system. Many operation and maintenance personnel and developers need to install the MySQL database when using the CentOS 7 system. This article will introduce the steps to install the MySQL database on CentOS 7.

1. Download and install MySQL

1. First, you need to download the corresponding version of the MySQL installation package from the MySQL official website at: https://dev.mysql.com/downloads /mysql/
2. Select the corresponding version on the download page. When selecting, you need to pay attention to the following points:

• For system platform, select Linux - Generic
• Select Generic Linux (x86, 64-bit) for the system version, Compressed TAR Archive
• After downloading, decompress the compressed package to the specified directory, such as /usr/local/mysql.

3. After decompression, you need to grant necessary permissions to the decompressed folder and use the following command:

cd /usr/local/
chmod -R 755 mysql

4. Install the MySQL system library:

yum install mysql-community-server

5. Start MySQL database:

systemctl start mysqld.service

6. Detect MySQL version:

mysql -V

7. Add MySQL Go to the system service:

systemctl enable mysqld.service

2. Configure MySQL

1. Enter the MySQL installation directory:

cd /usr/local/mysql

2. Create the my.cnf file ：

cp support-files/my-default.cnf /etc/my.cnf

3. Modify my.cnf configuration:

vi /etc/my.cnf

Add the following parameters in the [mysqld] section of the my.cnf file:

default-character-set=utf8

4. Modify permissions:

chown -R mysql:mysql /var/lib/mysql

5. Restart MySQL:

systemctl restart mysqld.service

6. Set MySQL root user password:

mysql_secure_installation

• Enter the new password
• Whether to delete the anonymous user (y/n): y
• Whether to prohibit root remote login (y/n): n
• Yes Delete the test database and test access permissions (y/n): y
• Whether to reload the permission control table (y/n): y

7. Log in to the MySQL root user:

mysql -u root -p

Enter the password you just set to log in.

8. Set MySQL database encoding:

ALTER DATABASE 数据库名 CHARACTER SET utf8;

3. Manage MySQL

1. Create user and authorize:

GRANT ALL PRIVILEGES ON 数据库名.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;

Note that if you are in a development environment, you can use the following command:

GRANT ALL PRIVILEGES ON 数据库名.* TO '用户名'@'localhost' IDENTIFIED BY '密码' WITH GRANT OPTION;

2. View the current user:

SELECT USER();

3. Display the current MySQL database:

SHOW DATABASES;

4. Create MySQL database:

CREATE DATABASE 数据库名;

5. Delete MySQL database:

DROP DATABASE 数据库名;

6. Create MySQL data table ：

CREATE TABLE 表名 (字段名1 字段类型1 [NOT NULL], 字段名2 字段类型2 [NOT NULL], …);

7. Common commands:

• Connect to MySQL: mysql -u username-p
• Close MySQL: systemctl stop mysqld.service
• Start MySQL: systemctl start mysqld.service

Summary

Installing the MySQL database on CentOS 7 is not complicated, just follow the above steps That’s it. It should be noted that for system security, it is not recommended to open the root user to the public network, so it is best to set it to prohibit remote login and only use it on this machine. The authorization scope of MySQL should be controlled as much as possible, and the password should be changed in time to ensure the security of MySQL.

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