Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: 使用DM创建数据源的时候报错 感谢各位大佬!
[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:
Try using telnet mysql_host 3306
on 192.168.1.86 to see if it is accessible.
Able to connect, permissions are also fine.
Is the password in the configuration file encrypted?
No, it’s the real password.
What is the version of MySQL?
I followed the official website to set the database password, which contained special characters. I just changed the password and it worked.
Still, thank you very much.
What special characters do you have in your password? Our password has special characters and it works fine.
Please share the special characters you used. This way, others can avoid pitfalls.
The encrypted password is also fine.
Please share the special characters you used. This way, others can avoid pitfalls.
I tried it, but it didn’t work. It might be an issue with my operation.
I don’t know either. After changing to a regular password, it indeed worked. !@#$ these
Well, it could be caused by escaping.
I checked and found that our password contains # and %, which is normal.
Is it really not possible to use @ and !? Can someone try it out?
This topic will be automatically closed 60 days after the last reply. No new replies are allowed.