#1044 - Access denied for user '~WebHub Signin admin.~'...

Asked by:
gdmellot / 16 Points
Time:
2013-03-09 5:36 pm EST
Category:
Databases
Hits:
401
I'm trying to note and potential modify a MySQL database user's privileges through SQL commands. Trying commands on MyPHPAdmin, I can only get one such command to work. 'SHOW GRANTS FOR CURRENT_USER;' This returns a basic rundown of the privileges of user 'paonia5'; which I take to be the default user/administrator for my site. When I try to get the privileges of another user (such as 'paonia5_WbPgSQL', or even that of 'paonia5' itself; I get the following error: "#1044 - Access denied for user 'paonia5'@'localhost' to database 'mysql'". Is there a way to configure PHP (or whatever) to allow an SQL command by a user with sufficient rights to be able to administrate privileges by SQL? Noting WAMP's response to similar SQL Queries I've noted that 'with GRANT OPTION' was not specified for the sign in administrator in the response to the 'CURRENT_USER' query on Web Hub's server, though.

I finally found out how to use 'MySQL Database' to set a privilege for a User. So there is that direct approach noted. Yet SQL's documentation states that a User can be enabled to give another User privileges equal to its own. So it should be possible, from that stand point.

To ask this user for more information, please first login.

To submit an answer, please login.

ANSWERS

0

johnpaulb-whh2
Staff
7,075 Points
2013-03-11 9:07 am EST
Hello gdmellot,

Thank you for your question. In a normal environment you should be able to set the permissions in that manner. However, when you are using a cPanel, privileges must be set in cPnael. As it is just the way cpanel operates.

To change a database user's permissions in cPanel, click the MySQL Databases button under Databases, then under Current Databases click the username that you want to modify the privileges for, and you will be able to choose the permissions you want to grant the user.

Here is a link to a full article titled "Changing a Database User's Privileges"

If you have any further questions, feel free to post them below, or contact live Tech Support.

They are available 24/7 via:
Email: support@webhostinghub.com
Phone: 877-595-4482 x2
&
Chat (there is a link on the top right).

Thank you,

-John-Paul

To submit a comment on this answer, please first login.

Want to share this Question?

News / Announcements

Update to SSL Certificates - Certificate Warnings
1969-12-31 11:00 am EST
Hits: 659

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.