1、install mysql5.6
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
#启动服务
service mysqld restart
#设置初始密码
mysql> set password for 'root'@'localhost' =password('password');
Query OK, 0 rows affected (0.00 sec)
#配置编码
vi /etc/my.cnf
[mysql]
default-character-set =utf8
#这里的字符编码必须和/usr/share/mysql/charsets/Index.xml中一致。
2、远程连接设置
#把在所有数据库的所有表的所有权限赋值给位于所有IP地址的root用户。
mysql> grant all privileges on *.* to root@'%'identified by 'password';
#如果是新用户而不是root,则要先新建用户
mysql>create user 'username'@'%' identified by 'password';
此时就可以进行远程连接了。
#install mysql5.7
#下载服务端
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-server-5.7.17-1.el7.x86_64.rpm
#下载客户端
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-client-5.7.17-1.el7.x86_64.rpm
#安装
rpm -ivh mysql-community-server-5.7.17-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-5.7.17-1.el7.x86_64.rpm --nodeps
#启动服务
service mysqld start
#获取临时密码
grep 'temporary password' /var/log/mysqld.log
#登录mysql
mysql -uroot -p
#输入临时密码
#忽略授权表
vi etc/my.cnf
[mysqld]
skip-grant-tables
#登录mysql
mysql> SET PASSWORD = PASSWORD('root');
#重启mysql
[root@VM_167_102_centos /]# service mysqld restart
Redirecting to /bin/systemctl restart mysqld.service