Java - Mysql
I have a problem connecting to MySQL remotely. I believe I have configured JDBC correctly i.e. extracting the mysql*.jar and setting the enviroment variables for the path.
I can connect to a MySQL database that is on the same machine (Windows XP) as the code I'm executing, however, I wish to conenct to a remote database on a server. I am using the following code to connect to it.
Connection conn = DriverManager.getConnection
("jdbc:mysql://126.96.36.199/mysql", "user", "pasword");
where "188.8.131.52" is the ip address of the server I am trying to connect to. I have tried accessing two different servers running MySQL - a Red Hat Liniux Enterprise 3 Server and a Fedora Core 4 Server and get the same result. I have even tried specifying the port number in the code eg:
("jdbc:mysql://184.108.40.206:3306/mysql", "user", "pasword");
and allowing the port number in SeLinux.
Can anyone help me with this problem, I'm not really sure where the problem lies. It could be in the code as I'm new to connecting to MySQL with Java, or whether it is a firewall problem on the server.
Please help, cheers.
Never mind, problem solved. If anyone else is having this problem, you must grant access to the IP address in mysql. eg:
GRANT ALL PRIVILEGES ON *.* TO 'user'@'12.345.678.90' IDENTIFIED BY 'passsword'
Last Post: 05-13-2005, 06:46 AM
By snowstorm in forum Java
Last Post: 05-04-2005, 01:01 PM
By Rob Abbe in forum Talk to the Editors
Last Post: 01-13-2003, 02:57 PM
By Mike Tsakiris in forum .NET
Last Post: 10-04-2002, 05:32 PM
By JJ in forum Enterprise
Last Post: 07-06-2000, 04:50 AM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL