mysql数据库卸载和安装

mysql数据库卸载和安装

一 mysql数据库卸载

1.查看yum是否安装过mysql

yum list installed mysql*

如或显示了列表，说明系统中有MySQL

2.yum卸载

根据列表上的名字

yum remove mysql-community-client mysql-community-common mysql-community-libs mysql-community-libs-compat mysql-community-server mysql57-community-release
rm -rf /var/lib/mysql  
rm /etc/my.cnf

3.rpm查看安装

rpm -qa | grep -i mysql

4.rpm 卸载

rpm -e mysql57-community-release-el7-9.noarch
rpm -e mysql-community-server-5.7.17-1.el7.x86_64
rpm -e mysql-community-libs-5.7.17-1.el7.x86_64
rpm -e mysql-community-libs-compat-5.7.17-1.el7.x86_64
rpm -e mysql-community-common-5.7.17-1.el7.x86_64
rpm -e mysql-community-client-5.7.17-1.el7.x86_64
cd /var/lib/  
rm -rf mysql/

5.清除余项

whereis mysql

提示如下新消息

mysql: /usr/bin/mysql /usr/lib64/mysql /usr/local/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz

#删除上面的文件夹

rm -rf /usr/bin/mysql

6.删除配置

rm –rf /usr/my.cnf
rm -rf /root/.mysql_sercret

7.剩余配置检查

chkconfig --list | grep -i mysql
chkconfig --del mysqld

根据上面的列表，删除 ,如：mysqld

二 mysql数据库安装

1.yum源

wget http://repo.mysql.com/mysql57-community-release-el7-9.noarch.rpm
sudo rpm -ivh mysql57-community-release-el7-9.noarch.rpm

2.更新yum软件包

yum check-update  

3.更新软件

yum update

yum update 更新报错解决
当在CentOS 7中使用yum update更新软件时，可能会遇到如下错误信息：

Error: Delta RPMs disabled because /usr/bin/applydeltarpm not installed.

解决这个问题需要安装deltarpm，可以先通过如下命令查找该包的包名：

yum provides '*/applydeltarpm'

然后用如下命令安装即可解决：

yum install deltarpm

4.安装mysql

yum install mysql mysql-server

5 给root上密码123456

mysqladmin -uroot password '123456'

6 获取MySQL的临时密码

只有启动过一次mysql才可以查看临时密码

grep 'temporary password' /var/log/mysqld.log

[root@localhost etc]# grep 'temporary password' /var/log/mysqld.log
2019-01-10T01:58:42.323205Z 1 [Note] A temporary password is generated for root@localhost: de-cr(6g/_E=

所以临时密码为：de-cr(6g/_E=
使用临时密码登陆成功后，立刻修改密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

7 修改两个全局参数：

7.1 修改validate_password_policy参数的值

mysql> set global validate_password_policy=0;

7.2 修改密码的长度

mysql> set global validate_password_length=1;

7.3 再次修改密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

8 mysql5.7密码忘记解决方法

8.1 启动与开放远程访问

systemctl start mysqld
mysql -u root -p

8.2 授权远程访问

use mysql;
grant all privileges  on *.* to root@'%' identified by "123456";
FLUSH PRIVILEGES;

update mysql.user set authentication_string = password('password'), plugin = 'mysql_native_password' where user = 'zabbix';

update mysql.user set password='password' where user='zabbix';

建议root不要授权远程访问，请创建新mysql用户
Centos 更改MySQL5.7数据库目录位置
修改完运行不报错，但是客户端连入时报错，还需要将my.cnf中的client 里的socket设置成和mysqld里的一样

9.数据初始化命令

/usr/bin/mysql_secure_installation

yynyy

grant all privileges  on *.* to root@'%' identified by "123456";
FLUSH PRIVILEGES;