Installation of mysql under linux

(Note: This article assumes that readers already have some basic knowledge of Linux)

MySQL is an open source database management system commonly used in Web application development and other fields. In the Linux operating system, the installation of MySQL is relatively simple. This article will introduce how to install MySQL under Linux.

1. Preparation work

Before installing MySQL, we need to do some preparation work. First, make sure that GCC, make, and other necessary software packages are installed on the Linux system. Use the command line to enter the terminal and execute the following command to check whether the system has installed these software packages:

gcc --version
make --version

If the command returns version information, it means that the corresponding software package has been installed. Otherwise, they can be installed using your Linux system’s package manager.

2. Download MySQL

Download the latest MySQL software package from the official website https://dev.mysql.com/downloads/mysql/. We choose the Community Server version, which is the most commonly used and free open source version of the Enterprise Edition.

3. Install MySQL

After downloading the MySQL software package, you can install MySQL through the following steps:

1) Unzip the MySQL software package

tar -zxvf mysql-xxx.tar.gz

2) Enter the MySQL directory

cd mysql-xxx

3) Create the MySQL installation directory

mkdir /usr/local/mysql

4) Move the MySQL directory to the installation directory

mv mysql-*/* /usr/local/mysql

5) Enter MySQL Directory

cd /usr/local/mysql

6) Initialize MySQL

scripts/mysql_install_db --user=mysql

7) Modify MySQL directory permissions

chown -R mysql:mysql /usr/local/mysql

8) Start MySQL

bin/mysqld_safe --user=mysql &

After running the above command, MySQL will will run in the background. If you want to shut down MySQL, you can use the command:

bin/mysqladmin -u root shutdown

4. Configure MySQL

The MySQL configuration file is located in etc/my.cnf. We need to edit this file to configure MySQL. The following are some common configurations:

1) Modify the MySQL default installation directory

basedir = /usr/local/mysql
datadir = /usr/local/mysql/data

2) Change the MySQL default port number

port = 3306

3) Set the MySQL default character set to UTF- 8

character-set-server = utf8

4) Disable MySQL’s default strict mode

sql_mode = NO_ENGINE_SUBSTITUTION

5. Log in to MySQL

We have successfully installed and configured MySQL, enter at the command line You can log in to MySQL with the following command:

mysql -u root -p

Enter your password to enter the MySQL command line interface.

6. Summary

The above are all the steps to install and configure MySQL under Linux. Although MySQL is a powerful database management system, installing and configuring MySQL under Linux is relatively simple. This article hopes to help readers install and configure MySQL easily and quickly in the Linux operating system.

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