How to install mysql on centos tar

CentOS is a distribution version of the Linux operating system, which is developed based on Red Hat Enterprise Linux (RHEL). Installing MySQL in CentOS requires some extra steps, but if you follow the steps below, you will be sure to have a successful installation. This article will introduce how to install MySQL through tar package.

1. Download the tar package suitable for your MySQL version from the MySQL official website

Please note: Please make sure you have installed the necessary tools and libraries before downloading MySQL. For example, with the gcc compiler, this can be verified with the following command:

gcc -v

If you have gcc installed, it will return the gcc version information. If you do not have it installed, please use the following command to install it:

sudo yum install gcc-c++

2. Decompress the MySQL tar package

Use the following command to decompress the downloaded MySQL tar package:

tar -xzvf mysql-<version>.tar.gz</version>

Where version is the MySQL version number you downloaded.

3. Install MySQL dependencies

Installing MySQL in CentOS requires some dependencies, you can install them using the following command:

sudo yum install libaio

4. for MySQL Create Group and User

Use the following commands to create a new group and user:

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

5. Configure MySQL

After unzipping the MySQL There is a my.cnf file in the directory, which is the MySQL configuration file. You need to do the following:

sudo cp /path/to/mysql-<version>/support-files/my-default.cnf /etc/my.cnf
sudo vi /etc/my.cnf</version>

Open the my.cnf file and replace the [mysqld] part with the following code:

[mysqld]
datadir=/data/mysql
socket=/data/mysql/mysql.sock
user=mysql
symbolic-links=0

In the my.cnf file, add datadir and socket to [mysqld] section. Note that these values ​​should be placed where your MySQL data is stored.

6. Initialize the MySQL data directory

sudo mkdir /data/mysql
sudo chown mysql:mysql /data/mysql
sudo /path/to/mysql-<version>/bin/mysqld --initialize --user=mysql</version>

Enter the above command to initialize the MySQL data directory. Note that the --user parameter should match the mysql user you created in step 4.

7. Start MySQL

Use the following command to start MySQL:

sudo /path/to/mysql-<version>/bin/mysqld_safe --user=mysql &</version>

Please note that please replace with your The actual path to the MySQL version used.

8. Change MySQL Administrator Password

By default, the password for the MySQL administrator account is blank. Use the following command to change the MySQL administrator password:

sudo /path/to/mysql-<version>/bin/mysqladmin -u root password 'newpassword'</version>

Remember to replace newpassword with your own password.

9. Login to MySQL

Now you can log in to MySQL using the following command:

mysql -u root -p

You need to enter the password for the MySQL administrator account.

Summary:

These are all the steps to install MySQL via tarball on CentOS. If you follow these steps, you can install MySQL without any problems. This is the most basic way to install MySQL and is relatively simple. If you have more needs, such as more complex tasks such as installing a specific version of MySQL, please visit MySQL's official documentation for more information.

The above is the detailed content of How to install mysql on centos tar. For more information, please follow other related articles on the PHP Chinese website!