Next in line to test is the firewall. Does the box with the database
accept connections on port 3306?6
-- David
On Jun 8, 2010, at 8:24 AM, Will Scheidegger <[email protected]>
wrote:
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]>
----------------------------------------------------------------
----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <[email protected]>
----------------------------------------------------------------
