cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

MySQL How to Grant User Privileges- DB Access Denied

I'm trying to create a scheduled DB backup but can't get the privileges correct. From the cpanel I've granted all permissions but my mysqldump command still doesn't have sufficient privileges.

 

Couldn't execute 'FLUSH TABLES': Access denied; you need (at least one of) the RELOAD privilege(s) for this operation (1227)

I know as a standard root user I could get this to work but I don't have the root credentials and it sounds like that isn't shared because it is a shared mysql instance. Is there a way to get this to work?

2 REPLIES 2
Moderator
Moderator

Re: MySQL How to Grant User Privileges- DB Access Denied

Hi @chris85

You will want to call in so that our support team can check your permissions from the server side. 

KayJay - GoDaddy | Community Moderator
24/7 support available at x.co/247support
New

Re: MySQL How to Grant User Privileges- DB Access Denied

Sir

In my Channel, I found the "Privileged users" on my database name [ of my jobs Blog ] What it means. Is it a symptom of hacking? 

And one more thing

I created a database. But another database is created without my action and the database memory is zero which I created and 45mb of database memory which I don't create. 

What to do now

When I change the database password my site shows database error message.

Please suggest me what to do now.