-- 创建Mysql user1用户
USE mysql;
CREATE USER user1 IDENTIFIED BY 'user1';
-- 移除 user1用户所有访问权限
REVOKE all privileges ON *.* FROM 'user1';
-- 将db1数据库访问权限分配给 user1用户
GRANT ALL PRIVILEGES ON db1.* TO 'user1';
修改用户密码
USE mysql
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
USE mysql
CREATE USER card IDENTIFIED BY 'card';
ALTER USER 'card'@'%' IDENTIFIED WITH mysql_native_password BY '1qaz@WSX3edc';
初始化root账号plugin策略
Windows Mysql8可能的问题：
Authentication method 'caching_sha2_password' failed. Either use a secure connection, specify the server's RSA public key with ServerRSAPublicKeyFile, or set AllowPublicKeyRetrieval=True.
预防解决办法：登录root执行以下Sql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
Access denied for user 'root'@'localhost' (using password: YES)
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'; #更新一下用户的密码
FLUSH PRIVILEGES; #刷新权限
Authentication method 'caching_sha2_password' failed.
1、通过cmd连接
2、使用mysql -u root -p 连接数据库
3、执行更改权限代码：grant all privileges on *.* to 'root'@'%' identified by '123456';
4、刷新权限 flush privileges;
5、退出exit
增加字段
ALTER TABLE tb1 ADD COLUMN CarStatus int(11) DEFAULT NULL COMMENT '车辆状态：0停止，1行驶中';
ALTER TABLE tb1 ADD COLUMN CarNumber VARCHAR(50) DEFAULT NULL COMMENT '车牌号';