How does authentication works with MYSQL??????

[Siomara Pantarotto]

Can someone PLEASE explains how MySQL does authentication remotely

After installing MYSQL I created a user root with xyzxyz password. The 
database allowed that.

When I connect Mysql, via java codes, from the same machine it works 
perfectly.

When I connect Mysql, via java codes, from a remote machine it does not 
work. How come  the user is the same, the IP address is the same...

It's getting confused with the original root user Iguess.

Can someone give a hint on this???

Thanks

Siomara


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-
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

How does authentication works with MYSQL??????

[Christopher Book]

Look at the 'grant' commands in the mysql manual.  You have to setup
permissions if you want other hosts (other than localhost) to work, by
assigning permissions to all domains or a list of ips or something.  Its
pretty complicated, but if you just want to give one user access from
anywhere its not so bad.

Chris

When I connect Mysql, via java codes, from a remote machine it does not
work. How come  the user is the same, the IP address is the same... 


-
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