I'm completely new to PHP & mySQL. I've created dozens if not hundreds of web sites over the years, but have never needed to ceate a dynamic site from scratch. Now it looks as though I need to learn this stuff though!
I've deliberately created a new web site on my Westhost space using dreamweaver in order to learn how to do it.
I've installed mySQL, PHP and PHPMyAdmin into my site in the site manager.
I've created a very simple database using phpmyadmin, and I've also altered the root priveliges to allow root access from anywhere - again in phpmyadmin.
However, I can't connect to this database from dreamweaver, and it's driving me absolutely spare! I've been trying for weeks and can't nail it.
The local and remote settings are fine, I've had westhost web space for donkeys years.
The Testing server settings are as follows:
Server Model: PHP MySQL
FTP Host: the same as in local - ftp.mydomain.com
Host directory: usr/local/mysql/
Password: mySQL root password, not the domain password!
URL Prefix: I've tried just about everything in here but I reckon it should be '/'
I get the same error message:
"The URL prefix / for the sites testing server could not be resolved. This could be for the following reasons:
1 You have specified a root folder that that does not fall under the web server root folder.
2 There is no web server running on the URL.
3 There is a web server running but no virtual web folder has been mapped to this prefix."
Any clues anybody? I don't mind learning new stuff, or a bit of trial & error, but to spend weeks and not get past the first hurdle? I've read just about every manual on westhost, mysql, php, etc., most of the posts in this forum & the tutorials that they recommend.
Is it really time to hang up the keyboard & get a job as a roadsweeper?