#1044 - Access denied for user 'someusr'@'localhost' to database 'somedb'

user3259951 picture user3259951 · Aug 19, 2016 · Viewed 13.3k times · Source

I'm trying to give admin rights to MySQL user using this SQL statement ran on cpanel>phpmyadmin>SQL

GRANT ALL PRIVILEGES ON somedb.* TO 'someusr'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

but it's giving user denied error:

#1044 - Access denied for user 'someusr'@'localhost' to database 'somedb'

We are trying to Integrate our website "www.somewebsite.com" MySQL database with Peachtree accounting software using Dell Boomi AtomSphere.

As per Dell Boomi forums. They replied in the link.

https://community.boomi.com/message/8983

There is no global privileges option on the phpMyAdmin page. There is only data and structure privileges in Cpanel>MySQL Database but no Administration privileges as shown in this video @ 8:27 sec; https://youtu.be/64nYbTkcRZ4?t=507

I tried using SHOW GRANTS FOR 'someusr'@'localhost';

It's showing:

Grants for someusr@localhost

GRANT USAGE ON . TO 'someusr'@'localhost' IS GRANTABLE = NO

What should I do?

Answer

user3259951 picture user3259951 · Oct 21, 2016

Actually there are two steps to solve this problem if you are using Cpanel. First step is to go to Remote MySQL and add your IP address of your network.You can check your IP by going to whatismyipaddress.com or add % percent sign so that anyone can access it but this is not recommended because of security issues. Secondly go to the MySQL Database and grant all user privileges like select, update, delete etc. Now you cannot get any user denied error using dell boomi.