Q&A for account management

[runkecheng]

General Question & Answer

radondb mysql uses xenoncli to complete account management operations.
reference：https://github.com/radondb/xenon/blob/master/docs/xenoncli_commands.md#2-mysql-operation

1. How to use root account?

   For helm version(source of qke appstore or charts/helm), you should do as steps:

   1. set allowEmptyRootPassword to false.
   2. cancel the comment of mysqlRootPassword and set the password.

2. How to create a new super account?

   After the cluster is deployed, enter the xenon container of any node and execute the following command.

   // SSL should be YES or NO.
   xenoncli mysql createsuperuser <userName> <Host> <PassWord> <SSL>
   

   The super account authorization information is as follows:

   +------------------------------------------------------------------+
   | Grants for testSuper@%                                           |
   +------------------------------------------------------------------+
   | GRANT ALL PRIVILEGES ON *.* TO 'testSuper'@'%' WITH GRANT OPTION |
   +------------------------------------------------------------------+
   

3. How to create a new normal account with privileges?

   enter the xenon container of any node and execute the following command.

   only create.

   xenoncli mysql createuser <userName> <Host> <PassWord> <SSL>
   

   create with privileges.

   //privs: for example:SELECT,CREATE(comma-separated)
   xenoncli mysql createuserwithgrants --user=<userName> --passwd=<PassWord> --database=<DatabaseName> --table=<TableName> --host=<Host> --privs=<privileges> --ssl=<SSL>
   

4. How to drop account?

   enter the xenon container of any node and execute the following command.

   xenoncli mysql dropuser <userName> <Host>
   

5. How to changepassword?

   enter the xenon container of any node and execute the following command.

   xenoncli mysql changepassword <userName> <Host> <NewPassword>
   

账号管理常见问题&答案

radondb mysql 使用 xenoncli 完成账户管理操作。

参考：https://github.com/radondb/xenon/blob/master/docs/xenoncli_commands.md#2-mysql-operation

1. 如何使用root账号？

   对于 helm 版本(通过 qke appstore 或 charts/helm 安装），您应该按照以下步骤操作：

   1. 将 allowEmptyRootPassword 设置为 false。

   2. 取消mysqlRootPassword的注释并设置密码。

2. 如何创建一个新的超级账号？

   集群部署成功后，进入任意节点的 xenon 容器，执行如下命令。

   // SSL 应该是 YES 或 NO。
   xenoncli mysql createsuperuser <userName> <Host> <PassWord> <SSL>
   

   超级账号授权信息如下：

   +------------------------------------------------------------------+
   | Grants for testSuper@%                                           |
   +------------------------------------------------------------------+
   | GRANT ALL PRIVILEGES ON *.* TO 'testSuper'@'%' WITH GRANT OPTION |
   +------------------------------------------------------------------+
   

3. 如何新建一个普通账号并授权？

   进入任意节点的 xenon 容器，执行以下命令。

   // 只创建
   xenoncli mysql createuser <userName> <Host> <PassWord> <SSL>
   

   // 创建并授权
   // privs 示例：SELECT,CREATE(逗号分隔)
   xenoncli mysql createuserwithgrants --user=<userName> --passwd=<PassWord> --database=<DatabaseName> --table= 
   <TableName> --host=<Host> --privs=<privileges> --ssl=< SSL>
   

4. 如何删除账号？

   进入任意节点的 xenon 容器，执行以下命令。

   xenoncli mysql dropuser <userName> <Host>
   

5. 如何更改密码？

   进入任意节点的 xenon 容器，执行以下命令。

   xenoncli mysql changepassword <userName> <Host> <NewPassword>
   

[runkecheng]

• Questions about account management can be directly asked under this issue, and we will answer them as soon as possible.
• Other questions about RadonDB MySQL are welcome to ask in the issue. Go ask questions

---

• 关于账号管理的问题可以直接在此 issue下提问，我们会第一时间解答。
• 关于 RadonDB MySQL 的其他问题欢迎提交 issue 提问。去提问