centos7用源码包安装MySQL5.7

2017-08-17 centos7用源码包安装MySQL5.7

1、先卸载MySQL5.7，防止重装

1.yum方式查看安装，查看yum是否安装过mysql

    yum list installed mysql*

    如或显示了列表，说明系统中有MySQL

    yum卸载，根据列表上的名字

    yum remove mysql-community-client mysql-community-common mysql-community-libs 
        mysql-community-libs-compat mysql-community-server mysql57-community-release

    rm -rf /var/lib/mysql  
    rm /etc/my.cnf

2.rpm方式查看安装

    rpm -qa | grep -i mysql

    rpm 卸载

        1.
        rpm -e mysql57-community-release-el7-9.noarch
        rpm -e mysql-community-server-5.7.17-1.el7.x86_64
        rpm -e mysql-community-libs-5.7.17-1.el7.x86_64
        rpm -e mysql-community-libs-compat-5.7.17-1.el7.x86_64
        rpm -e mysql-community-common-5.7.17-1.el7.x86_64
        rpm -e mysql-community-client-5.7.17-1.el7.x86_64
        cd /var/lib/  
        rm -rf mysql/

        此时可能没有删除干净

        2.
        whereis mysql
        mysql: /usr/bin/mysql /usr/lib64/mysql /usr/local/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz
        # 删除上面的文件夹
        rm -rf /usr/bin/mysql


        3、删除配置
        rm –rf /usr/my.cnf
        rm -rf /root/.mysql_sercret

        4.剩余配置检查

        chkconfig --list | grep -i mysql
        chkconfig --del mysqld
        根据上面的列表，删除 ,如：mysqld

2.安装MySQL5.7

在此网站https://dev.mysql.com/downloads/repo/yum/ 
选择Red Hat Enterprise Linux 7 / Oracle Linux 7 (Architecture Independent), RPM Package 此项下载源码包

下载完之后上传到系统，

ls 查看 mysql57-community-release-el7-11.noarch.rpm上传成功

3.解压此RPM包

sudo rpm -ivh mysql57-community-release-el7-9.noarch.rpm

接下来使用yum安装

# 更新yum软件包
yum check-update  
# 更新系统 
yum update
 #安装mysql
yum install mysql mysql-server
接下来是漫长的等待。如果中途关机，或者下载挂了，请执行卸载步骤后，再来一次。

完成后

记住要给root上密码

/usr/local/mysql/bin/mysqld_safe --skip-grant-tables --user=mysql &
systemctl start mysqld
mysql -u root

mysql> update mysql.user set authentication_string=password('new_password') where user='root' and Host ='localhost';
mysql> flush privileges;
mysql> quit;


启动与开放远程访问
systemctl start mysqld
mysql -u root -p
+ 授权远程访问
use mysql;
grant all privileges  on *.* to root@'%' identified by "root";
FLUSH RIVILEGES;

建议root不要授权远程访问，请创建新mysql用户