Centos7下安装mysql5.6

 centos7下快速安装mysql

CentOS 7的yum源中貌似没有正常安装mysql时的mysql-sever文件，需要去官网上下载
    
# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
# rpm -ivh mysql-community-release-el7-5.noarch.rpm
# yum install mysql-community-server

成功安装之后重启mysql服务

1
    
# service mysqld restart

初次安装mysql是root账户是没有密码的

设置密码的方法

# mysql -uroot
mysql> set password for 'root’@ 'localhost’ = password('root');

UPDATE user SET password=PASSWORD('root') WHERE user='root';

FLUSH   PRIVILEGES;

mysql> exit

搞定！

远程授权连接mysql

方法一:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root123456' WITH GRANT OPTION; 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'111.193.218.138' IDENTIFIED BY 'root' WITH GRANT OPTION;(mysql客户端登陆的密码和授权的密码可以不一致)

FLUSH   PRIVILEGES;

方法二:
1.进入 mysql：

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

2.使用 mysql库 ：

use mysql;

3.查看用户表 ：

SELECT Host,User FROM user;

4.更新用户表 ：

UPDATE user SET `Host` = '127.0.0.1' WHERE `User` = 'root' LIMIT 1;

5.强制刷新权限 ：

flush privileges;

# mysql -uroot -p
Enter password: 【输入原来的密码】
mysql>use mysql;
mysql> update user set password=passworD("lsd2017") where user='root';
mysql> flush privileges;
mysql> exit;