[TW.87]

I am running WAMP5 1.5.0 on my computer, and am using it as a testing environment as I build various websites. When I access the "http://localhost/" address through a browser, such as Internet Explorer, and I access a ".PHP" page, there are no problems. It displays the page in the browser correctly and without any issues.

However, on one of the pages, I am trying to access a MySQL database that is currently located on a live server. When I upload the page and view it live, it all works correctly, and it accesses and uses the database as it should.

However, when I view it through "http://localhost/", it displays this message:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'id294759_News'@'localhost' (using password: YES) in c:\documents and settings\Primary\Desktop\local server\Website\Home\Home\Home(Home).php on line 262
MySQL Error: 1

How can I make the local page access the live MySQL database, or, at least, how can I replicate the MySQL database locally, somehow, to make it display the information?

[php guy]

If your host has cPanel, you can download your database and add it to your local mysql

[TW.87]

Originally Posted by php guy

If your host has cPanel, you can download your database and add it to your local mysql

My server provider is using cPanel, so I have a copy of the MySQL database ready to use.

Can you describe, in detail, how I can add it to my local MySQL?

[php guy]

The easiest way would be to make a php page like "adddb.php" or some name, connect to your DB, then copy all the SQL from the download and run it on your db, assmuning you know the basics of connecting to mysql with php.

[TW.87]

I know how to connect a ".PHP" file to a database on a live server, but I have no idea if, or how, I have a MySQL configuration locally.

I'm not sure on how to set-up a local MySQL database.

[php guy]

Oh, I assumed you had mySql installed localy already.

To install it localy, go to this site, http://www.webmasterstop.com/48-2.html

It has a very good step by step process to install mySql on your local machine and config it to work with php.

[TW.87]

Okay, I've just installed MySQL and I followed the instructions that were on that page.

How can I now make that work with my website that I am developing in WAMP5 1.5.0?

[php guy]

Ohh, WAMP5, I never worked with that before. Do you have to use WAMP5 or would you be able to install apache?

[TW.87]

I don't really mind what I have to do if I can get this to work the way I'd like to.

What's the procedure in installing Apache?

[php guy]

http://www.webmasterstop.com/48-1.html give you a step by step process on installing everything you need to have an effecent local testing enviorment. Once you installed apache, you can skip past the mysql part since you already did that.

[TW.87]

Originally Posted by php guy

http://www.webmasterstop.com/48-1.html give you a step by step process on installing everything you need to have an effecent local testing enviorment. Once you installed apache, you can skip past the mysql part since you already did that.

Thank you...I'll give that a go and see what happens!