linux内 mysql 5版本的安装(有卸载)

mysql安装

安装包准备好 删除linux内带mysql

rpm -qa | grep -i -E mysql\|mariadb | xargs -n1 sudo rpm -e --nodeps

先看看有没有卸干净:

rpm -qa|grep -i mysql

显示之前安装了：

MySQL-client-5.5.25a-1.rhel5
MySQL-server-5.5.25a-1.rhel5

2、停止mysql服务、删除之前安装的mysql
删除命令：rpm -e –nodeps 包名

rpm -ev MySQL-client-5.5.25a-1.rhel5 
rpm -ev MySQL-server-5.5.25a-1.rhel5


如果提示依赖包错误，则使用以下命令尝试

rpm -ev MySQL-client-5.5.25a-1.rhel5 --nodeps

如果提示错误：error: %preun(xxxxxx) scriptlet failed, exit status 1

则用以下命令尝试：

rpm -e --noscripts MySQL-client-5.5.25a-1.rhel5

3、查找之前老版本mysql的目录、并且删除老版本mysql的文件和库

find / -name mysql

查找结果如下：

find / -name mysql  
/var/lib/mysql
/var/lib/mysql/mysql
/usr/lib64/mysql

删除对应的mysql目录

rm -rf /var/lib/mysql
rm -rf /var/lib/mysql
rm -rf /usr/lib64/mysql

注意：卸载后/etc/my.cnf不会删除，需要进行手工删除

rm -rf /etc/my.cnf

4、再次查找机器是否安装mysql

rpm -qa|grep -i mysql```

**2**）将安装包和JDBC驱动上传到/opt/module/mysql，共计**6 **个


01_mysql-community-common-5.7.16-1.el7.x86_64.rpm

02_mysql-community-libs-5.7.16-1.el7.x86_64.rpm

03_mysql-community-libs-compat-5.7.16-1.el7.x86_64.rpm

04_mysql-community-client-5.7.16-1.el7.x86_64.rpm

05_mysql-community-server-5.7.16-1.el7.x86_64.rpm

mysql-connector-java-5.1.27-bin.jar

安装 MySQL

(1)安装依赖

[itwise@node2 mysql]$

:sudo rpm -ivh 01_mysql-community-common-5.7.16-1.el7.x86_64.rpm
sudo rpm -ivh 02_mysql-community-libs-5.7.16-1.el7.x86_64.rpm

sudo rpm -ivh 03_mysql-community-libs-compat-5.7.16-1.el7.x86_64.rpm

2）安装mysql-client

sudo rpm -ivh 04_mysql-community-client-5.7.16-1.el7.x86_64.rpm

3）安装mysql-server

[itwise@node2 mysql]$ sudo yum install -y libaio
[itwise@node2 mysql]$ sudo rpm -ivh 05_mysql-community-server-5.7.16-1.el7.x86_64.rpm
5072e1f5:

4）启动mysql

sudo systemctl start mysqld

5）查看 mysql 密码

[itwise@node2 mysql]$ sudo cat /var/log/mysqld.log |grep password

2配置mysql

配置只要是 root 用户+密码，在任何主机上都能登录 MySQL 数据库。

1）用刚刚查到的密码进入mysql如果报错，给密码加单引号）

[itwise@node2 mysql]$ mysql -uroot -p 

3*）更改mysq*密码策略

mysql> set global validate_password_length=4;
mysql> set global validate_password_policy=0;

4）设置简单好记的密码

mysql> set password=password("123456");

5**）进入** msyql 库

mysql> use mysql

6）查询user 表

mysql> select user, host from user;

7）修改user 表，把 Host 表内容修改为**%**

mysql> update user set host="%" where user="root";

8）刷新

mysql> flush privileges;

9）退出

mysql> quit;

10)重启数据库

[itwise@node2 mysql]$ sudo systemctl restart mysqld;

外部连接.安装好后

\