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;