• 创建数据库

    CREATE DATABASE 数据库名称 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

    创建用户

    CREATE USER 'user'@localhost IDENTIFIED BY 'password';  ## 本地访问
    CREATE USER 'user'@'%' IDENTIFIED BY 'password';  ## 任意ip访问

    给权限

    GRANT ALL PRIVILEGES ON 数据库名.* TO '用户名'@localhost; ## 给单独数据库的权限
    
    GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'password'; ## 给全部权限但是该user不能编辑和给予其它用户权限
    
    GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; ## 给全部权限并且该user可以编辑和给予其它用户权限