1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Error with Mysql Flush

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by PierrickL, Jun 28, 2011.

  1. PierrickL

    PierrickL Guest

    0
     
    Hello i need your help to flush my mysql database.
    I've got a cron request which is :

    mysql --user=LOGIN --password=PASSWORD --e 'RESET QUERY CACHE'

    And i've got this result :
    ERROR 1227 (42000) at line 1: Access denied; you need the RELOAD privilege for this operation

    What should i do in Plesk to get the RELOAD privilege, or should i do something else ?

    Thanks for your help.

    P.
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,556
    Likes Received:
    1,241
    Location:
    Novosibirsk, Russia
    Check in 'mysql' database that this user has enabled RELOAD privilege with something like:

    mysql> select User, Reload_priv from user where User='username';

    And enable it if necessary.
     
  3. PierrickL

    PierrickL Guest

    0
     
    Thanks for this answer, but i don't understand where i can execute this command ?

    The point i don't really understand is that i am the admin of my owne dedicated server.
    On this server, i set up Plesk 10.0 for Linux.
    On Plesk, i set up domains.
    For each domain i created mysql database.
    For each database, i created 1 user.

    Is there a general Mysql server which i can access to set up the reload privilege ? (one for all the domains ?)
    Or should i set up the reload privilege for each user of each database ?

    Thanks for these answers.

    Regards.

    P.
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,556
    Likes Received:
    1,241
    Location:
    Novosibirsk, Russia
    It is 'mysql' database. You should use it for mentioned SQL queries. Contact Support Team if you are not familiar with SQL.
     
  5. PierrickL

    PierrickL Guest

    0
     
    Thanks.
    On Plesk i've got serveral domains, with several Database.

    And i can't connect to mysql with a Root user, can I ?

    The only thing i can do is to connect with the user of the database of each domain.
    With this type of connexion, i can't access to the USER table to change the reload privilege.

    Thanks for your help.
     
  6. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,556
    Likes Received:
    1,241
    Location:
    Novosibirsk, Russia
  7. PierrickL

    PierrickL Guest

    0
     
    Thanks for this.
    I can connect to mysql with the Admin user and the password of Plesk.
    But now when i write this command :
    I've got this message :
    I try to connect to User Database but it seems this database doesn't exist.
    What is the name of the User database ?

    Thanks for your help.
     
  8. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,556
    Likes Received:
    1,241
    Location:
    Novosibirsk, Russia
    Name of database is 'mysql'.
    Just run:

     
Loading...