centos installation mysql rpm installation

CentOS is a free and open source Linux operating system based on Red Hat Enterprise Linux code. It is one of the widely used server operating systems. MySQL is a free and open source relational database management system widely used for data storage in web applications. This article will introduce how to install MySQL database through RPM package on CentOS operating system.

RPM (Red Hat Package Manager) is a package management tool used in Linux operating systems. The RPM package is a software installation package suitable for the Red Hat series operating systems. It can quickly install, upgrade or uninstall software for the system. In the CentOS operating system, RPM packages are a common way to install software, and installing MySQL databases through RPM packages is also a common way.

This article assumes that you are already familiar with basic command line operations such as running command lines and package management tools. If you are not familiar with these operations, please learn the relevant knowledge first.

Install MySQL database

Step one: Add MySQL’s Yum library

In the CentOS operating system, adding MySQL’s Yum library is the first step to install the MySQL database. Through the Yum library, we can quickly search and install MySQL RPM packages.

Open the terminal and use the following command to add the MySQL Yum library.

sudo rpm -Uvh https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

This command will download the MySQL Yum library and add it to the system.

Step 2: Install MySQL server

After downloading the Yum library, we can use the Yum tool to verify whether it is successfully installed:

sudo yum repolist all | grep mysql

Verify command results:

mysql-connectors-community/x86_64 MySQL Connectors Community        enabled:     105  
mysql-tools-community/x86_64      MySQL Tools Community             enabled:      56  
mysql57-community/x86_64          MySQL 5.7 Community Server        enabled:   2,356+ 

We can see that the MySQL Yum library has been added successfully.

Next, install the MySQL server through the Yum tool.

sudo yum -y install mysql-community-server

This command will automatically download and install the latest MySQL server software package and related dependency packages. This process may take some time, depending on the speed of your network connection and the performance of your computer.

Step 3: Start the MySQL server

After the installation is complete, we need to start the MySQL server.

sudo systemctl start mysqld

This command will start the MySQL server. If nothing happens after you run this command and no errors appear, then the MySQL server has started successfully.

Step 4: Check MySQL server status

Check whether the MySQL server is running.

sudo systemctl status mysqld

If you see the running status after running this command, it means that the MySQL server has been started successfully.

MySQL Database Management

Now, MySQL has been successfully installed and running. Next, let's do database management via the command line.

Log in to the MySQL database

Enter the following command in the terminal to log in to the MySQL database.

sudo mysql -u root -p

This command will prompt for a password, enter the password you set during the MySQL installation.

We can also query the version from the console when logging in:

sudo mysql -u root -p -e "SELECT VERSION();"

Create Database

To create a new database, use the following command:

CREATE DATABASE new_database;

This command will create a new database named "new_database".

Create database user

To create a new user and authorize access to the database, please use the following command:

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

This command will create a new user with the alias "new_user" user and assign a password to them.

Authorize users to access the database

To authorize users to access the database, please use the following command:

GRANT ALL PRIVILEGES ON new_database.* TO 'new_user'@'localhost';

This command will authorize the "new_user" user to access the name "new_database" new database.

Update user password

To update a user's password, use the following command:

ALTER USER 'new_user'@'localhost' IDENTIFIED BY 'new_password';

Delete database

To delete a database that the current user can access, Please use the following command:

DROP DATABASE database_name;

This command will delete the database named "new_database".

Summary

It is very simple to install the MySQL database using RPM package on CentOS operating system. Just add the Yum library for MySQL, use the Yum tool to install the MySQL server, start the server, log in to the database, and then create, manage, and delete the database. Hope this article is helpful to you.

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