Access denied for user to database

yasinkhan2651990

Registered
Aug 18, 2016
1
0
1
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 [email protected]
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
 
Last edited by a moderator:

Sifweti Situmbeko

Registered
Oct 26, 2016
1
0
1
Lusaka, Zambia
cPanel Access Level
Root Administrator
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:


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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
(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.