演示Centos7安装mysql 5.x
一、安装
1.1 卸载自带的mariadb
rpm -qa|grep mariadb
rpm -e --nodeps mariadb-libs-5.*
-e :卸载
--nodeps : 只卸载当前的,没有依赖
1.2 安装mysql
mkdir /export/software/mysql
tar -zxvf 安装包 -C 解压路径
# common libs client server
rpm -ivh common.rpm libs.rpm client.rpm server.rpm # 不要复制
1.3 基本配置
# 初始化
mysqld --initialize
# 更改所属组,mysql数据的存放位置
chown mysql:mysql /var/lib/mysql -R
#启动mysql
systemctl start mysqld.service
1.4 修改mysql的配置信息
# 查看临时密码
cat /var/log/mysqld.log |grep temp
# 修改密码mysql -uroot -p 临时密码
alter user user() identified by "root1234";
# 授权
mysql> use mysql;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root1234' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
# 远程登录的,比如我在datagrip上想通过3306端口连接mysql;注意ssh的端口是22,两者之间有区分
1.5 【可选】
#mysql的启动和关闭 状态查看
systemctl stop mysqld
systemctl status mysqld
systemctl start mysqld#建议设置为开机自启动服务
[root@node2 ~]# systemctl enable mysqld#查看是否已经设置自启动成功
[root@node2 ~]# systemctl list-unit-files | grep mysqld
mysqld.service enabled
二、卸载
2.1关闭mysql服务
systemctl stop mysqld
2.2 卸载安装包
2.2.1 查找安装mysql的rpm包
[root@node3 ~]# rpm -qa | grep -i mysql
mysql-community-libs-5.7.29-1.el7.x86_64
mysql-community-common-5.7.29-1.el7.x86_64
mysql-community-client-5.7.29-1.el7.x86_64
mysql-community-server-5.7.29-1.el7.x86_64
2.2.2 执行卸载
[root@node3 ~]# yum remove 查询到的包
2.2.3 查看是否卸载干净
rpm -qa | grep -i mysql
2.3 删除相关信息【配置,数据】
2.3.1 查找mysql相关目录 并删除
[root@node1 ~]# find / -name mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/share/mysql
[root@node1 ~]# rm -rf /var/lib/mysql
[root@node1 ~]# rm -rf /var/lib/mysql/mysql
[root@node1 ~]# rm -rf /usr/share/mysql
2.3.2 删除默认配置 日志
rm -rf /etc/my.cnf
rm -rf /var/log/mysqld.log
附件
修改初始密码
mysql> alter user user() identified by "root1234";
Query OK, 0 rows affected (0.00 sec)user() : 表示当前登录用户
也可以使用alter user 'root'@'localhost' identified by "root1234";
'root'@'localhost' :本地用户
初始化了密码之后,想修改密码
mysql> set password for 'root'@'localhost' = passowrd("newpassword")