腾讯云（centOS7.6）安装Mysql8.0.18（rpm-bundle.tar格式）

剑客营 > 电脑知识 > 腾讯云（centOS7.6）安装Mysql8.0.18（rpm-bundle.tar格式）
标签  数据库 云服务
2019年11月1日 12:40 by 萝卜特

安装流程

  1. 服务器直接下载MySQL安装包

  2. 解压安装包：tar -xvf mysql-8.0.18-1.el7.x86_64.rpm-bundle.tar

  3. 依次安装rpm文件，注意安装顺序 common -> libs -> client -> server

    rpm -ivh mysql-community-common-8.0.18-1.el7.x86_64.rpm

    rpm -ivh mysql-community-libs-8.0.18-1.el7.x86_64.rpm

    rpm -ivh mysql-community-client-8.0.18-1.el7.x86_64.rpm

    rpm -ivh mysql-community-server-8.0.18-1.el7.x86_64.rpm

    rpm -ivh mysql-community-libs-compat-8.0.18-1.el7.x86_64.rpm（可选）

    rpm -ivh mysql-community-devel-8.0.18-1.el7.x86_64.rpm（可选）

    rpm -ivh mysql-community-embedded-compat-8.0.18-1.el7.x86_64.rpm（可选）

    rpm -ivh mysql-community-test-8.0.18-1.el7.x86_64.rpm（可选）

可选的我没有安装（这里可能会遗留问题，之后我在安装python的mysql驱动时pip install mysqlclient总是报错，重新安装rpm -ivh mysql-community-devel-8.0.18-1.el7.x86_64.rpm后问题解决）

安装mysql-community-libs-8.0.18-1.el7.x86_64.rpm时，出现：

error: Failed dependencies:
        mariadb-libs is obsoleted by mysql-community-libs-8.0.18-1.el7.x86_64

卸载原有的文件：yum remove mariadb-libs

问题解决

安装mysql-community-server-8.0.18-1.el7.x86_64.rpm时，出现：

error: Failed dependencies:
        libnuma.so.1()(64bit) is needed by mysql-community-server-8.0.18-1.el7.x86_64
        libnuma.so.1(libnuma_1.1)(64bit) is needed by mysql-community-server-8.0.18-1.el7.x86_64
        libnuma.so.1(libnuma_1.2)(64bit) is needed by mysql-community-server-8.0.18-1.el7.x86_64

安装一个依赖包：yum install numactl

问题解决

基本操作命令

  • Mysql启动服务：systemctl start mysqld.service

  • 查看MySQL运行状态：systemctl status mysqld.service

  • 查看初始密码：cat /var/log/mysqld.log或者grep "password" /var/log/mysqld.log

  • 登陆MySQL：mysql -uroot –p

修改初始密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

Mysql无法远程连接

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

（此处’password’应与原来密码不同）

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

FLUSH PRIVILEGES; # 刷新权限

报错的话ERROR 1396 (HY000)

把'localhost'改成’%’

发表评论
您还没有登录，请登录后发表评论。
用户登录
0 评论