vault:https://www.cnblogs.com/wing-ms/p/5535661.html E:\mysql64\bin mysqld --initialize --console 2018-10-17T01:54:44.946418Z 0 [System] [MY-013169] [Server] e:\mysql64\bin\mysqld.exe (mysqld 8.0.12) initializing of server in progress as process 11928 2018-10-17T01:55:07.992026Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: SqMRCeOda4;Q 2018-10-17T01:55:26.700918Z 0 [System] [MY-013170] [Server] e:\mysql64\bin\mysqld.exe (mysqld 8.0.12) initializing of server has completed
ALTER USER root IDENTIFIED BY '123456'; CREATE DATABASE tt; use tt; show databases;
CREATE TABLE IF NOT EXISTS `runoob_tbl`( `runoob_id` INT UNSIGNED AUTO_INCREMENT, `runoob_title` VARCHAR(100) NOT NULL, `runoob_author` VARCHAR(40) NOT NULL, `submission_date` DATE, PRIMARY KEY ( `runoob_id` ) )ENGINE=InnoDB DEFAULT CHARSET=utf8;
show tables;
desc runoob_tbl;
insert into `runoob_tbl` (`runoob_title`,`runoob_author`,`submission_date`
) values ('t1','a1', '2018/10/17');
select * from `runoob_tbl`;