mysql for linux installation tutorial

MySQL is a popular relational database management system and an important component of many web applications. This article will introduce how to install MySQL on the Linux operating system.

1. Prerequisites

Before installing MySQL, you need to have the following conditions in the Linux system:

1. System administrator rights.
2. An SSH terminal (for example, command line terminal, etc.).
3. Already installed and configured a LAMP (Linux, Apache, MySQL, PHP) or LEMP (Linux, Nginx, MySQL, PHP) stack.

2. Install MySQL

The following are the steps to install MySQL on a Linux system:

Step 1: Update the software package

First, The system should be updated using the following command: sudo apt update

Step 2: Install MySQL

Install MySQL by running the following command: sudo apt install mysql-server

This command will automatically Install MySQL server and its related dependencies.

Step Three: Check MySQL Service

After the installation is complete, you can use the following command to check whether MySQL has been started: sudo systemctl status mysql

If MySQL is running, the screen The following will be output: Active: active (running)

Step 4: Configure MySQL

MySQL installation runs on the local host by default, and only visitors can access MySQL. Since MySQL does not yet have a password, the system will prompt you to set a password when you access it for the first time.

Use the following command to configure MySQL: sudo mysql_secure_installation

This command will guide you to perform basic security settings for MySQL, such as disabling anonymous users, deleting test databases, disabling remote root users, etc. After completing these settings, your MySQL instance will be more secure.

Step Five: Test MySQL

After installing and setting up MySQL, you can use the following command to test MySQL:

• Use the following command to log in to MySQL: sudo mysql -u root -p
• Enter the MySQL password you set.

If all goes well, you will see a MySQL command line interface similar to the following: Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 8

Server version: 8.0.19-0ubuntu5 (Ubuntu)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Now, you are ready to run MySQL on your Linux system.

Conclusion:

MySQL is a very popular relational database management system. Installing MySQL on a Linux system only requires a few simple commands. The steps in this article can guide you through the process of ensuring MySQL is installed and configured on your system.

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