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

[MySQL] Insufficient permissions to add new user

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by las3rtje, Feb 9, 2012.

  1. las3rtje

    las3rtje Guest

    0
     
    Hi all,

    After a morning of hardship I've finally transferred my hosting package, WITH SSL, to my VPS with plesk.

    I am running into some weird problems.
    - When I create a new database there's no problem at all - database created under the right account.
    - When I try to create a user for this database, the following message pops up :

    Error: Connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user 'admin'@'localhost' to database 'prestashop'

    this is odd, since I'm logged in as plesk admin, and when I go to the serevr settings -> server database settings and click "view databases" I can see all databases.

    The odd thing here is that on neither of my accounts I can create database users.

    AND

    I tried restarting the VPS, restarting the mysql daemon, no luck.

    Anyone has any idea what can be wrong this time ?

    Note: I have not touched the server in any way, I've just created and deleted some accounts, and uploaded site files.
     
    Last edited by a moderator: Feb 9, 2012
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,557
    Likes Received:
    1,242
    Location:
    Novosibirsk, Russia
  3. las3rtje

    las3rtje Guest

    0
     
    Hello Igor,

    Yes, as you can see in my first post all the right GRANTS have been set, also from the plesk cp I can see all the databases in the system.

    Today I'll try manually adding a user outside of plesk (straight from mysql commandline), that will probably work, i have no idea what can be wrong here.
     
  4. las3rtje

    las3rtje Guest

    0
     
    I have fixed this together with my system administrator:

    It seems that the mysql "admin" user (same as plesk login) didn't have access to some grants, but it shows "y" on those grants.

    We have removed mysql, reinstalled it completely with a proper "root" user, and now everything works again. Nevertheless this shouldn't be possible!
     
Loading...