基于Linux安装与卸载mysql的步骤

基于Linux安装mysql的步骤

1. 通过secureCRT工具连接Linux系统
2. 上传 mysql 的安装包
    在secureCRT中按alt + p -------> put d:/setup/mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar
3. 解压 mysql 的安装包
	mkdir mysql  
	tar -xvf mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar -C mysql/
4. 安装客户端
    cd mysql/    
	rpm -ivh mysql-community-client-5.7.27-1.el7.x86_64.rpm --force --nodeps
5. 安装服务端  
	rpm -ivh mysql-community-server-5.7.27-1.el7.x86_64.rpm --force --nodeps
6. 修改mysql默认字符集    
	vi /etc/my.cnf    
	添加如下内容：   
	[mysqld]
	character-set-server=utf8
	collation-server=utf8_general_ci
	-- 在文件最下方添加   
	[client]
	default-character-set=utf8
7. 安装依赖和工具包
 	[root@localhost mysql]$ rpm -ivh mysql-community-common-5.7.27-1.el7.x86_64.rpm --force --nodeps
	[root@localhost mysql]$ rpm -ivh mysql-community-libs-5.7.27-1.el7.x86_64.rpm  --force --nodeps
8. 启动mysql服务    
	service mysqld start
9. 登录mysql    
	mysql -u root -p  敲回车，输入密码   
	初始密码查看：cat /var/log/mysqld.log    
	在root@localhost: 后面的就是初始密码
10. 修改mysql登录密码   
	set global validate_password_policy=0;    
	set global validate_password_length=1;    
	set password=password('密码');
11. 授予远程连接权限
	//授权
	grant all privileges on *.* to 'root' @'%' identified by '密码';    
	//刷新
	flush privileges;
12. 关闭Linux系统防火墙
    退出mysql：exit
	systemctl stop firewalld
13. 重启mysql服务
	service mysqld restart
14. 使用SQLYog工具连接mysql

基于Linux 卸载mysql的步骤

1.关闭mysql服务
[root@localhost mysql]$ service mysqld stop
2.查询MySQL软件包
[root@localhost mysql]$ rpm -aq | grep -i  mysql
mysql-community-client-5.7.27-1.el7.x86_64
mysql-community-server-5.7.27-1.el7.x86_64
3.依次卸载系统下的所有mysql软件包
[root@localhost mysql]$ rpm -ev  mysql-community-server-5.7.27-1.el7.x86_64
[root@localhost mysql]$ rpm -ev  mysql-community-client-5.7.27-1.el7.x86_64
4.再次查询剩下有哪些mysql文件夹
[root@localhost mysql]$ find / -name "mysql"
/etc/logrotate.d/mysql
/etc/selinux/targeted/active/modules/100/mysql
/etc/selinux/targeted/tmp/modules/100/mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/bin/mysql
/usr/lib64/mysql
/usr/share/mysql
/itcast/install/mysql
5.删除这些文件夹
[root@localhost mysql]$ rm -rf /itcast/install/mysql   /usr/share/mysql ...
6.删除mysql核心配置文件
[root@localhost mysql]$ rm -rf /etc/my.cnf
7.至此MySQL删除完成