john976
01-17-2003, 05:10 PM
Hi all. I just made a test with mySql on Windows NT. I created a table with different fields, and I made a Java program to connect with JDBC to that DB. It works if I connect from the same PC where mySql DB is. I used this Java sentence to connect:
.....DriverManager.getConnection( "jdbc:mysql://localhost/......
And it made the query I want.
But I would like that a PC in Internet could connect to that DB. I suppose I must put the IP of the mySql server instead of "localhost" on that sentence, but I got this error:
java.sql.SQLException: Invalid authorization specification: A
cess denied for user: 'a@cable87a004.usuarios.retecal.es' (Using password: YES)
I think I should change something on Winmysqladmin at bind-address (my.ini Setup) ?...I have tried to uncomment bind-address and write the IP of the mySql server, but it doesnt work...
Anyone could help me ?
Thanks
John
.....DriverManager.getConnection( "jdbc:mysql://localhost/......
And it made the query I want.
But I would like that a PC in Internet could connect to that DB. I suppose I must put the IP of the mySql server instead of "localhost" on that sentence, but I got this error:
java.sql.SQLException: Invalid authorization specification: A
cess denied for user: 'a@cable87a004.usuarios.retecal.es' (Using password: YES)
I think I should change something on Winmysqladmin at bind-address (my.ini Setup) ?...I have tried to uncomment bind-address and write the IP of the mySql server, but it doesnt work...
Anyone could help me ?
Thanks
John