[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
Re: [SLUG] mySQL Control Center - Access Denied Problem
> 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) no a lot of things use hosts.allow/deny, its tcp_wrappers.. any application can link against them .. Dave. > > Of course I have set the users table correctly - user adamw is accepted > from all hosts. > > Can anyone pick the error?? > > Cheers > > Adam W. > > -- David Airlie, Software Engineer http://www.skynet.ie/~airlied / [EMAIL PROTECTED] pam_smb / Linux DecStation / Linux VAX / ILUG person -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] mySQL Control Center - Access Denied Problem
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
RE: [SLUG] mySQL Control Center - Access Denied Problem
> 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. I understand that - but I have let my username be accessed from all hosts. And this works from my linux client box, but not my windows client box... -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
RE: [SLUG] mySQL Control Center - Access Denied Problem
Can you get in from the win box using the mysql command line client? I suppose there must be one ffor windows. Martin On Thu, 2003-04-03 at 21:01, Adam W wrote: > > 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. > > I understand that - but I have let my username be accessed from all > hosts. And this works from my linux client box, but not my windows > client box... > > -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] mySQL Control Center - Access Denied Problem
>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
RE: [SLUG] mySQL Control Center - Access Denied Problem
> >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) This has fixed the problem, thanks... It doesn't make sense tho... Webmin was saying user adamw had access from ALL hosts - but obviously hadnt... When I entered in a new user adamw with host % webmin reported ALL for the hosts access just like the first one - but obviously there is a little bug in the mysql webmin module? Thanks Anyway... It has worked nicely... Cheers AW. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug