mysql centos7 installation

MySQL plays an important role in Internet applications and is an indispensable part of the Internet architecture. This article will introduce how to install and configure MySQL on CentOS7.

1. Installing MySQL

First, you need to use the yum command to install MySQL.

sudo yum install mysql-server

After the installation is complete, you need to start MySQL.

sudo systemctl start mysqld

MySQL starts up by default. If you need to turn off this function, you can use the following command:

sudo systemctl disable mysqld

2. Configure MySQL

Use the following command , you can enter the MySQL command line mode:

mysql -u root -p

After entering the password, you can enter the MySQL management interface.

2.1 Modify the root user

MySQL default root user does not have a password. For security reasons, you need to set a password for the root user. In the MySQL command line mode, you can use the following command:

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');

2.2 Create a new user

In addition to the root user, you can also create other users for management. In the MySQL command line mode, you can use the following command to create a new user:

mysql> CREATE USER 'username'@'localhost' IDENTIFIED BY 'user_password';

2.3 Authorization

After creating a user, you need to grant it the corresponding permissions before you can use MySQL. In MySQL command line mode, you can use the following command:

mysql> GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';
mysql> FLUSH PRIVILEGES;

where database_name refers to the name of the database to which permissions are granted, and username refers to the name of the newly created user .

3. Configuring the firewall

The firewall is one of the keys to protecting server security. The ports required by MySQL need to be added to the firewall rules.

sudo firewall-cmd --permanent --add-port=3306/tcp
sudo firewall-cmd --reload

3306 is the default port of MySQL.

4. Set up remote access

If you need to access MySQL on a remote server, you need to configure MySQL. You need to modify the binding IP address and enable remote access permissions in the MySQL configuration file.

sudo vim /etc/mysql/my.cnf

Find the following line (probably at the bottom of the file):

#bind-address = 127.0.0.1

Change it to:

bind-address = 0.0.0.0

Save the file and exit, restart the MySQL service:

sudo systemctl restart mysqld

Now, you can use the MySQL command from the remote server to connect to MySQL.

The above is the entire process of installing and configuring MySQL on CentOS7. Through perfect installation and configuration, the security and stability of MySQL can be improved.

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