Error

An error occurred.

Sorry, the page you are looking for is currently unavailable.
Please try again later.

If you are the system administrator of this resource then you should check the error log for details.

Faithfully yours, nginx.

帮助文档(华北一、二)

  • phpMyAdmin操作

    登录phpMyAdmin,点击添加用户,输入用户名、域和密码;如果域为’%’,在主机一栏选择“任意主机”; 如果指定某网段,选择“使用文本域”,然后输入对应的值,再勾选所需权限,完成后,点击“添加用户”即可。

    命令行操作

    命令行操作请使用grant命令。

    例:增加与root同样权限的用户”test@%”,密码123456。

    用户使用root账号登陆云数据库,执行show grants,得到root权限语句:

     GRANT
    SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,RELOAD,PROCESS,REFERENCES,INDEX,ALTER,SHOW  DATABASES,CREATE  TEMPORARY  TABLES,LOCK  TABLES,EXECUTE,REPLICATION  SLAVE,REPLICATION CLIENT,CREATE  VIEW,SHOW  VIEW,CREATE  ROUTINE,ALTER  ROUTINE,CREATE  USER,EVENT,TRIGGER ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*xxxxxx' WITH GRANT OPTION

    将该语句复制下来,然后替换语句中的用户名、域和密码串,执行修改后的授权语句:

     GRANT
    SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,RELOAD,PROCESS,REFERENCES,INDEX,ALTER,SHOW DATABASES,CREATE TEMPORARY TABLES,LOCK TABLES,EXECUTE,REPLICATION SLAVE,REPLICATION CLIENT,CREATE VIEW,SHOW VIEW,CREATE ROUTINE,ALTER ROUTINE,CREATE USER,EVENT,TRIGGER ON *.* TO 'test'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

    刷新权限表

     flush privileges;


文档是否已解决您的问题?

  已解决   未解决

如您有其它疑问,您也可以与我们技术专家联系探讨。

联系技术专家