IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    MySQL 5.6 Database Administrator-068-Which command will fix this issue?

    royalwzy发表于 2015-09-03 03:17:41
    love 0
    You are creating a new server with the same accounts as an existing server. You do this by importing a mysqldump file of the mysql database. You test whether the import was successful by using the following commands: Mysql> select user, host, password from mysql.user; 8 9 rows in set (0.00 sec) Mysql> show grants for ‘admin’@’%’; ERROR 1141 (42000): There is no such grant defined for user ‘admin’ on host ‘%’ Which command will fix this issue? A. CREATE USER ‘admin’ @’%’; B. GRANT USAGE ON *.* TO ‘admin’@’%’; C. FLUSH PRIVILEGES; D. FLUSH HOST CACHE; E. UPDATE mysql.user SET Create_user_priv = ‘Y’ WHERE user= ‘admin’; 答案:C


沪ICP备19023445号-2号
友情链接