Issues with Lightning Import

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

Original topic: lightning导入问题

| username: 气死人的萌新

[TiDB Usage Environment] Single machine test environment
[TiDB Version] Export version v6.1.0, preparing to import to v6.5.0
[Reproduction Path] Exported to CSV file using dumpling in v6.1.0, configured lightning configuration file in v6.1.0 environment.
[Encountered Problem: Phenomenon and Impact] Using the root user during import, but still prompted with permission denied connection.
Problem screenshot


Lightning configuration file screenshot
image

[Resource Configuration]
[Attachment: Screenshot/Log/Monitoring]

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

Is your pd-addr correct? Using the same port as tidb?
Can you manually log in using mysql -h 192.168.238.223 -P4000 -uroot -predhat?

| username: 气死人的萌新 | Original post link

Because I am using a single machine for testing, I can log in.

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

However, the message indicates that you logged in from the 192.168.248.216 machine and were blocked.
Additionally, your pd-addr should be your PD address. Are you using port 4000 for PD?

| username: 气死人的萌新 | Original post link

My eyes misread it as TiDB. It has been corrected, so now, should 216 not be blocked?

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

Can you log in by executing mysql -h 192.168.238.223 -P4000 -uroot -predhat on 216? If not, grant privileges to root@‘192.168.248.216’.

| username: 气死人的萌新 | Original post link

Thank you, master. I found the reason; it was just the configuration parameters that weren’t set correctly.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.