[NBLUG/talk] MySql/JDBC connnectivity issue.

[Mark Street]

How about a host in the URL.

utest
hlocalhost
ptest

Check the grant tables and see which 'hosts' test is allowed to connect to 
your database from...

On Tuesday 20 May 2003 20:17, Mitch Patenaude wrote:
> I can connect to a MySQL database with my test user using the command
> line tools, but when I use the Connector/J JDBC driver to (attempt) to
> connect to a database.  I'm getting refused connections that look like:
>
> mrp at calisto explorer]$ java testGrid
> Connect URL = jdbc:mysql://localhost/trackpoints?user=test&password=test
> java.sql.SQLException: Invalid authorization specification: Access
> denied for user: 'test at localhost.localdomain' (Using password: YES)
>
> (username/password changed in output, but the principal is there.)
>
> After a google search, it appears that I need to add permissions TCP
> connections (the command line tool uses a named pipe).  But I can't
> seem to find how to do this.  Can anybody help?

-- 
Mark Street, D.C.
Red Hat Certified Engineer
Cert# 807302251406074
--
Key fingerprint = 3949 39E4 6317 7C3C 023E  2B1F 6FB3 06E7 D109 56C0
GPG key http://www.streetchiro.com/pubkey.asc