mysql安包安装

mysql-8.22安装包安装简介：
安装环境：centos7.0服务器

mysql下载官网：https://dev.mysql.com/downloads/mysql/
mysql版本安装包下载列表地址： https://downloads.mysql.com/archives/community/

上传安装包： mysql-8.0.22-1.el7.x86_64.rpm-bundle.tar
tar -xvf mysql-8.0.22-1.el7.x86_64.rpm-bundle.tar
mysql-8.22顺序安装：
rpm -ivh mysql-community-common-8.0.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.22-1.el7.x86_64.rpm --force --nodeps

新版本顺序安装：
mysql 8.25
上传：mysql-8.0.25-1.el7.x86_64.rpm-bundle.tar 解压 依次运行：
rpm -ivh mysql-community-common-8.0.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.25-1.el7.x86_64.rpm --force --nodeps

修改 etc/my.cnf 注释或添加skip-grant-tables：跳过登录验证
打开vim /etc/my.cnf
#跳过登录验证
skip-grant-tables
#设置默认字符集UTF-8
character_set_server=utf8
#设置默认字符集UTF-8
init_connect=‘SET NAMES utf8’
#解决大小写敏感问题1=不敏感 默认0
lower_case_table_names = 1

设置开机启动：systemctl start mysqld.service

mysql -u root -p
mysql报错
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)

flush privileges;
mysql -u root -p或者mysql
进入 mysql 界面
mysql：8.0以上
命令查看 validate_password 密码验证插件是否安装。
mysql> SHOW VARIABLES LIKE ‘validate_password%’;
1）、validate_password_length 固定密码的总长度；
2）、validate_password_dictionary_file 指定密码验证的文件路径；
3）、validate_password_mixed_case_count 整个密码中至少要包含大/小写字母的总个数；
4）、validate_password_number_count 整个密码中至少要包含阿拉伯数字的个数；
5）、validate_password_policy 指定密码的强度验证等级，默认为 MEDIUM；

ALTER user ‘root’@‘localhost’ IDENTIFIED BY ‘rootpassword’;
查看报错ERROR 1193 (HY000): Unknown system variable ‘validate_password_policy’
set global validate_password.policy=0;
set global validate_password.length=1;

alter user root identified with mysql_native_password by ‘rootpassword’;
刷新缓存：flush privileges; 退出mysql>exit；

开放3306端口;
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload

/var/log/mysqld.log 看密码A temporary password is generated for root@localhost: WefwqWfjU2&) 未尝试：

7.0以上use database_name;告诉mysql你要使用那个数据库；：use mysql
update user set host=’%’ where user=‘root’;
alter user root identified with mysql_native_password by ‘rootpassword’;

卸载mysql

查看是否安装过mysql
rpm -qa|grep -i mysql
如果有安装，则删除mysql
yum -y remove mysql-*
删除所有带mysql的文件夹
find / -name mysql

/etc/selinux/targeted/active/modules/100/mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/lib64/mysql
/usr/share/mysql
删除：
rm -rf /etc/selinux/targeted/active/modules/100/mysql
rm -rf /var/lib/mysql/
rm -rf /usr/lib64/mysql/
rm -rf /usr/share/mysql

删除配置文件
rm -rf /etc/my.cnf

删除mysql默认密码
rm -rf /root/.mysql_sercret