ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 通过 grant privilege创建用户报1044错误

通过 grant privilege创建用户报1044错误

原创 Linux操作系统 作者:myownstars 时间:2011-02-15 17:07:40 0 删除 编辑

[oracle@db ~]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1054
Server version: 5.0.77-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> grant all privileges on justin.* to justin_user@"%" identified by 'justin_user';
ERROR 1044 (42000): Access denied for user 'root'@'%' to database 'justin'

退出 重新登录

[oracle@db ~]$ mysql -u root -p -h db
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1055
Server version: 5.0.77-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all privileges on justin.* to justin_user@"%" identified by 'justin_user';
Query OK, 0 rows affected (0.07 sec)

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15480802/viewspace-687284/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-03-18

  • 博文量
    375
  • 访问量
    3158682