mysql的基本应用1

[root@mysql ~]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar
[root@mysql ~]# rpm -ivh mysql-community-client-plugins-8.0.33-1.el7.x86_64.rpm 
[root@mysql ~]# rpm -ivh mysql-community-common-8.0.33-1.el7.x86_64.rpm 
[root@mysql ~]# rpm -ivh mysql-community-client-plugins-8.0.33-1.el7.x86_64.rpm 
[root@mysql ~]# yum remove mariadb-libs.x86_64 
[root@mysql ~]# rpm -ivh mysql-community-libs-8.0.33-1.el7.x86_64.rpm 
[root@mysql ~]# rpm -ivh mysql-community-client-8.0.33-1.el7.x86_64.rpm 
[root@mysql ~]# rpm -ivh mysql-community-icu-data-files-8.0.33-1.el7.x86_64.rpm 
[root@mysql ~]# rpm -ivh mysql-community-server-8.0.33-1.el7.x86_64.rpm 
[root@mysql ~]# mysqld --initialize
[root@mysql ~]# chown -R mysql:mysql /var/lib/mysql
[root@mysql ~]# vim /var/log/mysqld.log             寻找登陆密码，密码不能有空格
2024-08-02T01:38:57.489240Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost:j*)jizKj?6xQ
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'q2q2';
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

mysql> create database test charset utf8;
mysql> show databases;
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test               |
+--------------------+
5 rows in set (0.00 sec)

mysql> drop database test;
Query OK, 0 rows affected (0.01 sec)
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)