How to install MySQL on CentOS using tar package
MySQL is a widely used relational database management system. It is open source software and can run on various operating systems. There are usually multiple methods to choose from for installing MySQL on CentOS, but installing MySQL using a tarball is a very simple method. This article will show you how to install MySQL on CentOS using a tar package.
Step 1: Prepare the installation environment
Before installing MySQL, you need to prepare some prerequisites to ensure that MySQL can run on the system. Here are the prerequisites you need to prepare:
1. Make sure you have the latest version of CentOS system,
2. Install the necessary dependencies and software: gcc, gcc-c, make, cmake and ncurses-devel.
yum -y install gcc gcc-c make cmake ncurses-devel
Step 2: Download MySQL
Install MySQL by downloading the tar package from the MySQL official website. You can find the latest version of MySQL at https://dev.mysql.com/downloads/mysql/.
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.31.tar.gz
Step 3: Unzip the tar package
Before installing MySQL, we need to unzip the tar package to the specified directory. This can be done using the following command:
tar -zxvf mysql-5.7.31.tar.gz
Step 4: Create MySQL users and groups
In order to use MySQL correctly, We need to create a user and group, generate the MySQL default storage directory and grant permissions to it. Here we will create a user and group named "mysql".
groupadd mysql
useradd -g mysql mysql -s /bin/false
mkdir -p /usr/local/mysql/data
touch /var/log/mysql.log
Step 5: Compile and install MySQL
Next, we need to compile MySQL using the following command
cd mysql-5.7.31
cmake \
-DCMAKE_INSTALL_PREFIX= /usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DWITH_BOOST=/usr/local/boost \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DDOWNLOAD_BOOST=1 \
-DFORCE_INSOURCE_BUILD=1
See the picture below, indicating that the configuration is successful
Next compile MySQL using the command
make
Then, you need to install MySQL using the following command.
make install
Step 6. Configure MySQL
Now, we need to configure MySQL. The MySQL configuration file is located at /usr/local/mysql/etc/my.cnf. However, we can easily generate a new my.cnf file using the following command.
./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
Verify whether the SQL installation is correct
service mysql start
mysql -u root -p
When entering the default password, you need to find it in the log file
cat /var/log/mysql.log | grep 'A temporary password' | tail -1 | awk -F '[ ]' '{print $NF}'
It will return a random password. Use this password to log in and change your password.
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
Okay, now you have successfully installed MySQL using the tar package on CentOS. As you can see, this is a very simple method that you can easily use in any system and application that needs to use MySQL.
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!
