I’ve been having a similar problem and am unable to resolve it.
I am trying to run a query to give a db user permission on a certain database. (GRANT command)
The Grant statement which I am issuing is in the following format:
GRANT ALL PRIVILEGES ON db_name TO ‘user’@‘ip’ IDENTIFIED BY ‘pass’
However, when I run the query in PHPMyAdmin, I continue to get the error:
MySQL said: Documentation #1044 - Access denied for user ‘domainna’@‘localhost’ to database ‘db_name’
The “domainna” above is actually the first 8 characters of my hostname (domain name). I don’t like that InterWorx pads all usernames with the name of the domain first… I feel that this is causing the issue.
Anyways I’ve been told that I need to perform this query as root while shelled into my server.
I’ve been told to shell in and then issue:
mysql -uroot -prootpass
However, I never set a MySQL root password. Is one set automatically? Is there a way for me to set one?
Is there any reason why you aren’t using SiteWorx to grant this user permissions? Regardless, ‘domainna’ is not a valid database user created by SiteWorx. All database users created from siteworx are of the form ‘domainna_username’. So, you’d want to use something like:
GRANT ALL PRIVILEGES ON db_name TO ‘testdoma_testuser’@‘ip’ IDENTIFIED BY ‘pass’
You can reset the MySQL root pass from NodeWorx by going to System Services -> MySQL Server -> Overview, and look for the MySQL Root Password box at the bottom of the screen.