Topic: mysql deleting database

[christian m. isidro]

hello,,,

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

thanks

christian m. isidro

[Chaloner Hale]

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

[james douglas]

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

[christian m. isidro]

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

thanks

[christian m. isidro]

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

thanks

[Rob Wellesley]

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/