mysql【5.6】离线安装

-- 检查是否存在mysql库
rpm -qa | grep mysql
-- 卸载mysql库    
rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64
解压
tar -xvf xx -C ?path
安装  

rpm -e --nodeps mariadb-libs-1:5.5.60-1.el7_5.x86_64
rpm -ivh *.rpm
问题1: /usr/bin/perl is needed by MySQL-client-5.6.25-1.el6.x86_64
    -- yum install -y perl-Module-Install.noarch
问题2：net-tools is needed by MySQL-server-5.6.25-1.el6.x86_64
     -- yum install net-tools -y 
        -- yum install libaio

启动mysql：service mysql start
systemctl start mysqld.service
查看初始密码：cat /root/.mysql_secret
连接mysql:mysql -uroot -pXXXX
修改密码:SET PASSWORD = PASSWORD('root');
设置开机自启:chkconfig mysql on

远程登录:
格式:
    GRANT 【权限内容】 ON 【库名】.【表名】 TO 【用户名】@'【IP地址】' 
    IDENTIFIED BY '【密码】' WITH GRANT OPTION;
grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option; 

flush privileges；