neatgadgets
Programmer
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?
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?