How to install MySQL on RedHat6.5?

How to install MySQL on RedHat6.5? The following article will introduce to you how to install MySQL5.7 under RedHat6.5. I hope it will be helpful to you.

Related learning recommendations: mysql tutorial

Installation environment:

RedHat6.5

Installation steps:

First step: Download

Download MySQL5.7: http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.12-1.el6.x86_64.rpm- bundle.tar

Step 2:Installation

Check whether MySQL is installed on the server before installation. If it is installed, uninstall it:

[root@worker1 tmp]# rpm -qa|grep mysql
mysql-libs-5.1.71-1.el6.x86_64
[root@worker1 tmp]# rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64 //卸载

Unzip the downloaded file:

[root@worker1 tmp]# tar -xf mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar

Install in order:

rpm -ivh mysql-community-common-5.7.12-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.12-1.el6.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.12-1.el6.x86_64.rpm
rpm -ivh mysql-community-client-5.7.12-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.12-1.el6.x86_64.rpm

No surprises , MySQL should have been installed successfully.

Step 3: Environment variable setting

1. Start MySQL: service mysqld start

2. Login: mysql -u root -p, the initial login password is empty, just press Enter:

Why does this error occur? The reason is because MySQL5 There is no Password field in the mysql.user table in .7, so you need to log in in a secure manner and then change the password.

The solution is as follows:

Modify the MySQL configuration file: vim /etc/my.cnf, at the end of the file Add: skip-grant-tables, save and restart the MySQL service: service mysqld restart, and then log in again.

3. Change the password. The user password is under the database named mysql:

Execute the following instructions in sequence:

mysql> use mysql
mysql> update user set password_expired='N' where user='root'; 
mysql> update user set authentication_string=password('123456') where user=‘root';
mysql> flush privileges;

Note: Be sure to remove the skip password detection content previously added to the my.cnf configuration file and restart the service;

Others:

1. Encoding settings: vim /etc/my.cnf, add encoding content at the end of the file default-character-set=utf8

2. Allow remote access to MySQL: Grant any host permission to access data

mysql>grant all privileges on . to ‘root'@'%'with grant option;

will report an error:ERROR 1133 (42000): Can't find any matching row in the user table

In fact, it will be normal if the root user exists in the mysql.user table in advance, or It is normal to add identified by 'password' at the end of this sentence. For example, the following command line

mysql>grant all privileges on . to ‘root'@'%'identified by ‘123456' with grant option;

3. Change the password policy:

mysql> set global validate_password_length=0; --更改密码长度
mysql> set global validate_password_policy=0; --更改密码策略为LOW

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