Re: Creating Mysql DB with PHP

> >> You use the userID and password of a user that is already created on
the
> >> system.
> >>
> >> If this is being installed on someone else's system, then you need to
> >> provide some way for them to enter that information. You could do it
like
> >> PHPMyAdmin - where the end-user modifies a configuration file and
enters
> > the
> >> info, or you could make a form that accepts the information and passes
it
> > to
> >> the installation script.
> >
> > It will be a new installation on somebody else's server, therefore I
just
> > need to be pointed in the direction of the php command(s) to setup the
> > user.
>
> I think you're missing the question - you seem to be overcomplicating
> things.

LOL... Its the story of my life....


> If someone else has a server with MySQL on it already, they will also have
a
> userID and password for that MySQL server. All you need to do is get that
> information from them and use that information to connect to the database.

I am only going by what I have to do when setting up a new database.

1 goto Cpanel > Mysql Databases
2 Create a new database
3 create a user for that database incl password
4 then its on to PHPMyAdmin to create tables etc..

If i dont do steps 1 to 3 i can not connect to the database via php.
even if i only do steps 1 and 2 i can not connect.

I'm sure i must be missing something somewhere, but im not sure what or
where.



.

Relevant Pages

  • Re: Creating Mysql DB with PHP
    ... >> userID and password for that MySQL server. ... > I am only going by what I have to do when setting up a new database. ...
    (alt.php)
  • Re: PHP front to mySQL database
    ... You should be able to set up MySQL to respond via ODBC to calls from VB. ... Set up the database file table structure in Access and call it from VB. ... I also prefer to use the web browser as the client interface instead of VB. ... an installation pain. ...
    (alt.php)
  • Re: Creating Mysql DB with PHP
    ... > When you install a MySQL server, you initially install a user named ... that account is used by the database ... > When you create a MySQL database in CPanel, ... you HAVE to have a userID and password already, ...
    (alt.php)
  • Re: Newbie- Can I create a new MySQL database from within my app?
    ... MySQL has similar schema backup and restore options. ... scripts sort out the registry and install the software and this has worked ... your installation routines should handle database installation setup etc. ...
    (alt.comp.lang.borland-delphi)
  • Re: MySQL and Mac OSX
    ... MySQL is there. ... To test the installation, try logging in from the "terminal" program ... I had though MAMP would be an easier route to things when I ... the database you want to use for access with PHP if you hadn't created ...
    (alt.php)