View Single Post
  #3  
Old 25th June 2009, 03:19
crisko crisko is offline
Junior Member
 
Join Date: Jun 2009
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well, it looks like I have taken a step backwards.

I fired up mysql and navigated to the host table of mysql.

I then entered:

Code:
update user set Host='mx2.myisp.com' where user='root';

update db set Host='mx2.myisp.com' where Db='mysql';
I then restarted the service.

Now two things are happening:

First, when I try to access the DB from MX1 I get:

Code:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Second, when in the expert installation of MX2, when trying to connect to MX1 it aborts stating tables have been created.

Is there a way flush the privlages in mysql to allow root to login once again, also do I want to specify a seperate DB when adding the second server to the setup?

Thanks!
Reply With Quote