Webmatrix fails to connect PHP to MySQL-Collection of common programming errors

11 years ago
admin
1 minute

Hi,

I’m totally new to PHP, SQL, and web developing in genral.

I started off with downloading latest versions of PHP, Webmatrix (Webmatrix2) and MySQL Server (5.1), and got stuck at the point where I need to use a table (Data Base): for some reason I fail to connect to MySQL.

  1. I downloaded a PHP-MySQL Connector: http://dev.mysql.com/downloads/connector/php-mysqlnd/ –  “MySQL Connector Net 6.5.4”
  2. In Webmatrix, in the “Databases” Workspace I pressed “New Connection” button and choose “MySQL Connection”
  3. In the Dialog box I filled-in all connection details

–> It looks like the database was added (on the left).

But then when I double-click on the database, I get a short error message saying it fails to connect.

I tried everything, searched the web… I’m sure it’s a very simple question, so please whoever can help I’ll be grateful. I think best solution for me would be if someone could please just give me a link to download of: Webmatrix,MySQL,Connector; and instructions on how to install and then how to connect. This would be the safest way to help me.

Thanks a lot in advance,

Roni

[email protected]