Error Creating User

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 创建用户报错

| username: TiDBer_TVKpabeM

[TiDB Usage Environment] Production Environment / Testing / Poc
[TiDB Version]
[Reproduction Path] What operations were performed when the issue occurred
Error when creating user in Navicat
[Encountered Issue: Issue Phenomenon and Impact]

[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]

| username: 啦啦啦啦啦 | Original post link

Try using a sentence to see if it still reports an error.

| username: 春风十里 | Original post link

I feel that your screenshot is also not very complete. I tested it myself, and with TiDB 6.5.2 and Navicat version 10.1, creating a user is successful.
Could you provide a complete screenshot or the situation when executing the script manually?
Note: In the Navicat SQL preview interface, you can see the create user statement.

| username: linnana | Original post link

Does creating a user via the command line also result in an error? It seems like a client version compatibility issue.

| username: zhanggame1 | Original post link

Run with sentences.

| username: tidb菜鸟一只 | Original post link

It looks like your client automatically generated the ssl_type attribute when creating the user, but TiDB does not recognize this attribute.