MySQL permissions depend on which box you are coming from. So [EMAIL PROTECTED] might have one set of permissions and [EMAIL PROTECTED] might have different permissions (or none).
You can adjust the permissions using the PERMIT statement. Regards, Martin On Thu, 2003-04-03 at 10:34, Adam W wrote: > Hi All, > > I am having a few problems with mySQL. Why would it be doing this: > * I can login locally on the mySQL box using $mysql -uadamw -p > * I try and do this through mySQL control center running on > windows machine and it gives me: ERROR 1045: Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > * I try this on a linux (not the server) box using $mysql > -uadamw -p and it lets me access it. > * Last night I could access mySQL via the control center - but > after a reboot it now refuses. Though last night it allowwed me after > some changes to hosts.allow, hosts.deny (don't know if that is relevant > - isnt this just xinetd? I'm not running mySQL through xinetd) > > Of course I have set the users table correctly - user adamw is accepted > from all hosts. > > Can anyone pick the error?? > > Cheers > > Adam W. > > -- > SLUG - Sydney Linux User's Group - http://slug.org.au/ > More Info: http://lists.slug.org.au/listinfo/slug > -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug