Error when trying to grant permissions
Posted by: Jinx13 (---.range86-135.btcentralplus.com)
Date: March 28, 2013 01:53PM

Hi, I am trying to setup wamp server.
So far I set up changed password and can access phpmyadmin.

When I try create a user or do anything that needs root permissions with the root account I get errors.

Error

SQL query: Edit Edit

GRANT ALL PRIVILEGES ON * . * TO 'devhost'@'localhost' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

Does anyone know what I am doing wrong?

Thanks in advance

Options: ReplyQuote
Re: Error when trying to grant permissions
Posted by: RiggsFolly (---.as13285.net)
Date: April 02, 2013 01:45PM

Have you actually created the account you are trying to grant privilages to?

Normal process is:

mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> WITH GRANT OPTION;

Options: ReplyQuote


Sorry, only registered users may post in this forum.