centos7-安装mysql-8.0.29_咲之

网络 02-07 522

linux下安装rpm包：

rpm -ivh xxx.rpm

1、安装mysql，依次执行命令：

# 卸载mysql-libs yum remove mysql-libs # 解压文件 tar -xvf mysql-8.0.29-1.el7.x86_64.rpm-bundle.tar # 安装mysql服务 rpm -ivh mysql-community-common-8.0.29-1.el7.x86_64.rpm rpm -ivh mysql-community-client-plugins-8.0.29-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-8.0.29-1.el7.x86_64.rpm rpm -ivh mysql-community-icu-data-files-8.0.29-1.el7.x86_64.rpm rpm -ivh mysql-community-client-8.0.29-1.el7.x86_64.rpm

2、安装完成后，授权访问mysql：

chmod -R 777 /var/lib/mysql # 重启mysql服务 service mysqld restart

3、获取mysql的临时密码：

grep 'temporary password' /var/log/mysqld.log # [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: dtweptukh2<Q

4、使用临时密码连接：

mysql -u root -p # Enter password:dtweptukh2<Q

5、设置新密码（允许设置简单密码）：

# 先设置复杂密码 ALTER USER 'root'@'localhost' IDENTIFIED BY 'Test@000_ccc'; # 再更改配置 set global validate_password.policy=0; set global validate_password.length=1; # 后设置为简单密码 ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; flush privileges; # 允许远程用户登录 use mysql; update user set Host='%' where User='root'; ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; flush privileges;

参考文档：

1）卸载自带mariadb；安装mysqlrpm报错mariadb已经被mysql-community-client-5.7.25-1.el7.x86_64所取代_貔貅526的博客-CSDN博客[root@localhost 5.7.25rpm]# rpm -ivh *.rpmwarning: mysql-community-client-5.7.25-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYerror: Failed dependencies:mariadb is obsoleted by mysql-community-client-5.7.25-1.el7.x86_64mariadb-https://blog.csdn.net/pixiu568/article/details/1102374592）rpm包安装顺序，连接密码设置；Linux系统安装Mysql完整顺序_lch1024的博客-CSDN博客_mysql安装linux顺序rpm1.安装前检查mysql是安装了其他包????# rpm -qa | grep mysql????# rpm -qa | grep Mysql????# rpm -qa | grep maridb????如果存在先卸载? ? # rpm -e --nodeps XXX2.官网下载mysql社区版????https://dev.mysql.com/downloads/mysql/ 选择对应系统版本的...https://blog.csdn.net/lin360225013/article/details/798198263）允许设置简单密码；解决MySQL8.0报错：Unknown system variable 'validate_password_policy' - 遠離塵世の方舟 - 博客园一、问题描述 1、在安装MySQL8.0时，修改临时密码，因密码过于简单（如：123456），不符合MySQL密码规范，会触发一个报错信息： ERROR 1819 (HY000): Your passhttps://·/rusking/p/10561432.html

4）允许远程连接数据库。

Operation ALTER USER failed for ‘root‘@‘%‘_丶Summer℡ 念~的博客-CSDN博客解决mysql Operation ALTER USER failed for ‘root’@’%' 1、连接服务器: `mysql -u root -p`2、看当前所有数据库：show databases;3、进入mysql数据库：use mysql;4、查看mysql数据库中所有的表：show tables;5、查看user表中的数据：select Host, User from user;6、修改user表中的Host: update user shttps://blog.csdn.net/qq_36501494/article/details/121571843?

1.本站遵循行业规范，任何转载的稿件都会明确标注作者和来源；2.本站的原创文章，会注明原创字样,如未注明都非原创，如有侵权请联系删除！；3.作者投稿可能会经我们编辑修改或补充；4.本站不提供任何储存功能只提供收集或者投稿人的网盘链接。