View Single Post
  #2  
Old 02-19-2002, 03:02 PM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

Need to set the permissions on user at that ip..

Log in as the root user in the database 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 and replace monty and some_pass with your username and password you want to use to connect with..
Reply With Quote