Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Denied: GRANT ALL PRIVILEGES

Status
Not open for further replies.

neatgadgets

Programmer
Mar 31, 2009
2
AU
I have been trying to perform the following command but I get an error:

GRANT ALL PRIVILEGES ON *.* TO 'usernamehere'@'localhost' WITH GRANT OPTION;

error is

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I am doing this via putty directly on the virtual machine logged in as root

I have tried the solution mentioned by others to stop mysql and start it with the skip grant table option, then changing the password, flushing privileges and restarting mysql. Still same issue.

Any ideas?
 
Are you sure root has the correct privileges from 'localhost'? Looks like root isn't even being allowed to run the query.

Can you use the Mysql Workbench to check privileges?

MYSQL is very particular about privileges, each user has different privileges depending on location. These can vary even between a direct access through the mysql command interface and an application on the same machine.




----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top