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;