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.

Access denied for user to database

Discussion in 'Database Discussions' started by yasinkhan2651990, Aug 18, 2016.

  1. yasinkhan2651990

    yasinkhan2651990 Registered

    Joined:
    Aug 18, 2016
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Saudi Arabia, Riyadh
    cPanel Access Level:
    Website Owner
    Hi,

    I'm trying to give admin rights to MySQL user using this SQL statement ran on cpanel>phpmyadmin>SQL
    GRANT ALL PRIVILEGES ON qorbit_store.* TO 'someusr'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
    We are trying to Integrate our website "example.com" MySQL database with Peachtree accounting software using Dell Boomi AtomSphere.
    As per Dell Boomi forums. They replied in the link.
    community.boomi.com/message/8983

    I cannot access 'root'@'localhost' and there is no global privileges option on the myphpadmin page.
    I tried using SHOW GRANTS FOR 'someusr'@'localhost';
    It's showing:
    Grants for someusr@localhost
    GRANT USAGE ON *.* TO 'someusr'@'localhost'
    GRANT ALL PRIVILEGES ON `qorbit_store`.* TO 'someusr'@'localhost'

    In the
    There is a table - Removed - and it's showing
    GRANTEE
    'someusr'@'localhost'
    TABLE_CATALOG
    def
    PRIVILEGE_TYPE
    USAGE
    IS_GRANTABLE
    NO

    What should I do?

    Thanks,
    Yasin Khan
     
    #1 yasinkhan2651990, Aug 18, 2016
    Last edited by a moderator: Aug 18, 2016
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,453
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Try creating your database, user w/password from within your cPanel instead.

    cPanel > Databases > MySQL Databases

    - Create Database
    - Add New User
    - Add user to Database
    - Grant all privileges

    Here's a screenshot:

    grntsijdm.png
     
  3. Sifweti Situmbeko

    Sifweti Situmbeko Registered

    Joined:
    Oct 26, 2016
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Lusaka, Zambia
    cPanel Access Level:
    Root Administrator

    I have a similar problem which I started having after I migrated to EasyApache 4 .

    I can no longer create MySql Database USERS. I can create database alright but when I try to create the USER to the database I get the error;

    (XID 9uxd3n) Error from MySQL query :(XID 6xp6xr) Database Error: Access denied for user 'root'@'localhost' (using password: YES):

    I am trying to create my database, user w/password from within the cPanel:

    cPanel > Databases > MySQL Databases

    - Create Database
    - Add New User
    - Add user to Database
    - Grant all privileges

    The MySql Database Wizard also gives an ERROR at the stage for creating USER:
    A fatal error or timeout occurred while processing this directive. Show More:

    Template::Exception:
    [TYPE]=[undef]
    [INFO]=[Mysql::get_privileges_on_database(HASH(0x613a6b0)) failed: (XID xywfgb) The system user “blci” does not control a MySQL user named “blci_test2”.
    ]
    [TEXT]=[

    ]
    at cpanel.pl line 1240.
    cpanel::cpanel::cptt_exectag("/usr/local/cpanel/base/frontend/paper_lantern/sql/wizard3.htm"..., 1) called at cpanel.pl line 5224
    cpanel::cpanel::run_standard_mode() called at cpanel.pl line 847
    cpanel::cpanel::script("cpanel::cpanel", "./frontend/paper_lantern/sql/wizard3.html.tt") called at cpanel.pl line 306

    What could be the problem here?

    Thank you.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    There's several potential reasons you could be seeing this message. Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
Loading...

Share This Page