centos 6.5 install mysql

CentOS 6.5 is a free and open source Linux operating system widely used in servers, desktops, embedded systems and cloud environments. Mysql is a popular relational database management system commonly used for data storage on websites, applications, and servers. Installing Mysql on CentOS 6.5 is a basic task, let’s explain how to do it in detail below.

1. Preparations before installing Mysql

1. Update system software packages
Before installing Mysql, you need to ensure that all system software packages are up to date. System software packages can be updated through the following command:

yum update

2. Install EPEL repository
Mysql requires some additional software packages to work properly. You need to install the EPEL repository to get these packages. The EPEL repository can be installed through the following command:

yum install epel-release

3. Enable Remi repository
The Remi repository is a third-party repository that provides the latest Mysql version. In order to enable the Remi repository, you need to install the RPM package of the Remi repository and install the yum plugin using the following command:

rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6. rpm
yum -y install yum-utils

4. Disable SELinux
SELinux is a security enhancement tool that can limit the permissions of the process and protect the system from attacks. But sometimes, it may prevent Mysql from running. Therefore, we need to disable SELinux, which can be achieved by editing the "/etc/selinux/config" file:

nano /etc/selinux/config

Replace the following lines:

SELINUX=enforcing

Change to:

SELINUX=disabled

5. Install Mysql dependent software packages
Mysql requires some dependent software packages to work properly. We can install these packages through the following command:

yum -y install gcc gcc-c cmake ncurses-devel perl-Data-Dumper

2. Install Mysql

1 , Install Mysql server
Use the following command to install Mysql server:

yum --enablerepo remi,remi-test install mysql mysql-server

2. Start Mysql service
You can use The following command starts the Mysql service:

service mysqld start

3. Set the Mysql service to start automatically at boot
You can use the following command to set the Mysql service to start automatically at boot:

chkconfig mysqld on

4. Configure Mysql
After installing Mysql, some configurations are required. First, you need to set the root password of Mysql:

mysqladmin -u root password 'your_new_password_here'

Then, you need to edit the Mysql configuration file "/etc/my.cnf" and bind-address Comment out the line to allow remote access to the Mysql service:

nano /etc/my.cnf

Replace the following line:

bind-address = 127.0.0.1

Change to:

bind-address = 0.0.0.0

5. Restart the Mysql service
After modifying the configuration file, you need to restart the Mysql service:

service mysqld restart

3. Test Mysql

1. Test Mysql user
You can use the following command to test whether the Mysql user can access Mysql:

mysql -u root -p

Enter the root user password. If you can successfully enter the Mysql interface, it means that the user can access Mysql normally.

2. Test Mysql database
You can use the following command to test whether the Mysql database can be used normally:

mysql -u root -p -e "show databases;"

If all databases can be displayed, Mysql has been successfully installed.

4. Summary

This article introduces the process of installing Mysql on CentOS 6.5. Before installing Mysql, some preparations need to be done, such as updating system packages, installing EPEL repository, enabling Remi repository, disabling SELinux, etc. When installing the Mysql service, you need to start the Mysql service, set the Mysql service to start automatically at boot, configure Mysql, and restart the Mysql service. After the installation is complete, some tests need to be performed to ensure that Mysql is working properly. I hope this article can be helpful to you, thank you for reading!

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!