Thanks Gregory and David! I guess I misunderstood the concept of the @-part of
the username. I thought this would be the server where the user has access to,
not the host from where he/she is allowed to access the db. Anyway, what I did
now was
grant all on mag_cms.* to 'magnolia'@'mag.server.ip.no'
Then I tried again from "mag.server.ip.no":
Connection conn =
DriverManager.getConnection("jdbc:mysql://212.103.75.242:3306/mag_cms",
"magnolia", "password");
conn.close();
Still, same java.net.ConnectException: Connection refused!
Any other ideas what I could test?
Thanks!
-will
On 08.06.2010, at 13:46, Grégory Joseph wrote:
>
>
> On Jun 8, 2010, at 11:55, Will Scheidegger wrote:
>
>> grant all on mag_cms.* to 'magnolia'@'localhost';
> <...>
>> DriverManager.getConnection("jdbc:mysql://serverip#:3306/mag_cms",
>> "magnolia", "password");
>
> There's the problem. You're granting access via localhost, but access the
> server - either remotely or locally but via ip.
>
> -g
>
>
> ----------------------------------------------------------------
> For list details see
> http://www.magnolia-cms.com/home/community/mailing-lists.html
> To unsubscribe, E-mail to: <[email protected]>
> ----------------------------------------------------------------
>
----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <[email protected]>
----------------------------------------------------------------
