Jqueru course and setting up local server (WAMP)

[tobeeornot]

I’m currently doing a Learn Jquery in 30 days course and have hit a snag. Lesson 25 uses a local server (WAMP/MAMP) to run some dynamic code but after set up I am getting an error message and I am not sure why. I have used this process before to successfully create mock WP sites using Dreamweaver and used the following steps which should apply again, I think:

1 – Start MAMP. You should see the start up page. Leave it open.
2 – Create a site root folder for your site in applications/MAMP/htdocs/.
3 – Define a new site in dreamweaver.
4 – In “local info” point everything to the folder you created in the htdocs folder. The http address should be this.

http://localhost:8888/your-site-folder/

5 – in “remote info” choose Local/Network from the access menu. Point the remote folded to the folder you created in the htdocs folder.
6 – in “testing server” choose PHP/mySQL under server model, Local/Network from the access menu and testing server to he folder you created in the htdocs folder. The URL prefix should look like this.

http://localhost:8888/your-site-folder/

7 – Hit OK then Done.

I want to set this up locally so please don’t tell me to run it on a live server. I also know most you aren’t DW fans but I am where I am, and would appreciate your help. I can’t go any further on the course until I complete this tutorial.

[tobeeornot]

Hi Karl, thanks for replying. I just checked and the password for the db I created is root, which corresponds to the code in the functions.php page in the exercise files.

[tobeeornot]

Yes, that is the file. I just checked the privileges for the sakila db in phpMyAdmin and they all seem to set to ‘root’, which is the default I think. It is all in lower case as well. Would a screen shot of the phpMyAdmin be any good to you?

[tobeeornot]

Ok, so just to be sure I changed all the passwords for all specified users to ‘root’ and rebooted wamp. No luck.

Screenshot

[tobeeornot]

Nope – doh! I had a good feeling about that.

[tobeeornot]

like this?

$pdo = new PDO("mysql:host=127.0.0.1;dbname=sakila", "root", "root");

$pdo = new PDO("mysql:host=localhost;dbname=sakila", "root", "root");

[tobeeornot]

nope…i reset all the passwords to ‘root’ for the three users and rebooted. No luck.

Out of interest – have you tried using the exercise files on your end?

[tobeeornot]

from i what i can see, they are essentially saying the same thing – change/reset the user passwords for the database.

[tobeeornot]

Regrettably no. Thanks for your help, man. I don’t want to waste your time…this is driving me mental!

[tobeeornot]

Set all the passwords blank on the db and the functions.php file but no dice.

[tobeeornot]

Thanks for being patient, Karl – I’ll give it a try a bit later. I need to have a break from this for a few hours before I go nuts.

[Author]

Posts