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?
(
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'
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
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
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
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