Access denied for user to database

yasinkhan2651990

• August 18, 2016 08:38

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

• 

  Infopro

  • August 18, 2016 13:54

  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:

  0
• 

  Sifweti Situmbeko

  • October 27, 2016 06:27

  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: ]https://forums.cpanel.net/data/attachments/48/48401-979da21ea84b7d7c304eaa3d73400410.jpg
  

  
  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.

  0
• 

  cPanelMichael

  • October 31, 2016 23:18

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

  
  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.

  0

Please sign in to leave a comment.