MySQL, and PHPMYADMIN with WAMP on port 81

Report · Nov 14, 2007

I installed WAMP at port 81 because SQL Server is running on the default port 80 (non-networked, home-office, XP system.)

I created a MySQL database using PHPMYADMIN. Now I need to connect to it using Dreamweaver (CS3):

Connection name: connMinding
MySQL server: localhost:81
Username: root
Password:

When I hit the SELECT button, DW goes off to test the database connection, takes forever doing it, and then I get a server timeout message. Since the server is up and running, the message gives an alternative that suggesting the ODBC DSN doesn't exist on the testing server.

Does anyone know how I should be doing this? What MySQL Server?

Thanks.

Report · Nov 14, 2007

.oO(Minding)

>I installed WAMP at port 81

"WAMP" is just a common name for a bundle of software. It contains at
least two servers which have to listen on different(!) ports: the web
server Apache (usually 80) and the database MySQL (usually 3306).

There are many different WAMP distributions available. Which one do you
use?

>because SQL Server is running on the default port
>80 (non-networked, home-office, XP system.)

Port 80 is reserved for HTTP and should not be used for anything else.
You should check your configuration (and adjust if necessary).

> I created a MySQL database using PHPMYADMIN. Now I need to connect to it using
>Dreamweaver (CS3):
>
> Connection name: connMinding
> MySQL server: localhost:81
> Username: root
> Password:
>
> When I hit the SELECT button, DW goes off to test the database connection,
>takes forever doing it, and then I get a server timeout message.

What is really listening on port 81 - the web server or the database
server? What happens if you call < http://localhost:81> in your browser?
Do you get a response? What happens if you omit the port in DW's DB
configuration?

Micha

Report · Nov 15, 2007

True enough.

I got mine at wampserver.com.

And, not incidently, localhost:3306 worked. So my thanks to you.