Help! Error When Migrating to TiDB

Translated
1

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

Original topic: 求助！ 迁移到TiDB报错

| username: TiDBer_kmB0dl9H

[Test Environment for TiDB] Testing
[Encountered Issue: Problem Phenomenon and Impact] Exporting source files using local MySQL in TiDB backend mode, what is the reason for the error? The configuration file is as follows:

image
image1469×237 15.5 KB

image
image929×630 46.9 KB

2
| username: 江湖故人 | Original post link

The admin account does not have sufficient permissions.

3
| username: ffeenn | Original post link

Incorrect password or insufficient permissions.

4
| username: 像风一样的男子 | Original post link

Access denied account issue, the admin privileges of this TiDB account are insufficient.

5
| username: 江湖故人 | Original post link

You can switch to the root account, or try granting permissions to the admin:

--alter user admin@'%' identified by 'pwd';  
create database lightning_task_info;
grant all privileges on lightning_task_info.* to 'admin'@'%';
6
| username: zhanggame1 | Original post link

Import using root

7
| username: dba远航 | Original post link

The admin account permissions are not set correctly.