mysql - 《数据库知识》

5.7 - 8.0+

CREATE TABLE PET (
name VARCHAR(20),
owner VARCHAR(20),
species VARCHAR(20),
birth DATE,
death DATE
);

INSERT INTO pet
VALUES(‘Puffbal’, ‘Diane’, ‘hamster’, ‘1999-03-30’, NULL);

CREATE DATABASE largeScreen;

CREATE TABLE screens ( id int, projectName varchar(200), projectUrl varchar(200), projectMembers varchar(200), projectRemarks varchar(200), projectUpdateTime varchar(200), projectCover varchar(200), gitUrl varchar(200));

ALTER TABLE screens ADD age INT(4);

ALTER USER ‘root’@’%’
IDENTIFIED WITH mysql_native_password
BY ‘root’;

SET PASSWORD FOR ‘root’@%’ = PASSWORD(‘123456’);

GRANT ALL PRIVILEGES ON . TO ‘username’@’host’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;

update user set host = ‘%’ where user = ‘root’;

Host: % 表示所有ip可以连接

drop database largeScreen; // 删除largeScreen数据库
DROP TABLE tb_emp3; // 删除数据表

SELECT user,host,plugin from mysql.user;

Use mysql;

show columns from user;

select authentication_string from user where User=’root’;

alter user ‘root’@’localhost’ IDENTIFIED BY ‘liuhehe’;
alter user ‘root’@’%’ IDENTIFIED BY ‘liuhehe’;

SELECT @@VERSION; // 查询mysql版本

ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘root’; // 修改加密方式并修改密码

ALTER USER ‘root’@’%’ IDENTIFIED WITH caching_sha2_password BY ‘root’;