myql8.0.32安装配置过程详解
记录下安装mysql8的过程,如果错漏 ,欢迎指正。
安装环境:
Centos7.
下载安装包
安装所需要的包上传到了csdn,下载地址:https://download.csdn.net/download/LwPrince/87816937?spm=1001.2014.3001.5503
安装过程
1. 执行:rpm -ivh mysql-community-common-8.0.32-1.el7.x86_64.rpm
2. 执行:rpm -ivh mysql-community-libs-8.0.32-1.el7.x86_64.rpm
报错了:
警告:mysql-community-libs-8.0.32-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID 3a79bd29: NOKEY
错误:依赖检测失败:
mysql-community-client-plugins = 8.0.32-1.el7 被 mysql-community-libs-8.0.32-1.el7.x86_64 需要
mariadb-libs 被 mysql-community-libs-8.0.32-1.el7.x86_64 取代
执行:rpm -e --nodeps mariadb-libs
重新执行:rpm -ivh mysql-community-libs-8.0.32-1.el7.x86_64.rpm
又报错了:
警告:mysql-community-libs-8.0.32-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID 3a79bd29: NOKEY
错误:依赖检测失败:
mysql-community-client-plugins = 8.0.32-1.el7 被 mysql-community-libs-8.0.32-1.el7.x86_64 需要
那安装client-plugins,执行:rpm -ivh mysql-community-client-plugins-8.0.32-1.el7.x86_64.rpm
再执行: rpm -ivh mysql-community-libs-8.0.32-1.el7.x86_64.rpm,这次成了。
3. 执行:rpm -ivh mysql-community-client-8.0.32-1.el7.x86_64.rpm
4. 执行:rpm -ivh mysql-community-icu-data-files-8.0.32-1.el7.x86_64.rpm
5. 执行:rpm -ivh mysql-community-server-8.0.32-1.el7.x86_64.rpm
验证安装:
执行:mysqladmin --version
返回结果:mysqladmin Ver 8.0.32 for Linux on x86_64 (MySQL Community Server - GPL),表示安装成功
使用MYSQL
登录
执行:cat /var/log/mysqld.log | grep password 获取到安装过程生成的root用户的密码。
mysql -u root -p
输入密码,登录成功
修改密码
ALTER USER root@localhost IDENTIFIED BY '1qaz@WSX';
设置远程连接
先用root用户登录mysql
执行:use mysql 切换到mysql库
执行:update user set host='%' where user = 'root';
执行:FLUSH PRIVILEGES;
执行:grant all on *.* to root@'%' identified by '数据库密码';
再远程连接应该就可以了;