Re: Remote Connection, please help

[Mark Matthews]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Muhammad Salman wrote:
> Dear Mark, real thanks , Are you refering to this
> issues:
>
> Issue:
>
> "When I try to connect to the database with MySQL
> Connector/J , I get the
> following exception:
>

Yes.

[snip]
>>>Thanks Mark for your real quick response. The
>>
>>error I
>>
>>>am getting is when I try to connect with the
>>
>>machine's
>>
>>>ip is :
>>>
>>>Invalid authorization specification: Access denied
>>
>>for
>>
>>>user:
>>>'***********@******'
>>>(Using password: YES)
>>>
>>>But when I connect it with localhost instead of
>>
>>the ip
>>
>>>I am able to connect to MySQL, by putting the code
>>
>>on
>>
>>>the same machine. This machine has several
>>
>>databases

Your permissions are not setup correctly. You need to add GRANTs to allow this to happen as it appears that none currently exist that do allow it.

You need to do a "GRANT [foo] ON [blah] TO 'user'@'host' identified by 'some_password'" to get this to work. I am deliberately leaving out what you need to put in for [foo] and [blah], because you _really_ need to read the MySQL manual (http://www.mysql.com/doc/en/GRANT.html) and understand exactly what you're doing here.

-Mark
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE9+N9WtvXNTca6JD8RAtpRAJ9+mZRg4gudtabx3yREo2RD+tNj/wCeKuOJ
KeCv39g/Agxk4WG1m0PGFXo=
=LyU/
-----END PGP SIGNATURE-----


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php