Installation of mysql under linux

Linux is an open source operating system, and MySQL is an open source relational database management system that is widely used in the development of Web applications. This article will introduce how to install MySQL database under Linux system.

1. Determine the installation method

Before installing MySQL, we need to choose the appropriate installation method. Generally speaking, there are two installation methods for MySQL: source code installation and binary package installation. Source code installation requires manual compilation of MySQL source code and configuration of the environment, and is suitable for users with certain Linux practical experience and technical capabilities. The binary package installation is simpler. You can directly download the installation package and execute the installation script. For novices, it is recommended to use the binary package installation method.

2. Download the MySQL installation package

Before starting the installation, we need to download the MySQL installation package. You can download the latest version of the installation package from the MySQL official website. After the download is completed, it needs to be uploaded to the Linux system.

3. Installing dependent packages

MySQL needs to call some system libraries and development packages in Linux, so before installing MySQL, you need to ensure that the packages it depends on have been installed. We can use the following command to install the MySQL dependency package:

sudo apt-get install libaio1 libmecab2

4. Decompress the MySQL installation package

Before installing MySQL, we need to decompress the MySQL installation package. After uploading the installation package to the Linux system, we can use the following command to decompress it:

tar -zxvf mysql-5.7.26.tar.gz

Among them, "mysql-5.7.26.tar.gz" is the name of the MySQL installation package, which should be carried out according to the actual situation. replace.

5. Create MySQL users and groups

Before installing MySQL, we need to create MySQL users and groups in the Linux system. We can use the following commands to create MySQL groups and users:

groupadd mysql
useradd -r -g mysql mysql

6. Install MySQL

After unzipping the MySQL installation package and creating MySQL users and groups, we can start the installation MySQL. We can use the following command to execute the MySQL installation script:

cd mysql-5.7.26/
sudo ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

This will execute the MySQL initialization script and install MySQL in the "/usr/local/mysql" directory. After execution, we need to modify the MySQL configuration file my.cnf. In my.cnf, we can modify the MySQL opening method, data storage path and other settings.

7. Start MySQL

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

sudo service mysql start

After the startup is successful, we can use the following command to log in and Test whether MySQL is successfully installed:

mysql -u root -p

8. Set the MySQL administrator password

After the MySQL installation is completed, we need to set the MySQL administrator password. We can use the following command to set the administrator password:

mysqladmin -u root password "newpassword"

Among them, "newpassword" is the new administrator password, which should be replaced according to the actual situation.

At this point, the installation and configuration of MySQL under Linux have been completed. We can start using MySQL for development work.

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!