Install mysql command
May 12, 2023 am 09:18 AMInstall 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.
- 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
- 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.
- 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)".
- 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.
- 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.
- 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!

Hot tools Tags

Hot Article

Hot tools Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Reduce the use of MySQL memory in Docker

How do you alter a table in MySQL using the ALTER TABLE statement?

How to solve the problem of mysql cannot open shared library

Run MySQl in Linux (with/without podman container with phpmyadmin)

What is SQLite? Comprehensive overview

Running multiple MySQL versions on MacOS: A step-by-step guide

How do I secure MySQL against common vulnerabilities (SQL injection, brute-force attacks)?

How do I configure SSL/TLS encryption for MySQL connections?
