[Cialug] Re: updating mysql users after db relocation

[Barry Von Ahsen]

Matthew Nuzum wrote:
> I now get errors when I try to restart or connect to the database as
> anything but root.
> error: 'Access denied for user 'debian-sys-maint'@'localhost' (using
> password: YES)'
> 
> Likewise I'm not able to connect from 192.168.1.103. I created a user
> who should be able to connect from any host (I tried % and *).
> 
>>  > Did you do a "flush privileges" after you did the update?
>>  >
>>  >
>>  > :) Dave
> 
> Yes, unfortunately.

do you have to update the host or db tables to match the new user table?

-barry