The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

cPanel user unable to run sql query from phpmyadmin

Discussion in 'Database Discussions' started by chips12, Dec 8, 2010.

  1. chips12

    chips12 Active Member

    Joined:
    Nov 6, 2010
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    UK
    cpanel 11.28.52
    phpMyadmin 3.3.8

    When I click thorugh to phpmyadmin as user@localhost from cPanel, I can see my users databases and tables etc, but am unable to run sql queries on them.

    I get the error
    #1045 - Access denied for user 'user'@'localhost' (using password: YES)

    I am able to run the queries ok if I login to phpmyadmin as root, but just not when logged in as account owner from cpanel.

    I also notice that when creating a database user, granting all privileges does not grant the "execute" privilege. I am not sure if the problem is related?
     
  2. cPanelDavidN

    cPanelDavidN Integration Developer
    Staff Member

    Joined:
    Dec 17, 2009
    Messages:
    571
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Hi chips12,

    First think I'd do is to log out of cPanel/WHM completely and close all browser windows/tabs related to that server, and then remove all browser cookies and session cookies. In 11.28, we introduced some authentication logic to phpMyAdmin. It's possible that you have a session file that spans from 11.26. If so, we need to remove it and get a new one!

    If that doen't resolve the no-query behavior, I recommend opening a support ticket. You're welcome to reference this forum post (and please PM me the ticket number).

    As far as the 'EXECUTE' privilege, this is a known issue. A fix has been prepared and will be released soon in an 11.28 maintenance release. You can watch the changelog (11.28 or All Versions Atom feed) for case 44580.

    Regards,
    -DavidN
     
  3. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Case 44580 has been resolved in version 11.28.54. To see if version 11.28.54 has propagated to your update tier, visit Downloads - cPanel Inc.
     
  4. nanine

    nanine Registered

    Joined:
    Jan 12, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    I think that it has relation with privilages you must have all privilages or try to change user !!!
     
Loading...

Share This Page