logo-dw

Go Back   Dreamweaver Club Forums > Dreamweaver forums > Web Hosting and FTP
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 05-18-2009, 04:49 AM   #1
kuasadmin
 
Join Date: May 2009
Posts: 4
Unhappy Cannot Access database online

I am using DWCS3, with Xampp 1.7.1.
I have managed to set it up locally and everything is working fine with localhost. I have managed to also FTP my files onto my website online and ran it without any problems at all except for the Database connection.
On the localhost I managed to connect to my database, with my search and result.php query but when I sent my files online and ran the same thing it couldn't find my database. I have already dumped my database sql and imported it online, I can see it on MyPhpAdmin.
What else do I need to do? What is my testing server supposed to be, not sure if this is supposed to be linking locally or on FTP?
Any help is appreciated.
kuasadmin is offline   Reply With Quote
Old 05-18-2009, 05:05 AM   #2
edbr
edbr's Avatar
 
Join Date: Aug 2005
Location: Bali
Posts: 11,164
Default

your testing server is what it is named for you test before putting live your database on your online server will have different connection settings password and username. Have you changed this connection correctly?
__________________
If you're happy and you know it shake your meds!
different style links examples

Flight / Hotel search
Free script download
Bali Villas
edbr is offline   Reply With Quote
Old 05-18-2009, 10:37 PM   #3
kuasadmin
 
Join Date: May 2009
Posts: 4
Post

Okay I am not sure what to change it to? Okay if my website is
e.g http://www.bestas.com and my root folder is in public_html folder.
When I am working on my dreamweaver I set to localhost as follows;

Local Info:
local root folder - c:\xampp\htdocs\web1\
images folder - c:\xampp\htdocs\web1\images\
Links relative to Document (selected)
HTTP Add: http://localhost/

Remote Info:
Access - FTP
FTP Host: ftp.bestas.com
host Dir: public_html/
login: mylogin
password: mypass
also used passive FTP
tested and it worked

Testing Server:
Server Mode - PHP MYSQL
Access: Local/network
testing server folder: c:\xampp\htdocs\web1\
URL Prefix: http://localhost/kuaonline

All the above works fine when I am running locally, but how do I set or where do I need to change to have it working online?
I have my cpanel password, and also my MyPhpAdmin password. Where do I need to use this on dreamweaver?
As I said I uploaded all my files online and tried running the search and results.php but it didn't work?
Appreciate your help..
kuasadmin is offline   Reply With Quote
Old 05-18-2009, 10:39 PM   #4
kuasadmin
 
Join Date: May 2009
Posts: 4
Post

Oh forgot to add MySql Connection locally:
connection name: dbconnect
MYSQL Server: Localhost
username - admin
password - pass
database - test
This was connected locally not online though.
kuasadmin is offline   Reply With Quote
Old 05-19-2009, 01:18 AM   #5
edbr
edbr's Avatar
 
Join Date: Aug 2005
Location: Bali
Posts: 11,164
Default

right theres you problem then.
your local server will be different.
you must add a user to your online database with a pass word and give that user permissions. There will be a msql manager on your server to allow you to do this, its not difficult.
then you must change your settings to this connection , you will be given add details when you add a user.

probably something like
Code:
MYSQL Server:localhost
username - server_username
password - password
database - server_test
you own details of course
__________________
If you're happy and you know it shake your meds!
different style links examples

Flight / Hotel search
Free script download
Bali Villas
edbr is offline   Reply With Quote
Old 05-19-2009, 02:12 AM   #6
kuasadmin
 
Join Date: May 2009
Posts: 4
Default

I got it!!! Thanks alot.. It was just a mix up with my username database name and the MySQL Server localhost name.
Ur the Greatest!!
kuasadmin is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:53 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com