wdcp安装mysql5.6_yum安装mysql5.6和mysql5.7

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