510企业网站系统源码,建站公司专业地址,wordpress主题know,计算机网络营销策划方案文章目录一、软件安装1. 下载2. 解压3.安装4. 跳过权限5. 启动mysql服务端6. 设置密码7. 允许远程连接8.开发3306端口二、安装报错方案一、软件安装
1. 下载
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.33-1.el7.x86_64.rpm-bundle.tarhttps://dev.…
文章目录一、软件安装1. 下载2. 解压3.安装4. 跳过权限5. 启动mysql服务端6. 设置密码7. 允许远程连接8.开发3306端口二、安装报错方案一、软件安装
1. 下载
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.33-1.el7.x86_64.rpm-bundle.tarhttps://dev.mysql.com/downloads/mysql/
2. 解压
tar -xvf mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar解压后的列表 mysql-5.7.33-1.el7.x86_64.rpm-bundle.tarmysql-community-client-5.7.33-1.el7.x86_64.rpmmysql-community-common-5.7.33-1.el7.x86_64.rpmmysql-community-devel-5.7.33-1.el7.x86_64.rpmmysql-community-embedded-5.7.33-1.el7.x86_64.rpmmysql-community-embedded-compat-5.7.33-1.el7.x86_64.rpmmysql-community-embedded-devel-5.7.33-1.el7.x86_64.rpmmysql-community-libs-5.7.33-1.el7.x86_64.rpmmysql-community-libs-compat-5.7.33-1.el7.x86_64.rpmmysql-community-server-5.7.33-1.el7.x86_64.rpmmysql-community-test-5.7.33-1.el7.x86_64.rpm3.安装
安装优先级
rpm -ivh mysql-community-common-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.33-1.el7.x86_64.rpm4. 跳过权限
# 配置mysql
vim /etc/my.cnf# 在[mysqld]标签下面添加跳过校验
skip-grant-tables5. 启动mysql服务端
# 启动mysql服务端
systemctl start mysqld.service# 使用客户端连接server端
mysql按回车6. 设置密码
# 设置密码
update mysql.user set authentication_stringpassword(123456) where userroot;# 刷新权限
flush privileges;7. 允许远程连接
# 允许远程连接
GRANT ALL PRIVILEGES ON *.* TO root% IDENTIFIED BY 123456 WITH GRANT OPTION; 8.开发3306端口
# 开放端口开放后需要要重启防火墙才生效
firewall-cmd --zonepublic --add-port8080/tcp --permanent
# 重新启动防火墙
firewall-cmd --reload二、安装报错方案
没遇到则可以跳过
安装报错
[rootbogon app]# rpm -ivh mysql-community-libs-5.7.33-1.el7.x86_64.rpm
警告mysql-community-libs-5.7.33-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
错误依赖检测失败mysql-community-common(x86-64) 5.7.9 被 mysql-community-libs-5.7.33-1.el7.x86_64 需要mariadb-libs 被 mysql-community-libs-5.7.33-1.el7.x86_64 取代
[rootbogon app]# ----------------------------------------------------------------
原因是 centos7 默认安装mariadb-libs包需要卸载# 查看mariadb
[rootbogon app]# rpm -qa |grep mariadb
mariadb-libs-5.5.68-1.el7.x86_64# 卸载mariadb
rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64# 跳过签名校验安装mysql(如果遇到签名错误执行这条命令)
rpm -ivh --force --nodeps mysql-community-libs-5.7.33-1.el7.x86_64.rpm
