mysql installation tutoriallinux

MySQL is a popular relational database management system that can be used on various platforms and can also be used on Linux.

There are many ways to install MySQL on Linux. This article will introduce the specific steps and methods of installing MySQL on Linux through the command line and source code.

1. Install MySQL from the command line

Step 1: Update the system and install necessary software packages

Before installing MySQL, you need to update the system and install some necessary software packages .

Open the terminal and execute the following command:

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install build-essential

Steps 2: Install MySQL

Execute the following command to install MySQL:

sudo apt-get install mysql-server

During this process, the system will prompt you to enter the MySQL root user password. Please make sure to use a strong password to ensure security.

Step 3: Set up MySQL security

After installing MySQL, it is recommended to run the following command to enhance the security of MySQL:

sudo mysql_secure_installation

Execute this The command will start the MySQL security script, which will ask you several questions, including whether to set a root password, whether to delete anonymous users, whether to prohibit root users from remote access, etc.

Step 4: Verify that MySQL is installed correctly

Execute the following command to verify that MySQL is installed correctly:

systemctl status mysql.service

If " active (running)" means MySQL is installed successfully.

2. Install MySQL from source code

If you need more flexible control and want to use the latest version of MySQL, you can choose to install MySQL from source code.

Step 1: Download the MySQL source code

Before installation, you need to download the MySQL source code. It can be downloaded from the MySQL official website.

Step 2: Decompress and compile the source code

Decompress the downloaded source code, enter the decompression directory in the terminal, and then execute the following command:

./configure
make
sudo make install

The above command will compile and install MySQL. Before executing the make command, you need to ensure that gcc and other necessary build tools are installed.

Step 3: Start MySQL

After completing the installation of MySQL, you need to start MySQL.

Start MySQL using the following command:

sudo /usr/local/mysql/bin/mysqld_safe &

Step 4: Set the MySQL root password

Execute The following command sets the password of the MySQL root user:

sudo /usr/local/mysql/bin/mysqladmin -u root password 'new-password'

Step 5: Log in to MySQL

Execute the following command to log in to MySQL:

/usr/local/mysql/bin/mysql -u root -p

In the MySQL terminal, you can create new users, databases, tables wait.

3. Summary

Whether installing MySQL through the command line or source code, some skills and knowledge are required. Although command line installation is relatively simple, source code installation requires more skills and experience. No matter which installation method you choose, you need to operate it carefully to ensure that no errors occur when installing MySQL.

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