Good day.

I installed MySQL database on Azure. I'm trying to import data from another database through MySQL WorkBench. Gives an error: select command denied to user ... for table ... I went to phpMyAdmin and tried to add rights.

GRANT ALL PRIVILEGES ON * . * TO 'user'@'eu-cdbr-azure-west-d.cloudapp.net';

Got an error: #1227 - Access denied; you need (at least one of) the RELOAD privilege(s) for this operation #1227 - Access denied; you need (at least one of) the RELOAD privilege(s) for this operation

What could be the reason?

Thank.

Closed due to the fact that off-topic participants cheops , user194374, alexis031182 , Grundy , zRrr Jul 11 ​​'16 at 20:59 .

It seems that this question does not correspond to the subject of the site. Those who voted to close it indicated the following reason:

  • "The question is caused by a problem that is no longer reproduced or typed . Although similar questions may be relevant on this site, solving this question is unlikely to help future visitors. You can usually avoid similar questions by writing and researching a minimum program to reproduce the problem before publishing the question. " - cheops, Community Spirit, alexis031182, Grundy, zRrr
If the question can be reformulated according to the rules set out in the certificate , edit it .

  • Not sure, but it is possible that you need to add users through the portal. - Walter Nuss
  • From which user do you perform operations and how was it created? Do you have access to the root account? - cheops
  • I contacted Microsoft support, they say that the database cannot be imported in this way, since MySQL is not their native and they are its Burut from ClearDB. Here is an explanation. They say that you can only from the command line (Kudu). And he did. - Makeda

0