安装MySQL数据库8.0

1、安装环境检查

Ip地址：ifconfig

2、系统检查

[root@localhost soft]# cat /etc/redhat-release CentOS Linux release 7.5.1804 (Core) [root@BI-JK-Oracle ~]# mkdir soft_mysql [root@BI-JK-Oracle ~]# df -h     --用根目录即可

3、包的上传及解压

选择mysql-8.0.27-1.el7.x86_64.rpm-bundle.tar [root@localhost soft]# tar -xvf mysql-8.0.27-1.el7.x86_64.rpm-bundle.tar mysql-community-client-8.0.27-1.el7.x86_64.rpm mysql-community-client-plugins-8.0.27-1.el7.x86_64.rpm mysql-community-common-8.0.27-1.el7.x86_64.rpm mysql-community-devel-8.0.27-1.el7.x86_64.rpm mysql-community-embedded-compat-8.0.27-1.el7.x86_64.rpm mysql-community-libs-8.0.27-1.el7.x86_64.rpm mysql-community-libs-compat-8.0.27-1.el7.x86_64.rpm mysql-community-server-8.0.27-1.el7.x86_64.rpm mysql-community-test-8.0.27-1.el7.x86_64.rpm

4、按照顺序安装（com-libs-client-server）

（1）输入以下命令开始安装common rpm -ivh mysql-community-common-8.0.27-1.el7.x86_64.rpm --nodeps --force （2）安装libs rpm -ivh mysql-community-libs-8.0.27-1.el7.x86_64.rpm --nodeps --force （3）安装client rpm -ivh mysql-community-client-8.0.27-1.el7.x86_64.rpm --nodeps --force （4）安装server rpm -ivh mysql-community-server-8.0.27-1.el7.x86_64.rpm --nodeps --force

5、检查操作mysql安装包

rpm -qa | grep mysql

6、启动mysql服务

（1）启动命令

service mysqld start

（2）查看mysql服务启动状态是否成功

service mysqld status   或是ps -ef | grep mysql

（3）相关命令

systemctl start mysqld.service   # 启动mysql systemctl status mysqld.service  #查看mysql状态 systemctl stop mysqld.service   #关闭mysql 查看3306端口 netstat -anop|grep 3306

7、修改密码

注意：由于MySQL5.7.4之前的版本中默认是没有密码的，其后版本会在安装日志中生成一个临时密码。

  怎么找到这个临时密码呢？

grep 'temporary password' /var/log/mysqld.log

查询到登录密码为【XXXXXXX】

[root@nfs_client tools]# mysql -uroot -p

执行下面的命令修改MySql root密码
在5.6后,mysql内置密码增强机制,低强度密码会报错:

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

mysql> alter user root@localhost identified by '123456';

查询策略信息

show variables like 'validate%';

还是如上错误

vim /etc/my.cnf  加在[mysql]后面即可 skip-grant-tables

重启 service mysqld restart

===>解决低密码报错问题

Step1：将上面的修改加在文件

vim /etc/my.cnf validate_password.policy=LOW validate_password.length=6 validate_password.number_count=1 validate_password.special_char_count=1 validate_password.mixed_case_count=1 -----需要将skip-grant-tables去掉

Step2：重启服务并修改密码

service mysqld restart mysql> set password='123456'

8、创建用户

create user 'XXXX'@'%' identified with mysql_native_password by '123456'; flush privileges mysql -u XXXX -p

9、客户端连接数据库

1. 对自己创建的用户连接

GRANT ALL PRIVILEGES ON mysql.* TO 'XXXX'@'%'; FLUSH PRIVILEGES;

10、创建测试数据库

---------建库 create database XXXXX; GRANT ALL PRIVILEGES ON XXXXX.* TO 'XXXX'@'%'; FLUSH PRIVILEGES; ---------建表测试 create table dept ( deptno int auto_increment primary key, dname varchar(15), loc varchar(50) ) engine = innodb; insert into dept values (1,'it','bj'); insert into dept values (2,'cw','sh'); insert into dept values (3,'hr','sz'); commit;