Home > Archive > PHP Language > May 2006 > MySQL and external host- PLEASE, PLEASE HELP!!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
MySQL and external host- PLEASE, PLEASE HELP!!
|
|
|
| I greatly appreciate any help y'all can give me...
I'm new to PHP and MySQL and I'm trying to set up a connection in Dreamweaver.
Instead of localhost, I'm given a hostname like this: db477.somecompany.net
I've tried every version of that I can think of as the host name, and it won't let me
connect...
It tells me there's no testing server or the testing server isn't mapped to the root
directory...
I don't know enough to know how to fix this, and GREATLY appreciate your help.
Any ideas?
| |
| Drakazz 2006-05-02, 3:58 am |
| I assume you're using 1&1 maybe?
I think their servers are inside a LAN and you cannot connect to them.
This is because of security.
The best thing for you is to get MySQL yourself (http://mysql.com/) and
install it and then use "localhost" as the hostname for the connection.
Then you'll be able to do whatever you need and later use phpMyAdmin on
the actual server to insert the MySQL data dump.
Google will be good for answers if you have any questions about dumping
mysql data, installing mysql etc.
| |
|
|
Thank you for your suggestion. It sounds like great advice.
Unfortunately, it's not an option in this case... I've got to connect to an existing
database that was created via phpAdmin...
You're right- it's 1and1.com
Are they famous for that or something?
"Drakazz" <vykintas.narmontas@googlemail.com> wrote:
>I assume you're using 1&1 maybe?
>
>I think their servers are inside a LAN and you cannot connect to them.
>This is because of security.
>
>The best thing for you is to get MySQL yourself (http://mysql.com/) and
>install it and then use "localhost" as the hostname for the connection.
>Then you'll be able to do whatever you need and later use phpMyAdmin on
>the actual server to insert the MySQL data dump.
>
>Google will be good for answers if you have any questions about dumping
>mysql data, installing mysql etc.
| |
| Danny Wong 2006-05-03, 6:58 pm |
| Hi,
I am an Hosting Company technican. For security reasons, your database
cannot access from outside, that is you can access your database via another
computer. You can only access your database within the computer that host
your web site because there is not entry in the MySQL database to allow you
to login outside. Maybe you can ask your provider if they can open your
database for outside access.
However, I don't think they will accept the request. Here below is our
standard answer to our client that do the same request.
1. To protect our database server, we have firewall protection to block
all outside connection to our database server.
2. We experience that some of our clients use our database server to do
a lot of processing that use most of our server's resources.
3 ......
In our case, we offer our customer to host their dedicated database
server but never allow user to access the share database server outside.
If you are writing test program before launch it to the web, I can share
my own database server for you to test the program for a short time.
However, my own server has been share to my friends for testing programs.
It may be hang because of their bad program. If you don't mind, contact me
via email. My email 'danny wong*pfshk.com', please add a dot between danny
and wong and replace the * with @ sign. This is to avoid junk mail capturer
to steal the email from the newsgroup.
Danny Wong
"Owner" <richaubuchon@a5software.com>
???????:125fnh6afq57547@corp.supernews.com...
>
> Thank you for your suggestion. It sounds like great advice.
>
> Unfortunately, it's not an option in this case... I've got to connect to
> an existing
> database that was created via phpAdmin...
>
> You're right- it's 1and1.com
>
> Are they famous for that or something?
>
>
> "Drakazz" <vykintas.narmontas@googlemail.com> wrote:
>
>
| |
| Drakazz 2006-05-03, 6:58 pm |
| It's nothing hard to actually setup a local MySQL, apache server for
testing, is it?
Benefits would be that you wouldn't need to reupload every time, it's
quicker, uses free bandwidth (localhost), and you do is save and then
refresh in your browser.
http://www.wampserver.com/en/index.php
this will be very helpful, to start off on your computer :)
|
|
|
|
|