MySQL & jdbc

[Tom Samplonius]

  When running mysql on the console, it will connect via a named pipe.
The JDBC driver does not support named pipes, and must open a TCP/IP
socket to localhost.

  A common problem is that the MySQL permission tables say "localhost",
but 127.0.0.1 reverse resolves to "localhost.mydomain.com".  


Tom


On 12 May 2003, Anselme wrote:

> Hi everybody !
> 
> I've got a little problem trying to get access to MySQL with a java
> application.
> 
> I use :
> mysql 3.23.55
> linux-sun-jdk1.3.1.07_1
> mysql-jdbc-mm
> FreeBSD 4.7-STABLE
> 
> I got the connection with MySQL vi jdbc without problem but i can't
> access the database as the user  ...
> I got the following from the server :
> 
> #java.sql.SQLException: Invalid authorization specification: Access
> denied for user: 'user_name at localhost.mydomain.com' (Using password:
> YES)
> 
> 
> The rights in MySQL sounds good because when I try to access by the
> console, it's all fine.
> 
> In the java program, I have the following code :
>  dbcxn =
> DriverManager.getConnection("jdbc:mysql://localhost:3306/db_name?user=user_name&password=user_pwd")
> 
> I also tryed with :
> dbcxn =
> DriverManager.getConnection("jdbc:mysql://localhost:3306/db_name","user_name","user_pwd");
> 
> Any Ideas ?
> 
> Thanks 
> 
> -- 
> Anselme <anselme at netcourrier.com>
> 
> _______________________________________________
> freebsd-database at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-database
> To unsubscribe, send any mail to "freebsd-database-unsubscribe at freebsd.org"
> 
>