mysql8.0.16如何初始化_MySQL8.0初始化操作

附海文网盘：https://help.seafile.com/zh/syncing_client/syncing_librarise.html

https://www.jianshu.com/p/5c1198aefe71

skip-grant-tables#直接跳过密码登录

###############################################

default_authentication_plugin=mysql_native_password ##启动之前打开

连接MySQL服务器，修改密码

1.grep 'temporary password' /var/log/mysqld.log

2.set global validate_password.policy=0;

3.set global validate_password.length=6;

4.alter user user() identified by "123456"; //修改登陆密码

5.flush privileges;

###########################################

用户授权和修改密码

创建账号密码

CREATE USER wangwei@127.0.0.1 IDENTIFIED BY 'passowrd';

授予权限

GRANT ALL ON . TO wangwei@127.0.0.1 WITH GRANT OPTION;

删除权限

REVOKE all privileges ON databasename.tablename FROM 'username'@'host';