刷新表-访问被拒绝 [英] flush tables - access denied

问题描述

我需要备份数据库，但是在备份之前尝试刷新表时出现此错误? RELOAD特权是什么意思?

I need to back my database, but when trying to flush the tables before backing up I get this error? What does it mean by RELOAD privilege?

在phpmyadmin中找不到任何RELOAD特权！?

Can't find any RELOAD privilege in phpmyadmin!?

Error: Access denied; you need the RELOAD privilege for this operation
SQL: FLUSH TABLES WITH READ LOCK

推荐答案

可能您不是使用root用户运行FLUSH命令，而是使用了受限用户.
您需要被授予RELOAD特权才能运行FLUSH命令.
在此处中查看MySQL特权.
因此(例如)root用户应使用:

Probably you're not running FLUSH command using root, but with a limited user.
You need to be granted RELOAD privilege to run FLUSH command.
Take a look here for MySQL privileges.
So (for example) root user should use:

GRANT RELOAD ON *.* TO 'your_user'@'localhost';

这篇关于刷新表-访问被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！