centos 7 安装mysql

//安装mysql5姿势是要先安装带有可用的mysql5系列社区版资源的rpm包

rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

//mysql安装资源：
yum repolist enabled | grep “mysql.-community.”

//yum 安装
yum -y install mysql-community-server

//加入开机启动
systemctl enable mysqld

//启动mysql服务进程

systemctl start mysqld

//重置密码
mysql_secure_installation

//登录MYSQL（有ROOT权限）。这里我以ROOT身份登录
[root@iZ28gvqe4biZ ~]# mysql -u root -p
//修改访问权限，让其他计算机也能访问
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION;

usr mysql;

UPDATE user SET Password = password ( ‘123456’ ) WHERE User = ‘root’ ;
flush privileges ;

SHOW VARIABLES LIKE ‘character%’;
SET character_set_client = utf8 ;
SET character_set_connection = utf8 ;
SET character_set_database = utf8 ;
SET character_set_results = utf8 ;
SET character_set_server = utf8 ;

SET collation_connection = utf8 ;
SET collation_database = utf8 ;
SET collation_server = utf8 ;

SET NAMES ‘utf8’;