Centos7.x安装mysql5.6

梦里梦外; 2022-10-31 00:48 3阅读 0赞

## 安装源 ##

从中科大的[镜像网站][Link 1]上获取，[官网][Link 2]下载太慢

选择安装包: MySQL-5.6.50-1.el7.x86\_64.rpm-bundle.tar

## 安装 ##

上传介质至服务器并解压

[root@instance-g0wuu7jx aa]# tar xvf MySQL-5.6.50-1.el7.x86_64.rpm-bundle.tar 
    MySQL-client-5.6.50-1.el7.x86_64.rpm
    MySQL-devel-5.6.50-1.el7.x86_64.rpm
    MySQL-embedded-5.6.50-1.el7.x86_64.rpm
    MySQL-server-5.6.50-1.el7.x86_64.rpm
    MySQL-shared-5.6.50-1.el7.x86_64.rpm
    MySQL-shared-compat-5.6.50-1.el7.x86_64.rpm
    MySQL-test-5.6.50-1.el7.x86_64.rpm

按照顺序安装rpm包(其它可以忽略)

rpm -ivh MySQL-client-5.6.50-1.el7.x86_64.rpm
    rpm -ivh MySQL-devel-5.6.50-1.el7.x86_64.rpm
    rpm -ivh MySQL-server-5.6.50-1.el7.x86_64.rpm

日志文件会提示会生成一个随机密码文件在/root/.mysql\_secret中

A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !
    You will find that password in '/root/.mysql_secret'.

## 启动mysql ##

systemctl start  mysql

## 设置开机自启 ##

[root@instance-g0wuu7jx mysql5.6.50]# systemctl enable mysql
    mysql.service is not a native service, redirecting to /sbin/chkconfig.
    Executing /sbin/chkconfig mysql on
    [root@instance-g0wuu7jx mysql5.6.50]# /sbin/chkconfig mysql on

## 开启远程登录 ##

cat /root/.mysql_secret
    # (local time): qkVnNb7LzIinrYVp
    #查看默认mysql密码
    
    mysql -uroot -p'qkVnNb7LzIinrYVp'
    #登录mysql
    
    mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
    #修改为简单密码
    
    mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;
    #开启远程登录
    
    mysql> flush privileges;

## 开放3306端口 ##

# 查看防火墙是否启动
    systemctl status firewalld
    
    # 未启动则启动
    systemctl start firewalld
    
    # 开发mysql 3306端口
    firewall-cmd --permanent --zone=public --add-port=3306/tcp
    
    # 重启防火墙
    firewall-cmd --reload
    
    # 查看端口状态是否暴露，yes表示正常暴露
    firewall-cmd --query-port=3306/tcp

使用数据库连接工具验证

[Link 1]: https://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.6/
[Link 2]: https://dev.mysql.com/downloads/mysql/