Do I need PHP Mysql installed on my computer?

[MarkWFD]

I have an online Mysql database which came with my server space. I have accessed it and populated it with a table that has data in it. I did this via the my provider's 'phpMyAdmin running on localhost-48'. I now want to create a connection to this database through Dreamweaver.
I have gone through the MySQl connection process in DW - entering what seems to be the right info and the connection appears to be about to work.
I get to the stage where it says 'testing connection to database', then it says 'file activity complete' but then I get the message 'an unidentified error has occurred'.
Could this be because I don't have the Mysql installed on my home computer. I assumed that since it is already up and running on the server I wouldn't need to have it on my machine

Thank you very much for your help

m

[Newsgroup_User]

Bladeyflowness wrote:
> I have an online Mysql database which came with my server space. I have
> accessed it and populated it with a table that has data in it. I did this via
> the my provider's 'phpMyAdmin running on localhost-48'. I now want to create a
> connection to this database through Dreamweaver.

You don't need MySQL on your local computer, if you want to use your
remote server for testing. However, setting up a local testing
environment is usually more efficient and secure. It means you can try
things out locally without affecting your online presence. If you have
never used PHP/MySQL before, it's better to make your mistakes in private.

Nevertheless, if you want to use your remote server for testing, you
need to define the testing server correctly in your Dreamweaver site
definition. The value of Host directory in the Testing Server definition
should point to the folder that's your site root (in other words, the
folder that contains your site's home page). The value of URL prefix
must point to the same place, but using the website address.

Host directory: /home/mydomain/www/htdocs/
URL prefix: http://www.mydomain.com/

Dreamweaver uploads a hidden folder called _mmServerScripts to your site
root. You can't see it in Dreamweaver, but you should be able to see it
in your host's control panel or an external FTP program. If it's not
there, you cannot connect.

When creating the MySQL connection in a site, the value for MySQL server
should be exactly the same as your hosting company tells you to use for
the server address. Frequently, it's simply localhost, but some hosting
companies locate the database on a different server, so you need to use
that address.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[MarkWFD]

Thank you very much for your help I have now made the connection via dreamweaver. However, it is not seeing any of the tables on my database - is there any common reason for this
thanks
m
ps sorry about starting the other thread

[Newsgroup_User]

Bladeyflowness wrote:
> Thank you very much for your help I have now made the connection via
> dreamweaver. However, it is not seeing any of the tables on my database - is
> there any common reason for this

The only reason that I'm aware of is related to databases that have a
hyphen or space in the name of the database, or any of the tables or
columns. Hyphens and spaces are illegal unless the name is surrounded by
backticks. Dreamweaver and phpMyAdmin do this automatically, but there
was one version of Dreamweaver (I forget which) that failed to do this.

The problem was corrected in a Dreamweaver updater, so make sure that
you have any available updaters applied to your version of DW. After
applying the updater, you need to replace the hidden scripts. Do this by
going to Site > Advanced > Remove Connection Scripts. The next time you
try to create a connection or recordset, DW should upload the new
connection scripts.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[twindude]

I have been trying to get PHP and MySQL setup on my labtop for a week and even tried some of these all in one xampp & wamp and nothing worked within DW8

sorry for hi-jackin but its a pain.......need to set this up to work with the IIS on my workstation........no good php5 changed some things and just can't get the drivers to work...

[Newsgroup_User]

twindude wrote:
> I have been trying to get PHP and MySQL setup on my labtop for a week and even
> tried some of these all in one xampp & wamp and nothing worked within DW8
>
> sorry for hi-jackin but its a pain.......need to set this up to work with the
> IIS on my workstation........no good php5 changed some things and just
> can't get the drivers to work...
>
http://foundationphp.com/tutorials/php_installer.php

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/