"A server timeout has occurred" error connecting Dreamweaver to MySQL

Question

I am trying to connect my website to MySQL on localhost under WAMP.

Whenever I enter my details in the MySQL connection tab and click "databases", it crashes and gives me the error:

A server timeout has occurred. Here are the possible reasons.

Please make sure that the web server is up and running.
Please verify that the ODBC DSN exists on the testing server.

The web server is up and running but I'm not sure how to do the second step. I also changed the ports to 81 so not sure if I messed something up in doing that.

I also know to this and these forums so thanks for your help :)

Did you change your config file to listen on port 81? PHP on WAMP usually runs on port 80. — Vbudo, Mar 19 '17 at 04:01
Do you mean you changed the MYSQL Listening port to 81 or the Apache Listening port to 81? Or did you change both to 81??? — RiggsFolly, Mar 19 '17 at 17:17
I changed the Apache Listening port to 81. Do both need to be changed? — Louis, Mar 19 '17 at 19:56
Is the PHP tag relevant? It feels you want to connect your IDE to MySQL, not a PHP script :-? — Álvaro González, Mar 20 '17 at 10:48

score 0 · Answer 1 · edited Mar 20 '17 at 12:01

0

I found the problem!

When I was setting up the database connection, for the MySQL option I was including the apache port.

For anyone else with the same problem, make sure you just have localhost as opposed to localhost:8888

What I'm talking about

Seems so obvious now.

edited Mar 20 '17 at 12:01

Álvaro González

142,137
41
261
360

answered Mar 20 '17 at 10:41

Louis

40
8

Is this part of your PHP application or a dialog from Dreamweaver? – Álvaro González Mar 20 '17 at 12:02

"A server timeout has occurred" error connecting Dreamweaver to MySQL

1 Answers1