List:General Discussion« Previous MessageNext Message »
From:Elly Wisata Date:March 18 2004 3:35pm
Subject:Re: php script for new database and user
View as plain text  
Oh, thanks for your information. I used phpMyAdmin b4, but I never noticed
that it makes from php script! Gosh!!!
Thanks for make it straight.
----- Original Message -----
From: <jeffrey_n_Dyke@stripped>
To: "Bernd Tannenbaum" <tannenbaum@stripped>
Cc: <mysql@stripped>
Sent: Thursday, March 18, 2004 9:45 PM
Subject: Re: php script for new database and user


>
>
>
>
> Hi,
>
> > -----Original Message-----
> > From: Elly Wisata [mailto:elly.wisata@stripped]
> > Sent: Thursday, March 18, 2004 1:55 AM
> > To: mysql@stripped
> > Cc: 'BGLefty'
> > Subject: RE: php script for new database and user
> >
> > I don't think php script can create database. But maybe I am wrong.
> > If I am, please somebody make it straight.
> > Create a database should do it through console or some kind like
> > it.
>
> Well, phpMyAdmin can create databases. And if im not wrong its just a
> bundle of php-scripts.
> So maybe just install phpMyAdmin and create a DB. Iirc u can see the
> commands it does to create.
>
> ---------------
> php is only providing an interface to mysql.  If wish to script a database
> creation you can definitely use PHP.  As soon as you authenticate to mysql
> via mysql_connect(host,user,pass) you have the rights of that mysqluser,
> then you can create all the dbs you want through regular SQL, using PHP's
> mysql_query.
>
> mysql_connect('localhost','root','rootpassword');
> mysql_query('CREATE DATABASE PHP_TEST');
> mysql_select_db('PHP_TEST');
> mysql_query('CREATE TABLE STATEMENT')
>
> But if you just want to get some datbases created, then it may just be
> easier to use the command line/PHPmyAdmin/MySQLCC/lots of other programs.
>
> HTH
> jeff
> ____________
>
>
>
> Bernd
>
> --
> [Zufallssig 9]
> [NightGhost] on AO forum: "Perhaps it doesn't take two to make an
> idiotic argument, although you have proven for a fact, that one man
> indeed can make two idiotic arguments."
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>
>

Thread
php script for new database and userBGLefty17 Mar
  • Re: php script for new database and userW. D.18 Mar
    • RE: php script for new database and userElly Wisata18 Mar
  • Re: php script for new database and userDavid T-G23 Mar
RE: php script for new database and userSWBT)18 Mar
  • Re: php script for new database and userBernd Tannenbaum18 Mar
Re: php script for new database and userjeffrey_n_Dyke18 Mar
  • Re: php script for new database and userElly Wisata18 Mar