Re: Help for a newbee please!

From: Chris Hatton (chrishatton_at_blueyonder.co.uk)
Date: 12/15/04 

Date: Wed, 15 Dec 2004 16:46:40 +0000

kaeli wrote:

> In article <41c045e2$1@nntphost.cis.strath.ac.uk>,
> chrishatton@blueyonder.co.uk enlightened us with...
>
>>I'm having problems trying to connect to a remote mySQL db. I have have
>>got this working on localhost but can get it to work for my website db.
>>
>>Can anyone point out problems with the code or general problems I shoudl
>>be looking out for?
>
>
> What's the error you're getting?
>
> To see better, more detailed error messages, print out e.getMessage() and do
> a e.printStackTrace() here, instead of just rethrowing the error.
> For a website, you may need to grab the output stream instead of using
> System.out. How to do that depends a bit on whether you're using JSP/beans
> (you'd need to pass JSPWriter response in or set a property in the bean or
> throw it to a custom error page) or a servlet (you can just write to
> response).
>
>
>
>> } catch ( java.sql.SQLException e ) {
>> System.out.println("Connection couldn't be established to " + url);
>> throw ( e );
>> }
>> }
>
>
This is the error I am getting but it doesn't mean much to me:

MySQL Driver Found
Connection couldn't be established to
jdbc:mysql://www.tattooplace.co.uk/tattoop
_chatusers

Invalid authorization specification message from server: "Access denied
for user
: 'tattoop_chris@82-40-66-187.cable.ubr09.uddi.**ueyonder.co.uk' (Using
password
: YES)"

java.sql.SQLException: Invalid authorization specification message from
server:
"Access denied for user:
'tattoop_chris@82-40-66-187.cable.ubr09.uddi.**ueyonder
.co.uk' (Using password: YES)"
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1906)
         at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:954)
         at com.mysql.jdbc.Connection.createNewIO(Connection.java:1786)
         at com.mysql.jdbc.Connection.<init>(Connection.java:450)
         at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:411)
         at java.sql.DriverManager.getConnection(DriverManager.java:512)
         at java.sql.DriverManager.getConnection(DriverManager.java:171)
         at TestMySQL.getConnection(TestMySQL.java:71)
         at TestMySQL.test(TestMySQL.java:20)
         at Driver.main(Driver.java:7)
Press any key to continue...

Relevant Pages

  • mysql credentials?
    ... I am running core 3, and trying to execute the following commend: ... Invalid authorization specification message from ... server: "Access denied for user: 'root@kt.lctn.org' (Using password: ...
    (Fedora)
  • Re: Web hosting reccommendations
    ... PHPMyAdmin available with just a click. ... I was going to go with them, but choose GoDaddy since the company I do coding for uses them and it seemed like a logical choice for a development server. ... Make sure the host allows REMOTE MySQL access if you plan on using and external admin like SQLyog or such. ... Thus far it seems like there have been two suggestions, HostGator and Lunarpages. ...
    (comp.lang.php)
  • Sudden Inability To Use SQL
    ... components that connect to a remote mysql db for. ... Radius can no longer work cause it cannot contact sql server. ... Now the server can telnet into the remote port of the mysql server, ... I had a look at the server status to see mysql connections. ...
    (freebsd-questions)