MySQL安装及配置

1.下载安装

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

2.开启MySQL服务

service mysql start

3.设置密码

MySQL安装后默认密码是空

mysql> set password for 'root'@'localhost' =password('password');

把在所有数据库的所有表的所有权限赋值给位于所有IP地址的root用户

mysql> grant all privileges on *.* to root@'%'identified by 'password';