Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: christian m. isidro on June 06, 2002, 02:21:46 PM

Title: mysql deleting database
Post by: christian m. isidro on June 06, 2002, 02:21:46 PM

hello,,,

   i need help ,,,,how can i delete a database in mysql,,,,,,

thanks

christian m. isidro

Title: Re: mysql deleting database
Post by: Chaloner Hale on June 06, 2002, 06:20:14 PM

As root:

#mysql
  drop database DATABASENAME; (semicolon is important)

  Query OK, 0 rows affected (0.00 sec)

  quit
#

To see a list of databases;

#mysql
  show databases;

+--------------+
| Database |
+--------------+
| horde       |
| mysql      |
| test         |
+--------------+
6 rows in set (0.00 sec)

  quit
#


Chaloner Hale

Title: Re: mysql deleting database
Post by: james douglas on June 07, 2002, 05:13:52 AM

or if youre not comfortable on a command line, install phpmyadmin to administer your mysql databases remotely through your web browser...

Title: Re: mysql deleting database
Post by: christian m. isidro on June 07, 2002, 05:48:07 AM

hi ,,
 thanks for  the tip,,,but i need the deleting database information,,,your information is relevant to me,,,,,

thanks

Title: Re: mysql deleting database
Post by: christian m. isidro on June 07, 2002, 06:08:43 AM

thanks ,,,how can i install the phpadmin,,,what will i do ...
is there a step by step guide,,,

thanks

Title: Re: mysql deleting database
Post by: Rob Wellesley on June 07, 2002, 10:02:53 AM

christian m. isidro wrote:
>
> thanks ,,,how can i install the phpadmin,,,what will i do ...
> is there a step by step guide,,,
>

http://www.myezserver.com/downloads/mitel/contrib/phpmyadmin-2.2.3/