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
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