Too anyone that wants to know how to grant themselves permissions from another box... I run the server on a linux box, database on a windows machine.
Log in as the root user and execute this..
mysql>GRANT ALL PRIVILEGES ON eq.* TO monty@localhost
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON eq.* TO monty@"%"
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
You can also replace the % with just the ip of the other server if you want to be a bit more secure about it.
|