yum卸载mysql_yum 安装卸载mysql

以前做过yum安装卸载mysql的笔记，现在整理到网上，希望对需要的朋友有所帮助

1.下载YUM库

wget http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

或wget --no-check-certificate http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

2.安装YUM库

yum localinstall -y mysql57-community-release-el7-10.noarch.rpm

3.安装数据库

yum install -y mysql-community-server

4.启动MySQL服务

systemctl start mysqld.service

5.查找mysql安装时的临时密码

grep 'password' /var/log/mysqld.log |head -n 1

mysql -uroot -p回车

输入密码

6.修改密码，解决密码安全问题：

如何解决ERROR 1819 (HY000): Your password does not satisfy the current policy requirements错误？

解决：必须修改两个全局参数

set global validate_password_policy=0;

再修改密码的长度：set global validate_password_length=1;

修改密码：SET PASSWORD = PASSWORD('root');

7.添加远程登录用户

use mysql;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

设置防火墙：

1)centos6

vi /etc/sysconfig/iptables

在-A RH-Firewall-1-INPUT -j REJECT –reject-with icmp-host-prohibited之前，添加

-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

重启防火墙

service iptables restart

2)centos7

启动：# systemctl start  firewalld

查看状态：# systemctl status firewalld 或者 firewall-cmd --state

停止：# systemctl stop firewalld

禁用：# systemctl disable firewalld

8.设置字符编码和区分大小写

SHOW VARIABLES LIKE '%char%';

修改mysql配置文件:vi /etc/my.cnf

[mysqld]

character-set-server=utf8

collation-server=utf8_general_ci

#区分大小写——-0:区分;1:不区分

lower_case_table_names=1

[client]

default-character-set=utf8

9.设置开机自启：

设置开机自动启动

# chkconfig mysqld on  或者  systemctl enable mysqld

# chkconfig --list | grep mysql

升级mysql-server

yum update mysql-server

mysql安装出现的错误：

-bash: mysql: command not found

解决：

# cd /usr/local/bin

# ln -fs /mysql安装路径/bin/mysql mysql

1、yum remove mysql mysql-server mysql-libs compat-mysql51

2、rm -rf /var/lib/mysql

3、rm /etc/my.cnf

查看是否还有mysql软件：

rpm -qa|grep mysql

如果存在的话，继续删除即可。

a)查看系统中是否以rpm包安装的mysql：

[root@localhost opt]# rpm -qa | grep -i mysql

MySQL-server-5.6.17-1.el6.i686

MySQL-client-5.6.17-1.el6.i686

b)卸载mysql

[root@localhost local]# rpm -e MySQL-server-5.6.17-1.el6.i686

[root@localhost local]# rpm -e MySQL-client-5.6.17-1.el6.i686

c)删除mysql服务

[root@localhost local]# chkconfig --list | grep -i mysql

[root@localhost local]# chkconfig --del mysql

d)删除分散mysql文件夹

[root@localhost local]# whereis mysql 或者 find / -name mysql

mysql: /usr/lib/mysql /usr/share/mysql

清空相关mysql的所有目录以及文件

rm -rf /usr/lib/mysql

rm -rf /usr/share/mysql

rm -rf /usr/my.cnf