MySQL 8.0 新建数据库、用户、设置密码、修改权限

#新建数据库
mysql> create database database_name;

#切换数据库
mysql> use database_name;

#创建用户并设置密码
mysql> CREATE USER 'user_name'@'localhost' IDENTIFIED mysql_native_password BY  'password'; //默认密码加密方式，可能有登陆问题
mysql> CREATE USER 'user_name'@'localhost' IDENTIFIED mysql_native_password BY  'password'; //指定密码加密方式‘mysql_native_password’

#赋予root用户任何地址登陆所有权限
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

#赋予用户“user_name”localhost密码“password”登陆数据库"database_name"的所有权限
mysql> GRANT ALL PRIVILEGES ON database_name.* TO ‘user_name’@‘localhost’ IDENTIFIED mysql_native_password BY ‘password’ WITH GRANT OPTION;

#刷新权限
mysql> flush privileges;

#退出
mysql> exit;