.

Maintain Unmanaged VPS – Part 4: Create or Bin MySQL DBs using the Terminal

English   English (change)

Maintain Unmanaged VPS – Part 4: Create or Bin MySQL DBs using the Terminal

20 Jul
mysql database logo

This how-to guide maps out two pretty basic but handy MySQL operations, creating and binning a database, using the terminal interface.

Sure, you can do those with, say, phpMyAdmin, but it’s way quicker to perform such functions using the CLI.

Substitute “db_username”, “db_password”, “db_password” and “db_name” with those of your own.

[sniplet guvSellBox]
[sniplet vpsIndexSell]

Add a MySQL Database

From the command line interface, we need first to access the mysql shell:-

[text]mysql -u root -p[/text]

And before actually creating the db, you need to set up the database user and password.

[text]grant all privileges on *.* to db_username@localhost identified by “db_password”;[/text]

Now create the db:-

[text]create database db_name;[/text]

And exit the MySQL shell:-

[text]quit[/text]

Delete a MySQL Database

Easy tiger! From the command line interface, we need first to access mysql:-

[text]mysql -u root -p[/text]

And delete the sucker:-

[text]delete database db_name;[/text]

And here’s an alternative way to exit the MySQL shell:-

[text]q[/text]
[sniplet vpsIndex]

Posted on Monday, July 20th, 2009
Subscribe to Comments by RSS              Trackback from your blog

THE_GUV NEEDS YOU!!

.. to improve this post ..

Please clue me in. What's wrong or missing?

Or, hey, just pile on the praise ;)  Ah, yup, and fix a feed, fella.

Or link the page to your social network!

thank you, thanx, tx, ta, t, tsst, twaddle, cheek, cheers, cheerio



  1. ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR : hostingwebsitereviews.com July 20th, 2009 at 1:56 pm

    [...] Read more from the original source: ADD or DELETE MySQL Database using Terminal – VPS ADMIN #4 – GUVNR [...]

  2. ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR : websiteshostingreviews.com July 20th, 2009 at 1:58 pm

    [...] Continue reading here: ADD or DELETE MySQL Database using Terminal – VPS ADMIN #4 – GUVNR [...]

  3. ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR : Best Web Hosting Review Website July 20th, 2009 at 3:16 pm

    [...] More here: ADD or DELETE MySQL Database using Terminal – VPS ADMIN #4 – GUVNR [...]

  4. ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR : tntwebhostings.com July 20th, 2009 at 3:27 pm

    [...] Continue reading here: ADD or DELETE MySQL Database using Terminal – VPS ADMIN #4 – GUVNR [...]

  5. ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR | Green Web hosting July 20th, 2009 at 3:40 pm

    [...] from: ADD or DELETE MySQL Database using Terminal – VPS ADMIN #4 – GUVNR Top 5 Green Web Hosting Companies, Click [...]

  6. ADD or DELETE MySQL Database using Terminal - VPS ADMIN #4 - GUVNR : hostwebsitereview.com July 20th, 2009 at 3:43 pm

    [...] Read the original: ADD or DELETE MySQL Database using Terminal – VPS ADMIN #4 – GUVNR [...]

Say Something


.