安装mysql5.6步骤

闲话不多说直接开撸

下载mysql      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 -y

检查是否安装成功      rpm -qa | grep mysql

启动服务   systemctl start mysqld.service #启动 mysql
                 systemctl restart mysqld.service #重启 mysql
                 systemctl stop mysqld.service #停止 mysql
                 systemctl enable mysqld.service #设置 mysql 开机启动

设置密码 # mysql -u root
                   mysql> use mysql;
                   mysql> update user set password=PASSWORD("这里输入root用户密码") where User='root';
                   mysql> flush privileges; 

设置主机远程登录

mysql> GRANT ALL PRIVILEGES ON *.* TO 'your username'@'%' IDENTIFIED BY 'your password';

mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";

bind-address = 0.0.0.0

update user set host='%' where user='root';