centos7 中安装 mysql 8.x
下载安装包
[root@D ~]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar
解压
tar -xf mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar
删除mariadb
yum -y remov mariadb-libs.x86_64
下载net-tool
yum -y install net-tools
使用rpm -ivh 下载mysql-community-server-8.0.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.33-1.el7.x86_64.rpm
根据所提示的要求，下载依赖包，直到把这个版本的mysql下载好为止
修改配置文件
先去vim /etc/my.cnf 文件
//添加explicit_defaults_for_timestamp=true
保存并退出
然后rm -rf /var/lib/mysql/*
初始化配置MySQL
mysqld --initialize
设置MySQL开机自启动
systemctl enable mysqld
获得初始密码
# cat /var/log/mysqld.log |grep password
2024-07-11T11:15:39.557647Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: X,ko?dq7PJ,B
2024-08-02T06:49:14.784687Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 2nm&kcg#sytR
使用初始密码登录
[root@D ~]# mysql -uroot -p
Enter password: 2nm&kcg#sytR
设置密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Yn@666666'
-> ;
Query OK, 0 rows affected (0.03 sec)mysql> exit
修改远程权限
create user 'root'@'%' identified with mysql_native_password by 'Root@123456';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;
MySQL基础操作
创建库
mysql> create datababse test charset utf8;
Query OK, 1 row affected, 1 warning (0.01 sec)
查看库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| test |
+--------------------+
5 rows in set (0.00 sec)
删除库
mysql> drop database hh;
Query OK, 0 rows affected (0.04 sec)
选择使用数据库
mysql> use test;
Database changed
创建表
查看表
删除表
mysql> drop table student;
Query OK, 0 rows affected (0.03 sec)
查看表结构
查看创建表代码
mysql> show create table user;
新增列
mysql> alter table user add column realname varchar(20) null after password;
修改列名
mysql> alter table user change column realname zsxm varchar(20) null default null;
删除列
mysql> alter table user drop column zsxm;
添加记录
mysql> insert into user(id,username,password) values(5,'小六','xiaoliu'),(6,'小 七','xiaoqi');
查看记录
mysql> select * from user;
删除记录
mysql> delete from user where username='张三';
修改记录
mysql> update user set password=123 where username='小六';
