Re: Connection Problem JDBC
From: Ike (rxv_at_hotmail.com)
Date: 12/30/03
- Next message: Heinz Dittmann: "Re: Problem connecting Oracle with Tomcat 5.0"
- Previous message: Sampsa Sohlman (Do not reply to this address): "Re: JDBC/ODBC user issues accessing SQL Server 2000 database"
- In reply to: Paul L: "Connection Problem JDBC"
- Next in thread: Paul L: "Re: Connection Problem JDBC"
- Reply: Paul L: "Re: Connection Problem JDBC"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 30 Dec 2003 14:02:08 GMT
check your connection string...I'll bet you are using 'localhost' in it,
instead of the internet address of your suse box. presently, you musthave it
set to something like "jdbc:mysql://"+server+.." where 'server' is being set
as 'localhost' and you need to set it to the server name on the
network. -Ike
"Paul L" <NO_SPAM@rogers.com> wrote in message
news:%cEHb.188136$ea%.59029@news01.bloor.is.net.cable.rogers.com...
> Hello, All
>
> I installed mysql server on my suse box. I am trying to connect to it
> through java jdbc application. The
> program does connect to suse server when I run it on localhost. But when I
> run this program from outside
> it gives me "java.sql.SQLException: Invalid authorization specification,
> message from server: "Access
> denied for user: 'ttnm@127.0.0.1' (Using password: YES)". Here is how I
set
> the user table:
>
> +--------------+----------+------------------+
> | Host | User | Password |
> +--------------+----------+------------------+
> | 127.0.0.1 | ttnm | 12c62d5f3ca21044 |
> | % | ttnm | 12c62d5f3ca21044 |
>
>
> The % sign should allow user "ttnm" to connect to server from outside I
> believe but Access is denied...
>
> Does anyone have any ideas on what I am doing wrong?
>
> Thank you in advance!
>
>
>
>
>
- Next message: Heinz Dittmann: "Re: Problem connecting Oracle with Tomcat 5.0"
- Previous message: Sampsa Sohlman (Do not reply to this address): "Re: JDBC/ODBC user issues accessing SQL Server 2000 database"
- In reply to: Paul L: "Connection Problem JDBC"
- Next in thread: Paul L: "Re: Connection Problem JDBC"
- Reply: Paul L: "Re: Connection Problem JDBC"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
