Doug
Member
Registered: 8th Oct 03
User status: Offline
|
Right I have been trying to fix this all day and its really doing my head in now!!
I am trying to set up a connection to my database on my hosting, I am using Dreamweaver CS3 (Tried on Dreamweaver 8 aswell but still get same problem)
Here is the screen where I am entering the details:
Then when I try to search for the database or if I manually enter the database and click test connection I get this error:
Here is a screen shot of the PHPmyadmin page so you can see some of the details about it:
Where am I going wrong?!
I saw in another forum post a possible solution that talks about the OLD password system that dreamweaver use's (but I think they are talking about MX)
Got a full blown headache from this now as I just cant find a answer for it! Housemate is on the same hosting as his works fine. So I cant work out what the problem may be.
If anyone wants to help out in more detail I would be happy to provide my MSN address...
Thanks
Doug
|
drax
Member
Registered: 5th Feb 05
Location: Sittingbourne, Kent
User status: Offline
|
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)
You need the web address of everwhere your hosting / sql database is.
Assuming your not running your sql locally.
[Edited on 30-03-2008 by drax]
|
Nismo
Member
Registered: 12th Sep 02
User status: Offline
|
yeah as drax said you need the server address the name server or IP
|
Doug
Member
Registered: 8th Oct 03
User status: Offline
|
House mate has hosting with the same company so we are doing the same thing here. But his works and mine dosnt 
The MySQL server is localhost on the server as you can see in the phpMyAdmin screen shot
|
Laney
Member
Registered: 6th May 03
Location: Leeds
User status: Offline
|
quote:
Originally posted by Doug
House mate has hosting with the same company so we are doing the same thing here. But his works and mine dosnt
The MySQL server is localhost on the server as you can see in the phpMyAdmin screen shot
Tried 127.0.0.1 ?
Presuming username/pass is right?
|
jamesw
Member
Registered: 28th Jun 02
Location: Station Town, County Durham
User status: Offline
|
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.
Also as it looks as if your using CPanel you will need to setup "remote sql" so your ISP's ip address is allowed to connect to it remotely.
|
Steve
Premium Member
Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
|
according to the address in the phpmyadmin your database is located at
mycarprofile.890m.com
or is your pc acting as the server?
[Edited on 30-03-2008 by Steve]
|
Doug
Member
Registered: 8th Oct 03
User status: Offline
|
I have uninstalled the localhost software from my PC (Was using Sokkit) So I just want to purely use my hosting for the site.
The SQL server and website should be on the same box as phpmyadmin says its on localhost meaning that box.
In cpanel I have set up the remote MySQL connections to be:
%.%.%.%
192.168.0.%
So there shouldn't be a problem connecting too it?
House mate has a hosting account with the same people and his works fine when he sets the MySQL server as localhost then uses his account name and password to connect.
The only difference I can see between us is that I am on server 6 and he is on server 5, cant see that changing anything though.
Really starting to wind me up now. If anyone wants to try setting up the connection using dreamweaver then contact me.
|
jamesw
Member
Registered: 28th Jun 02
Location: Station Town, County Durham
User status: Offline
|
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
Member
Registered: 8th Oct 03
User status: Offline
|
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?
I tried with dreamweaver 8 aswell earlier as I didnt uninstall that since installing CS3 aswell. I got the same problem
|
Dom
Member
Registered: 13th Sep 03
User status: Offline
|
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.
I've had similar problems with dreamweaver and never did manage to solve it.
|
Doug
Member
Registered: 8th Oct 03
User status: Offline
|
Im starting to think that may be the best course of action actually....
I just dont see why I can connect via FTP in DW fine. But I cant connect to the SQL DB's
|
jamesw
Member
Registered: 28th Jun 02
Location: Station Town, County Durham
User status: Offline
|
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
Member
Registered: 8th Oct 03
User status: Offline
|
I am assuming the 'Testing Server' should be my FTP account details and point to public_html/ ?
|
jamesw
Member
Registered: 28th Jun 02
Location: Station Town, County Durham
User status: Offline
|
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
Member
Registered: 8th Oct 03
User status: Offline
|
Can you see any problems in there?
|
Doug
Member
Registered: 8th Oct 03
User status: Offline
|
Sorted! you can see the problem in the third picture. the URL prefix!
|
