RDBMS DAY1

案例1：构建MySQL服务器
案例2：数据库基本管理
案例3：字符类型
案例4：数值类型
案例5：日期时间类型
案例6：枚举类型

---

1.案例1.构建

[root@node3 /]# netstat -untlp | grep 3306 # netstat 比较简介
tcp6 0 0 :::3306 ::😗 LISTEN 1160/mysqld
[root@node3 /]# ps -C mysqld #仅查一个指定进程
PID TTY TIME CMD
1160 ? 00:00:00 mysqld

初始化密码

grep -i ‘password’ /var/log/mysqld.log 查看初始密码

2020-05-13T01:59:38.577550Z 1 [Note] A temporary password is generated for root@localhost: k,a>gH2mIXX4

[root@localhost /]# mysql -uroot -p’k,a>gH2mIXX4’ 登录
只有在修改初始密码之后才能 show databases
mysql> alter user root@‘localhost’ identified by ‘123’; 修改密码
修改之后 var/log/mysqld.log 不会存在修改之后的密码

mysql> show variables like ‘%password%’;
±--------------------------------------±------+
| Variable_name | Value |
±--------------------------------------±------+
| default_password_lifetime | 0 |
| disconnect_on_expired_password | ON |
| log_builtin_as_identified_by_password | OFF |
| mysql_native_password_proxy_users | OFF |
| old_passwords | 0 |
| report_password | |
| sha256_password_proxy_users | OFF |
| validate_password_check_user_name | OFF |
| validate_password_dictionary_file | |
| validate_password_length | 6 |
| validate_password_mixed_case_count | 1 |
| validate_password_number_count | 1 |
| validate_password_policy | LOW |
| validate_password_special_char_count | 1 |
±--------------------------------------±------+
14 rows in set (0.00 sec)

[root@node3 ~]# ps aux | grep mysqld
mysql 1160 0.1 11.8 1316400 171852 ? Sl 10:31 0:01 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
root 1240 0.0 0.0 112720 984 pts/0 S+ 11:02 0:00 grep --color=auto mysqld

步骤二:
库:
建库
mysql> create database gamedb ;
mysql> show databases ;
±-------------------+
| Database |
±-------------------+
| information_schema |
| gamedb |
| mysql |
| performance_schema |
| sys |
±-------------------+
5 rows in set (0.00 sec)

---

查看当前库
mysql> select database();
切换库
mysql> use sys ;
表的字符集: show create table mysql.stuinfo;
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |