Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

2006-06-08 Thread Aron Levy
Thank you very much James, i flush the privilegies and restart the mysql service and all result fine :-) I can access from anyhost Aron L. James Barros wrote: Can this use log in from localhost successfully? Try flushing privileges again? If that failed, I'd drop the user and recreate? (

ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

2006-06-07 Thread Aron Levy
Hi good afternoon, i am triying to connect with my company's mysql server using a client program from shell and I keep receiving the following answer: [EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com Enter password: ERROR 1045 (28000): Access denied for user 'user1'@'200.93.42.209'

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

2006-06-07 Thread James Barros
Well, for starters don't worry about ports being open. If you werent able to connect, it would give you a different error message. select password('yourpassword'); and verify that the hash produced matches the password field in user exactly. -- James On Jun 7, 2006, at 11:48 AM, Aron

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

2006-06-07 Thread Aron Levy
Hi James i follow your recomendation and verify that the hash produced matches the password field in user exactly. -- Aron L. James Barros wrote: Well, for starters don't worry about ports being open. If you werent able to connect, it would give you a different error message. select

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

2006-06-07 Thread Daniel da Veiga
On 6/7/06, Aron Levy [EMAIL PROTECTED] wrote: Hi James i follow your recomendation and verify that the hash produced matches the password field in user exactly. -- Aron L. Well, that's weird, should be working. A shot in the dark: try starting your server with --old-passwords as an option

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

2006-06-07 Thread James Barros
Can this use log in from localhost successfully? Try flushing privileges again? If that failed, I'd drop the user and recreate? ( Theres really not alot to this, sorry I don't have any more ideas :( ) -- James On Jun 7, 2006, at 1:07 PM, Aron Levy wrote: Hi James i follow your recomendation