Re: Help: Dreamweaver Database Conncetion Problem (PHP/MySQL)

From: EricRobineau (ericrobineau_at_yahoo.fr)
Date: 10/28/03 

Date: Tue, 28 Oct 2003 10:25:58 +0100

OK thanks for your help :)

"sk" <steve-no-spam@hatless-dot-com-without-the-spam.com> wrote in message
news:SMjnb.34907$ao4.70399@attbi_s51...
> I'm sure your PHP and Apache have no problem connecting to your
> database. You probably can't connect to MySQL from outside the server,
> though, which is the norm on cheap hosting providers. Some other
> providers do let you do it but only after you GRANT privileges to users
> on remote machines (like you and your copy of Dreamweaver). Ask your
> provider if you can connect to MySQL remotely. If not, don't fight it.
> It's probably not up for debate and you get what you pay for.
>
> If your hosting provider doesn't allow remote connections to MySQL, then
> no, you can't use Dreamweaver (or any other remote database tool) for
> rapid development the way you're i. If you want to use Dreamweaver,
> you'll have to develop against your own installation of
> Apache/PHP/MySQL, use an local project directory layout and database
> design as close as you can manage to the live one, and then FTP the
> files as-is to the host for testing. Once you get the hang of it it can
> be manageable.
>
> EricRobineau wrote:
>
> > Hello
> > I'm learning PHP/MySQL -- I've done a small testsite that works
> > locally on my computer (see DW settings below) -- but I don't manage
> > to transfer that site to a free PHP/MySQL host (see other settings
> > below)
> >
> > The free host I found offers a PHPMyAdmin interface to create my
> > database and an FTP connection to upload my PHP website -- So I can
> > create my database, I can upload my PHP site but the problem is that I
> > can't connect both together :-(
> >
> > Most PHP hosting plans are PHP/MySQL/PHPMyAdmin ... isn't it possible
> > to use dreamweaver with that kind of hosting plans ? How can I connect
> > my database then ?? Do you know another (better) free and working host
> > so I can try before buy any more sophisticaded hosting plan ???
> >
> > As you might notice I'm quite a newbie in PHP so maybe I missed
> > something obvious ... but I really don't know what I is ;-)
> >
> > Thanks for your help
> >
> > here are my actual settings:
> >
> >
> >
>

Relevant Pages

  • Re: Executing PHP files on remote web server
    ... We have a commercial web host servicing our external clients, but we don't want to move the entire app and database to the web host because a lot of the data is sensitive. ... By loading the non-sensitive data into the web host's MySQL tables, our external clients can see their reports on the web. ... our web host put a firewall on the MySQL database so we can't insert data into the remote tables directly from the PHP pages running on our own web server. ...
    (comp.lang.php)
  • Database Comparison?
    ... after using it that php is built more than anything to easily sit on ... talking to a mysql database and spitting out html to ... use these things better I've made a rudimentary gui designer and some ...
    (comp.lang.php)
  • Re: Access denied in remote mysql connection
    ... connect to my local mysql database, ... it is what the remote connection ... If you can connect using mysql on the command line, ... Shared Hosting, Reseller Hosting, Dedicated & Semi-Dedicated servers ...
    (comp.lang.perl.misc)
  • Re: How to use SQL "LIMIT" keyword against an MDB file
    ... that it will work with an MSAccess MDB file. ... PHP Programmer Guy. ... Except you've just "solved" his issue with a database redesign. ... from MySQL to Access in the first place. ...
    (comp.lang.php)
  • Re: help me
    ... field automatically assign its self a value of the next auto inc number ... I have a mysql database and i have it displaying whats currently there ... using php, the problem is that I cannot insert into the database ...
    (comp.lang.php)