How to configure and manage database services on Linux

In modern computer application development, databases are an integral part. In addition to installing the database software in the operating system, it also needs to be configured and managed. In this article, we will detail how to configure and manage database services on Linux and provide specific code examples.

In this article, we will focus on the MySQL database as it is one of the most popular open source relational databases. We will also use MySQL server on Linux operating system. How to install MySQL server varies by operating system, but an increasing number of Linux distributions include it in their default software repositories, so it can be easily installed from the package manager.

Once you have installed the MySQL server, you need to configure it to run. First, you need to assign a MySQL system user and ensure that the user has the appropriate permissions.

sudo useradd mysql
sudo passwd mysql

Next, you need to install the MySQL package and start the MySQL server when the system starts. The following are the commands to install and start the MySQL server on Ubuntu:

sudo apt-get update
sudo apt-get install mysql-server
sudo systemctl start mysql
sudo systemctl enable mysql

Once the installation is complete, you can connect to the MySQL server using the following command:

mysql -u root -p

Then, you can start creating and managing databases , and add data to the table. Here are some example commands:

• Create a new database

CREATE DATABASE mydatabase;

• Delete a database

DROP DATABASE mydatabase;

• Create A new table

CREATE TABLE mytable (id int, name VARCHAR(255));

• Delete a table

DROP TABLE mytable;

• Insert data into a table

INSERT INTO mytable (id, name) VALUES (1, 'John');

• Display all data in the table

SELECT * FROM mytable;

In addition, you can also use the following command to configure the MySQL server:

• Change the listening port of the MySQL server

In the MySQL configuration file (located in /etc/mysql/mysql.conf.d/mysqld.cnf), find the following line:

port = 3306

Change "3306" to the desired port number, Then restart the MySQL server.

• Create a new MySQL user

Use the following command to create a new MySQL user (replace the name and password with what you want):

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

• Assign permissions to new users

Assign permissions to new users using the following command:

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

• Change the password of an existing MySQL user

Use the following command to change the password of an existing MySQL user (replace the name and password with your own username and new password):

SET PASSWORD FOR 'username'@'localhost' = PASSWORD('newpassword');

In summary, to configure and manage a MySQL server on Linux, you Need to know how to create and manage databases, tables, and users. The example commands provided above can help you get started. By combining these basic commands with more advanced MySQL features, you will be able to build a stable, reliable database server that provides reliable data storage and management for your applications.

The above is the detailed content of How to configure and manage database services on Linux. For more information, please follow other related articles on the PHP Chinese website!