Can't connect to MySQL outside Localhost
Posted by: RAM76 (---.min-saude.pt)
Date: August 25, 2010 12:27PM

Hi there!

I am new to the forum and I have been googling for an answer to my problem without success. I surely need your help.

I have Wampserver installed in a computer inside an intranet, I am running a phpBB forum with success and I can access it from everywhere inside my intranet.

I was developing a Java Applet to run in some computers of our network, but I realized that I can not access MySQL from other computers, only from the one where I have Wamp installed.

What do I have to configure to allow MySQL connections from other computers? I haven't changed the port (3306) and my firewall is not blocking it.

For example, I have MAMP installed in my macbook and I can access it from other computers in the same network

Best Regards
Augusto Ramoa

Options: ReplyQuote
Installing ffmpeg-php in wamp
Posted by: ashahmy (112.135.212.---)
Date: August 25, 2010 01:09PM

Please help me install ffmpeg-php in wamp. I was try but it getting error.
Thank You.

Options: ReplyQuote
Re: Can't connect to MySQL outside Localhost
Posted by: RAM76 (---.min-saude.pt)
Date: August 26, 2010 07:11PM

Hi again

I checked if the user had access privileges only from localhost, but that's not the issue. It is defined to access from anywhere (%)

Any ideas??

Options: ReplyQuote
Re: Can't connect to MySQL outside Localhost
Posted by: stevenmartin99 (78.152.203.---)
Date: August 26, 2010 07:53PM

SO how are u connecting.. wheres the code?

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: Can't connect to MySQL outside Localhost
Posted by: RAM76 (---.min-saude.pt)
Date: August 26, 2010 08:13PM

String driver_class_name = "com.mysql.jdbc.Driver";
String user = "queryuser";
String pass = "mypassword";
String url_db_connection = "jdbc:mysql://10.20.216.42:3306/my_dbase";

try {

Class.forName(driver_class_name).newInstance();
Connection con = DriverManager.getConnection(url_db_connection,
user, pass);
java.sql.Statement stmt = con.createStatement();
ResultSet res = stmt.executeQuery("SELECT * FROM my_table"winking smiley;

......


The issue is that wher I run this from the computer where Wamp is installed, it works fine. When I run it from any other computer, it gives me a connection timeout error.

The user queryuser is granted access from any machine.

Thanks!

Options: ReplyQuote
Re: Can't connect to MySQL outside Localhost
Posted by: deinefreunde (---.dsl.pltn13.sbcglobal.net)
Date: September 01, 2010 08:03PM

Hi,

I have a similar problem:

In my local network, I want to run WAMP on my machine as web- and database-server. On a secondary machine I want to run another WAMP server which I only use as a web-server.

My drupal installation then would look for the database-server to connect to mySql. I figured that's a good setup to work on multiple instances of a website using version control.

But when I change the config in drupal to connect to the (remote) computer's database, I get the following error:

Host 'XXXX' is not allowed to connect to this MySQL server.

Firewall is not the issue. Tried this without much success: [willshouse.com]

Thanks!

Options: ReplyQuote


Sorry, only registered users may post in this forum.