mysql linux installation directory

MySQL is an open source relational database management system that is widely used in Web application development. The Linux installation directory of MySQL is relatively simple. The specific steps are described below.

1. Download the MySQL installation package

First you need to download the corresponding version of the installation package from the MySQL official website. It is recommended to download the latest stable version. After downloading, unzip the installation package to a suitable directory, such as the /usr/local directory.

2. Installing dependencies

Before installing MySQL, you need to install some necessary dependency libraries. You can use the following command to install:

sudo apt update
sudo apt install libaio1 libaio-dev

3. Create a MySQL user and group

Create a MySQL user and group for installing and starting the MySQL service:

sudo groupadd mysql
sudo useradd -r -g mysql -s /bin/false mysql

4. Install MySQL

Use the following command to install MySQL:

sudo tar -zxvf mysql-*.tar.gz -C /usr/local/
sudo ln -s /usr/local/mysql-* /usr/local/mysql
sudo chown -R mysql:mysql /usr/local/mysql
cd /usr/local/mysql
sudo bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
sudo cp support-files/mysql.server /etc/init.d/mysql.server
sudo chmod +x /etc/init.d/mysql.server
sudo update-rc.d mysql.server defaults

Among them, mysql-* represents the file name of the MySQL installation package, --user=mysql --basedir=/usr/local/ mysql --datadir=/usr/local/mysql/data specifies the MySQL data directory.

5. Start the MySQL service

Use the following command to start the MySQL service:

sudo service mysql.server start

6. Configure MySQL

Enter the MySQL client:

cd /usr/local/mysql/bin
./mysql -uroot -p

When you enter the MySQL client for the first time, the default password is empty and you need to reset the root user password:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new_password';

Among them, new_password is Newly set password.

7. Verify the installation and configuration of MySQL

Use the following command to verify the installation and configuration of MySQL:

sudo netstat -anp | grep 3306

If the output contains 3306 means that MySQL is installed successfully.

At this point, the MySQL Linux installation directory is configured. MySQL is a powerful, mature and stable database management system. Installing it using a Linux system can better ensure system stability and data security.

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