lig 发表于 2018-10-7 08:01:10

mysql创建用户与数据库

  查询当前db:1 select database() 2 status 3 show tables

  CREATE USER 'pig'@'%'>  use mysql

  create user 'lych'@'%'>  create database lych;
  grant all on . to lych;(grant all privileges on lych to lych@'%')
  show grants for lych
  ---待续

页: [1]
查看完整版本: mysql创建用户与数据库