Mysql安装配置

• Centos安装Mysql

Centos安装Mysql

1.查看是否安装mysql
rpm -qa|grep -i mysql

2.卸载mysql
rpm –ev 包名

3.查看mysql相关
find / -name mysql

4.删除
rm –rf 目录名

5.查询是否安装mariadb
rpm -qa | grep mariadb

6.卸载mysql
rpm -e --nodeps 包名

7.官方下载安装包
mysql-community-common-8.0.25-1.el7.x86_64.rpm
mysql-community-libs-8.0.25-1.el7.x86_64.rpm
mysql-community-client-8.0.25-1.el7.x86_64.rpm
mysql-community-server-8.0.25-1.el7.x86_64.rpm

8.按照顺序安装
rpm -ivh mysql-community-common-8.0.25-1.el7.x86_64.rpm --force --nodeps
rpm -ivh mysql-community-libs-8.0.25-1.el7.x86_64.rpm --force --nodeps
rpm -ivh mysql-community-client-8.0.25-1.el7.x86_64.rpm --force --nodeps
rpm -ivh mysql-community-server-8.0.25-1.el7.x86_64.rpm --force --nodeps

9.启动mysql
service mysqld start

10.查看mysql状态
service mysqld status

11.查看mysql的临时密码
grep "A temporary password" /var/log/mysqld.log

12.登录mysql
mysql -uroot -p

13.重新设置密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Root_demo01';

14.设置密码策略
set global validate_password.length=4;
set global validate_password.policy=0;

15.刷新
flush privileges;

15.查看密码策略
SHOW VARIABLES LIKE 'validate_password%';

17.重新设置密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

18.切换数据库
use mysql;

19.所有的地址都可以使用root用户来登陆
update user set host = '%' where user ='root';

20.刷新
flush privileges;

21.退出数据库
exit;