Does the user for Lightning have to be root?

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

Original topic: lightning 用的用户必须是 root 吗?

| username: TiDBer_Latnok_Han

I created a user and granted permissions to a database, but it prompted “tidb lightning encountered error: obtain new collation enabled failed: Error 1142(42000): select command denied to user ****@‘%’ for table ‘tidb’”.

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

Lightning needs to create databases, tables, and insert data. Have these permissions been granted?

| username: caiyfc | Original post link

The following permissions are sufficient: TiDB Lightning Target Database Requirements | PingCAP Documentation Center

| username: TiDBer_QHSxuEa1 | Original post link

Based on the backend mode you chose under tikv-import, tidb-logical import is essentially SQL import, so having the normal related schema permissions like select, insert, update, delete, create, and drop is sufficient. If you choose physical import (local), you will also need the relevant super permissions.

| username: TiDBer_Latnok_Han | Original post link

Granting all privileges on a database

| username: TiDBer_Latnok_Han | Original post link

It looks like this is missing: physical import mode mysql.tidb SELECT

| username: dba远航 | Original post link

Permissions need to be set correctly.

| username: TiDBer_QYr0vohO | Original post link

Sure, please provide the text you need translated.

| username: system | Original post link

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