How to install MySQL on CentOS 6.4

CentOS 6.4 is an operating system based on Linux. As a programmer, you may need to install MySQL on CentOS 6.4 to facilitate your development work. This article will introduce you to how to install MySQL on CentOS 6.4.

Step 1: Download MySQL

First, you need to download MySQL from the MySQL official website. Select the version suitable for your system on the download page and download it. If you are unsure, it is recommended to choose the Linux-Generic version.

Step 2: Install MySQL

After the download is completed, unzip the downloaded file and you will get a folder. Next, enter the folder and execute the following command:

$ tar -zxvf mysql-5.6.42-linux-glibc2.12-x86_64.tar.gz

You can also change the above command to an appropriate file name.

Step 3: Create MySQL users and groups

Before installing MySQL, you need to create a user named MySQL and a group named mysql. Use the following command to create a MySQL user and group on CentOS 6.4:

$ groupadd mysql
$ useradd -g mysql mysql

Step 4: Install MySQL

Next, you can start installing MySQL. To install MySQL, you need to move the unzipped MySQL installation folder to the appropriate installation directory. You can use the following command to move the folder:

$ mv mysql-5.6.42-linux-glibc2.12-x86_64 /usr/local/mysql

Then, enter the installation directory and execute the following command in the console:

$ cd /usr/local/mysql
$ ./scripts/mysql_install_db --user=mysql

This command will install MySQL on your computer and create the necessary system tables. If you find a "permission denied" error when executing this command, you need to add sudo before the command:

$ sudo ./scripts/mysql_install_db --user=mysql

After completing the installation, you will see a message saying "[OK] Installing MySQL system tables…OK”. This means MySQL has been installed successfully.

Step 5: Start MySQL

After the installation is completed, MySQL will not start automatically by default. You need to start MySQL manually. Here's how to start MySQL on CentOS 6.4. Execute the following command:

$ cd /usr/local/mysql
$ ./bin/mysqld_safe &

This command will start the MySQL server and put the server process into the background so that you can run other instructions in the background.

Step 6: Log in to MySQL

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

$ /usr/local/mysql/bin/mysql -u root -p

This will allow you to enter the MySQL command line mode and enter the MySQL root you set. Password to log in.

At this point, you can install and use MySQL on the CentOS 6.4 operating system. Have fun using MySQL!

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