centos7 中安装 mysql 8.x以及对数据库的管理（数据库、表的增删改查、插入删除数据）

Day 16

centos7 中安装 mysql 8.x

1.下载安装包

[root@mysql~]#wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar

2.解压

tar -xf mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar

[root@mysql ~]# ls

anaconda-ks.cfg

mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar

mysql-community-client-8.0.33-1.el7.x86_64.rpm

mysql-community-client-plugins-8.0.33-1.el7.x86_64.rpm

mysql-community-common-8.0.33-1.el7.x86_64.rpm

mysql-community-debuginfo-8.0.33-1.el7.x86_64.rpm

mysql-community-devel-8.0.33-1.el7.x86_64.rpm

mysql-community-embedded-compat-8.0.33-1.el7.x86_64.rpm

mysql-community-icu-data-files-8.0.33-1.el7.x86_64.rpm

mysql-community-libs-8.0.33-1.el7.x86_64.rpm

mysql-community-libs-compat-8.0.33-1.el7.x86_64.rpm

mysql-community-server-8.0.33-1.el7.x86_64.rpm

mysql-community-server-debug-8.0.33-1.el7.x86_64.rpm

mysql-community-test-8.0.33-1.el7.x86_64.rpm

soft

[root@mysql ~]#rpm -ivh mysql-community-server-8.0.33-1.el7.x86_64.rpm

3.卸载mariodb

[root@mysql ~]#yum remove -y *mariadb

4.依次安装libs，client，common，server4个包

[root@mysql ~]#yum -y install mysql-community-common-8.0.33-1.el7.x86_64.rpm

[root@mysql ~]#yum install mysql-community-client-8.0.33-1.el7.x86_64.rpm

[root@mysql ~]#yum install mysql-community-libs-8.0.33-1.el7.x86_64.rpm

[root@mysql ~]#yum install -y mysql-community-server-8.0.33-1.el7.x86_64.rpm

5.初始化配置mysql

[root@mysql ~]#mysqld -initialize

6.启动mysql服务

systemctl start mysqld.service

7.开机启动mysql服务

[root@mysql ~]#systemctl enable mysqld.service

8.获得初始化密码，复制时前后都不能复制空格

[root@mysql ~]#cat /var/log/mysqld.log|grep password

9.登录管理，将复制的密码粘贴到输入密码的区域实现登录

[root@mysql ~]#mysql -uroot -p

[root@mysql ~]#fg   # 退出指令

10.设置新的密码

11.退出登录

数据库的管理

1.数据库的对象

1)数据库系统 DBMS

2)数据库 DB

3)表 table

4)记录 record

5)字段 feild

数据库操作

1)删除库

2)创建库

3)查看库

数据表的操作

1）选择库

2)查看表

3)创建表

4)删除表

5)修改表(新增列、修改列名、删除列)

记录的操作

1)新增

2)删除

3)修改