|
Not logged in [Login - Register] |
You Are Not Registered Or Not Logged In |
Corsa Sport » Message Board » Off Day » Geek Day » MySQL Connection Problem » Post Reply
|
Doug |
posted on 30th Mar 08 at 19:22 |
Sorted! you can see the problem in the third picture. the URL prefix! | |
Doug |
posted on 30th Mar 08 at 16:05 |
| |
jamesw |
posted on 30th Mar 08 at 15:57 |
you dont really *need* to setup the testing server stuff, for one of my sites i have set testing server as the same ftp as production, but set the folder to public_html/test | |
Doug |
posted on 30th Mar 08 at 15:54 |
I am assuming the 'Testing Server' should be my FTP account details and point to public_html/ ? | |
jamesw |
posted on 30th Mar 08 at 15:44 |
doug - i was getting the exact error you were getting but then managed to get further, after the failure at the top right, it should have 4 steps to setup a connection set 1 should be create a site for the connection, i clicked on this and it gave me details of the site I was already in, after i clicked OK, it would let me go further and testing the connection would work | |
Doug |
posted on 30th Mar 08 at 15:44 |
Im starting to think that may be the best course of action actually.... | |
Dom |
posted on 30th Mar 08 at 15:38 |
would be easier to develop on your own system (using wamp or something) and then just upload the DB and PHP to live server for final testing. | |
Doug |
posted on 30th Mar 08 at 15:34 |
It makes me think that the problem is my end, if the house mate can connect to his hosting and database fine then I am struggling to see why I cannot? | |
jamesw |
posted on 30th Mar 08 at 15:32 |
ignore me mate im talking out of my arse, just tried it myself (also using dreamweaver cs3 and a cpanel box) It appears putting localhost in that box should work, as it seems to run the sql queries on the box its self rather than on your machine. However in the process have ballsed up a cpanel account lol - bare with me going to recreate the account and see if I get further this time. | |
Doug |
posted on 30th Mar 08 at 15:24 |
I have uninstalled the localhost software from my PC (Was using Sokkit) So I just want to purely use my hosting for the site. | |
Steve |
posted on 30th Mar 08 at 15:06 |
according to the address in the phpmyadmin your database is located at | |
jamesw |
posted on 30th Mar 08 at 14:50 |
when the php page is parsed on the server its fine the address being localhost as the sql server should be on same box as the http server, however running any queries from your PC it will think the sql server is also on your PC. In the MYSQL server text box place the domain name, or IP address of the server your on. | |
Laney |
posted on 30th Mar 08 at 14:50 |
quote: Tried 127.0.0.1 ? Presuming username/pass is right? | |
Doug |
posted on 30th Mar 08 at 14:31 |
House mate has hosting with the same company so we are doing the same thing here. But his works and mine dosnt :( | |
Nismo |
posted on 30th Mar 08 at 09:11 |
yeah as drax said you need the server address the name server or IP | |
drax |
posted on 30th Mar 08 at 05:05 |
Erm the fact that Local host will look on your computer / network (what ever local host is set to in your hosts file usually 127.0.0.1) | |
Doug |
posted on 29th Mar 08 at 22:19 |
Right I have been trying to fix this all day and its really doing my head in now!! |