>From memory MySQL handles local access differently to remote access. If you
connect from the localhost then it will use [EMAIL PROTECTED] while remote
access will use [EMAIL PROTECTED] Make sure both accounts exist and use the password
for [EMAIL PROTECTED] when using mycc from a windows box. (Remember that
[EMAIL PROTECTED] and [EMAIL PROTECTED] can have different passwords because they are
different users)
Rich
----- Original Message -----
From: "Adam W" <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED] Org. Au'" <[EMAIL PROTECTED]>
Sent: Thursday, April 03, 2003 10:34 AM
Subject: [SLUG] mySQL Control Center - Access Denied Problem
> 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
