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

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:

update user set Host='' where user='root';

update db set Host='' 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:

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?

Reply With Quote