本文介绍了刷新表-访问被拒绝的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我需要备份数据库,但是在备份之前尝试刷新表时出现此错误? 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';

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

10-24 10:08