Help! Error When Migrating to TiDB

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:

| username: 江湖故人 | Original post link

The admin account does not have sufficient permissions.

| username: ffeenn | Original post link

Incorrect password or insufficient permissions.

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

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

| 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'@'%';
| username: zhanggame1 | Original post link

Import using root

| username: dba远航 | Original post link

The admin account permissions are not set correctly.