Date: Mon, 12 May 2003 13:03:15 +0200 From: Roberto Nunnari <nunnari@die.supsi.ch> To: Anselme <anselme@netcourrier.com> Cc: freebsd-database <freebsd-database@freebsd.org> Subject: Re: MySQL & jdbc Message-ID: <3EBF7F73.1090502@die.supsi.ch> References: <1052736418.280.23.camel@Toto.dippgw.homedns.org>
next in thread | previous in thread | raw e-mail | index | archive | help
if this doesn't work:
# mysql -u username -p yourdbname
then check your mysql user table:
> use mysql;
> select host, user, password from user;
you should have an entry for username@localhost with password
Anyways, in my java code I use:
getConnection( "jdbc:mysql://localhost/mydbname", "myusername", "mypassword" );
regards.
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@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
>
--
Roberto Nunnari -software engineer-
mailto:nunnari@die.supsi.ch
Scuola Universitaria Professionale della Svizzera Italiana
Dipartimento di Informatica e Elettronica
http://www.die.supsi.ch
SUPSI-DIE
Via Cantonale tel: +41-91-6108561
6928 Manno """ fax: +41-91-6108570
Switzerland (o o)
=======================oOO==(_)==OOo========================
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3EBF7F73.1090502>