Install mysql command

Install MySQL command

MySQL is the most popular open source relational database management system in the world and is widely used in the development of Web applications. To install MySQL on a Linux system, you can do it through the command line. This article will introduce how to install MySQL using the command line.

1. Update System

Before installing MySQL, it is recommended to update your system to ensure that you have the latest version of the package.

On Debian or Ubuntu systems, you can use the following command to update the system:

sudo apt update
sudo apt upgrade

On CentOS or Fedora systems, you can use The following command updates the system:

sudo yum update
sudo yum upgrade

2. Install MySQL

After updating the system, you can use the following command to Install MySQL:

On Debian or Ubuntu systems:

sudo apt install mysql-server

On CentOS or Fedora systems:

sudo yum install mysql-server

During the installation process, you will be prompted to enter the MySQL root password. Note that this is the administrator password for your MySQL database, so make sure to use a strong password and remember it.

3. Start MySQL

After installation is complete, you can use the following command to start MySQL:

On Debian or Ubuntu systems:

sudo systemctl start mysql

On CentOS or Fedora systems:

sudo systemctl start mysqld

You can also use the following command to check the running status of MySQL:

On Debian or Ubuntu systems:

sudo systemctl status mysql

On CentOS or Fedora systems:

sudo systemctl status mysqld

If MySQL is running Run, the output will show "active (running)".

4. Configuring MySQL

After installing and starting MySQL, you need to do some configuration on it to ensure that it can run properly and achieve the required functions.

First, you need to run the following command to ensure that the MySQL server is configured correctly:

sudo mysql_secure_installation

This command will walk you through some important MySQL configuration, including:

• Delete anonymous users
• Disable root user remote login
• Remove test database
• Reload permission table to ensure security

Please follow the prompts.

5. Log in to MySQL

After installing and configuring MySQL, you can use the following command to log in to the MySQL server:

mysql -u root -p

This command will prompt you for the MySQL administrator password. If the password is correct, you will enter the MySQL command line interface.

6. Using MySQL

After installing and logging into MySQL, you can start using it. The following are some commonly used MySQL commands:

• Show all databases: SHOW DATABASES;
• Create a new database: CREATE DATABASE databasename;
• Delete a database: DROP DATABASE databasename ;
• Use database: USE databasename;
• Display all tables in the database: SHOW TABLES;
• Create a new table: CREATE TABLE tablename (column1 datatype1, column2 datatype2);
• Delete table: DROP TABLE tablename;
• Insert data: INSERT INTO tablename (column1, column2) VALUES (value1, value2);
• Query data: SELECT column1, column2 FROM tablename WHERE condition;

These commands are just one of the basic commands of MySQL. If you want to learn more about MySQL, see the MySQL documentation.

Summary

Installing MySQL is one of the basic steps required to create a web application. Installing MySQL via the command line is easy and requires only a few steps. Installing and configuring MySQL may take some time and effort, but once completed, you can start using the database to build robust web applications.

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