Error When Creating Data Source Using DM - Thanks to All Experts!

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

Original topic: 使用DM创建数据源的时候报错 感谢各位大佬!

| username: Ann_ann

[TiDB Usage Environment] Test Environment
[TiDB Version] 4.0.11
[Encountered Problem] Error when creating data source
[Problem Phenomenon and Impact]

tiup is checking updates for component dmctl …timeout!
Starting component dmctl: /root/.tiup/components/dmctl/v6.1.0/dmctl/dmctl /root/.tiup/components/dmctl/v6.1.0/dmctl/dmctl --master-addr 192.168.1.86:8261 operate-source create source-mysql-01.yaml
{
“result”: false,
“msg”: “[code=10001:class=database:scope=not-set:level=high], Message: database driver error, RawCause: Error 1184: Aborted connection 30337012 to db: ‘unconnected’ user: ‘tidb_dm’ host: ‘192.168.1.86’ (init_connect command failed), Workaround: Please check the database connection and the database config in configuration file.”,
“sources”: [
]
}

Problem Description:
The account and password for the data source are usable. Manual connection test is successful. Here I am using one DM-master and one DM-worker.


Data Source Configuration:
image

| username: songxuecheng | Original post link

Try using telnet mysql_host 3306 on 192.168.1.86 to see if it is accessible.

| username: Ann_ann | Original post link

It is connected.

| username: Ann_ann | Original post link

Able to connect, permissions are also fine.

| username: songxuecheng | Original post link

Is the password in the configuration file encrypted?

| username: Ann_ann | Original post link

No, it’s the real password.

| username: songxuecheng | Original post link

What is the version of MySQL?

| username: Ann_ann | Original post link

I followed the official website to set the database password, which contained special characters. I just changed the password and it worked.

| username: Ann_ann | Original post link

Still, thank you very much.

| username: xiaohetao | Original post link

What special characters do you have in your password? Our password has special characters and it works fine.

| username: jackie-wen | Original post link

Please share the special characters you used. This way, others can avoid pitfalls.

| username: Hacker007 | Original post link

The encrypted password is also fine.

| username: 西伯利亚狼 | Original post link

Please share the special characters you used. This way, others can avoid pitfalls.

| username: Ann_ann | Original post link

#@! These

| username: Ann_ann | Original post link

I tried it, but it didn’t work. It might be an issue with my operation.

| username: Ann_ann | Original post link

I don’t know either. After changing to a regular password, it indeed worked. !@#$ these

| username: tidb狂热爱好者 | Original post link

Well, it could be caused by escaping.

| username: xiaohetao | Original post link

I checked and found that our password contains # and %, which is normal.

| username: Tank001 | Original post link

Is it really not possible to use @ and !? Can someone try it out?

| username: system | Original post link

This topic will be automatically closed 60 days after the last reply. No new replies are allowed.