centos7 中安装 mysql 8.x

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='小六';