Relational = using table
Record = one row
PRIMARY KEY: a key that is UNIQUE and NOT NULL, and should not be changed after creation
FOREIGN KEY often points to PRIMARY KEY
PRIMARY KEY and UNIQUE columns are automatically INDEXed
Atomic: the smallest piece of information that makes sense
mysqld --initialize --console
执行完成后,会输出 root 用户的初始默认密码,如:
...
2018-04-20T02:35:05.464644Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: APWCY5ws&hjQ
...
mysqld --console
mysql -h 主机名 -u 用户名 -p
ALTER USER root@localhost IDENTIFIED BY 'password';
网友评论