进城务工人员小梅mysqldump报错：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
(base) root@intel-r01:~$ mysqldump -h 192.168.1.191 -uYourUsername -pYourPassword YourSchemaName.YourTableName mysqldump: [Warning] Using a password on the command line interface can be insecure. -- MySQL dump 10.13 Distrib 8.0.29, for Linux (x86_64) -- -- Host: 192.168.1.191 Database: YourSchemaName.YourTableName -- ------------------------------------------------------ -- Server version 8.0.27-0ubuntu0.21.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces mysqldump: Got error: 1044: Access denied for user 'YourUsername'@'%' to database 'YourSchemaName.YourTableName' when selecting the database |
用root账号登录mysql，然后给YourUsername用户一个PROCESS权限即可：
|
1 2 |
GRANT PROCESS ON *.* TO 'YourSchemaName'@'%'; flush privileges; |
转载时请保留出处，违法转载追究到底：进城务工人员小梅 » mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces