Re: [newbie] local connection failure




"Guldo K" wrote...

> I've a newbie-question I'd like to ask...
> I've searched the archive with no luck...
> I can't establish a connection within my local machine.

[snipped Java code]

> but I get an error message like this:
> Host 'debian' is not allowed to connect to this MYSQL server
> (where 'debian' is my localhost) on the getConnection call.
>
> My user can connect to my local mysql server from any host.
> (table 'user' in the 'mysql' database)
>
> What's wrong?

I believe it doesn't have anything to do with Java or JDBC at all, but with
your configuration of MySQL.

AFAIK you have to acknowledge each user in a certain pattern in the MySQL
configuration, as in user@host.

I suggest you look into how you have configured the access rights for the
user "myLogin" or what you have called it.


// Bjorn A


.



Relevant Pages

  • [newbie] local connection failure
    ... I can't establish a connection within my local machine. ... Host 'debian' is not allowed to connect to this MYSQL server ... My user can connect to my local mysql server from any host. ...
    (comp.lang.java.databases)
  • Wordpress Multiple Blog Configuration
    ... multiple blogs, but no instructions as how to accomplish that. ... A little more about the configuration ... This allows you to host more than one blog on a Debian ...
    (Debian-User)
  • Re: OS X & Debian LAN [was: Mac OS X and Debian Linux LAN research.]
    ... I've got /netatalk/ installed and minimally configured on Debian and set all the appropriate switches in OS X, and I can look at and move files back and forth from either box if I initiate the server on my Mac. ... I've got a Belkin 4 port router and my Mac's host name shows up in its configuration, but the Debian box host name there is blank. ...
    (Debian-User)
  • MySql remote connectiion / access host problem.
    ... I have a connecting problem with a MySql server running on Redhat Linux. ... 'Access Host' list, which I have done. ... When I open a telnet connection to the server's IP address on the MySql ... port of 3306 I get NO RESPONSE from the server resulting in telnet giving ...
    (comp.os.linux.networking)
  • MySql remote connectiion / access host problem.
    ... I have a connecting problem with a MySql server running on Redhat Linux. ... 'Access Host' list, which I have done. ... When I open a telnet connection to the server's IP address on the MySql ... port of 3306 I get NO RESPONSE from the server resulting in telnet giving ...
    (comp.os.linux.networking)