Dreamweaver issue creating MySQL connection..

I wasn't able to view the thread earlier.. thanks for all the reply's.

Have you ensured on the hosting side that your own IP address is allowed.

I have a QNAP server that I have running MySQL on behind a router so the IP it should be seeing is a 192.x.x.x address which is currently permitted. I may be incorrect in this assumption and need to add my external IP address since all traffic goes out and then comes back in.

It is currently running an older version of MySQL (5.1.73) but this is being used for testing purposes only.

If you can't connect to a local setup of MySQL, there's some set up isse, is MySQL definately running? Whats your loal setup, is it WAMP or some other package?

I simply installed MySQL on my Windows desktop and am currently able to login and run queries, setup tables, etc.

Also in your screenshots, have you left the databse name empty when attempting to connect to remote database? .....Also on your local set up of MySQL have you set up the user with the desired password?

I've tried both options, using the "Select" and adding the actual DB name both with similar results.

Its possible that the code Dreamweaver creates is out_of_date and is using mysql (deprecated) to connect to your server which uses more up-to-date functionality - mysqli or PDO.

So this is interesting, is CS6 simply trying to use the connect information from some sort of PHP page to try and connect? Is it possible to view that information?

Get some simple mysqli or PDO connection code by Googling for it, it will only be a couple of lines. Go to the url below, copy the bit of code into a .php file, obviously change the connection details. View in browser. If the page fails to connect you should see an error message.

I will try this as soon as possible.

#1 You should NOT be using the deprecated server behaviors in DW CS6. SBs were removed from DW CC for a reason.  The code is not secure, it's outdated and the old MySQL connection strings won't work on server's running PHP 7 or higher.

Not using it is creeping up fast on my list, thanks for highlighting.

#1 You should NOT be using the deprecated server behaviors in DW CS6. SBs were removed from DW CC for a reason.  The code is not secure, it's outdated and the old MySQL connection strings won't work on server's running PHP 7 or higher.

#2  Create a .php file called info.php with the following code.  Upload to your remote server to test.  This will tell you whicfh version of PHP your server has.

<?php

$con = mysqli_connect("localhost","your_username","your_password","your_database_name");

// Check connection

if (mysqli_connect_errno())

  {

  echo "Failed to connect to MySQL: " . mysqli_connect_error();

        }

        else echo "Successfully connected, happy coding!"

?>

<?php phpinfo() ?>

Ideally, your remote server and local testing server should contain the same versions of MySQL and PHP.

Its possible that the code Dreamweaver creates is out_of_date and is using mysql (deprecated) to connect to your server which uses more up-to-date functionality - mysqli or PDO.

Get some simple mysqli or PDO connection code by Googling for it, it will only be a couple of lines.

Add the code to a .php page and view the page via a browser.

If that connects then its a problem with Dreamweaver.

Go to the url below, copy the bit of code into a .php file, obviously change the connection details. View in browser. If the page fails to connect you should see an error message.

PHP mysqli_connect() Function

.....Also on your local set up of MySQL have you set up the user with the desired password? If no user has been been set up, try setting  username to root and leave the password empty and see if that connects to MySQL locally. IF it doesn't then its likely MySQL is not running.

I'm assuming here you are trying to connect to MySQL at your web host remotely?

What have you got in the MySQL Server field in Dreamweaver?

Also, you may want to check with your host that they allow remote connections to MySQL, most do not but if you have CPanel for example there is usually in the DB managenet section of CPanel a section called 'Remote MySQL' which you would need to add your IP to.