How to Create and Delete a MySQL Database - Revision history

Brian: /* Alternative way to create and drop a database */

2014-03-12T18:10:07Z

‎Alternative way to create and drop a database

Brian: /* Delete/Drop a MySQL Database */

2014-03-12T18:09:24Z

‎Delete/Drop a MySQL Database

Brian: Created page with "==How to create and delete a MySQL Database== Now that you have MySQL setup, I would assume that you will want to create a database. ===Create a New MySQL Database=== The..."

2014-03-12T18:08:45Z

Created page with "==How to create and delete a MySQL Database== Now that you have MySQL setup, I would assume that you will want to create a database. ===Create a New MySQL Database=== The..."

New page

==How to create and delete a MySQL Database==

Now that you have MySQL setup, I would assume that you will want to create a database.

===Create a New MySQL Database===

The first thing you will need to do is login into mysql

mysql -u <username> -p

Then you will want to create your database

create database <databasename>;

To verify that your database has been created run:

show databases;

===Delete/Drop a MySQL Database===

As before, the first thing you need to do is login to mysql

mysql -u <username> -p

Then drop the database

drop database <databasename>

===Alternative way to create and drop a database===

Alternatively this can also be done with -e flag with mysql

mysql -u <username> -p -e'create database <databasename>'

or

mysql -u <username> -p -e'drop database <databasename>'

← Older revision		Revision as of 18:10, 12 March 2014
Line 40:		Line 40:

	mysql -u <username> -p -e'drop database <databasename>'		mysql -u <username> -p -e'drop database <databasename>'
		+
		+	Now just check and see if its there or been dropped
		+
		+	mysql -u <username> -p -e'show databases;'

← Older revision		Revision as of 18:09, 12 March 2014
Line 26:		Line 26:

	drop database <databasename>		drop database <databasename>
		+
		+	To verify that it has been dropped
		+
		+	show databases;

	===Alternative way to create and drop a database===		===Alternative way to create and drop a database===