美文网首页
MySQL 笔记

MySQL 笔记

作者: T_K_233 | 来源:发表于2019-07-05 23:48 被阅读0次

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';

相关文章

网友评论

      本文标题:MySQL 笔记

      本文链接:https://www.haomeiwen.com/subject/uufuhctx.html