centos 6.5 install mysql

CentOS 6.5 is a relatively old but still widely used Linux operating system, and MySQL is one of the most popular open source databases in the world. I believe many people need to install MySQL on CentOS 6.5. A detailed installation tutorial will be provided below.

1. Download the MySQL installation package

Before installing MySQL, you need to download the corresponding installation package. You can download the latest MySQL binary compressed package from the MySQL official website. In this tutorial, we will use MySQL version 5.7 for demonstration.

2. Install dependent libraries

Before installing MySQL, you need to install dependent libraries first. It can be installed through the following command:

sudo yum install libaio

3. Extract the MySQL installation package

Extract the downloaded MySQL installation package to the specified directory . Use the following command to decompress:

tar xvf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz -C /usr/local/mysql

4. Create MySQL Data storage directory

MySQL data storage files are located in the "/var/lib/mysql" directory by default. In order to keep the system clean and secure, we can manually create a storage directory and give it the mysql user permissions.

mkdir /data/mysql
chmod -R 777 /data/mysql

5. Create MySQL users and user groups

To maintain security and controllability, we need to create a MySQL user and user group. Run the following command to create:

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

6. Move the MySQL unzipped file

After we decompress the compressed package, we can view the decompressed file path and move it to the specified directory. The operation command is as follows:

cd /usr/local
mv mysql-5.7.28-linux-glibc2.12-x86_64 mysql

After moving the file, we need to decompress the MySQL file Change the owner to the mysql user and user group to ensure correct configuration of MySQL access permissions.

chown -R mysql:mysql mysql

7. Initialize MySQL

Before installing MySQL, we need to initialize it with the following command:

cd mysql
bin/mysqld --defaults-file=my.cnf --user=mysql --datadir=/data/mysql --initialize

Note: The specified data storage above must be used Directory and MySQL configuration file commands to obtain the correct permissions and configuration files after the MySQL installation is completed.

8. Start MySQL

After executing the above command, we can use the following command to start the MySQL server:

bin/mysqld_safe --defaults-file =my.cnf &

9. Set MySQL to start at boot

In order to facilitate management and use, we can set MySQL to start automatically when the system starts. You can use the following command:

cp support-files/mysql.server /etc/init.d/mysql
chmod x /etc/init.d/mysql
chkconfig --add mysql
chkconfig mysql on

10. Log in to MySQL

Now, MySQL is installed and running on CentOS 6.5. We can use the following command to log in to MySQL:

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

After entering the command, the login interface of the MySQL database will appear, enter You can enter after setting the root password.

Summary

MySQL is a widely used database, and CentOS 6.5 is a server operating system with stability and security. In this article, we provide a tutorial for installing MySQL in CentOS 6.5. We hope this article helps you easily install and configure MySQL on CentOS 6.5 to meet your data storage and management needs.

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