Setup VPS for Linux Noobs!




new password?
login
X
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.

Setup Unmanaged VPS: The Ubuntu-Nginx Guide

Take your virtual private server from zero to hero

  .. from blank box to cute-as server ..  

with this easy-to-follow copy/paste guide.

22+ parts with video, here’s the index.

Add a MySQL Database

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


Please sign up for automatic premium content access.

Just $15/year* will save you hours, maybe days!

Alternatively, the vpsBible forum is free and you are welcome.

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


Please sign up for automatic premium content access.

Just $15/year* will save you hours, maybe days!

Alternatively, the vpsBible forum is free and you are welcome.

Now create the db:-


Please sign up for automatic premium content access.

Just $15/year* will save you hours, maybe days!

Alternatively, the vpsBible forum is free and you are welcome.

And exit the MySQL shell:-


Please sign up for automatic premium content access.

Just $15/year* will save you hours, maybe days!

Alternatively, the vpsBible forum is free and you are welcome.

Delete a MySQL Database

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


Please sign up for automatic premium content access.

Just $15/year* will save you hours, maybe days!

Alternatively, the vpsBible forum is free and you are welcome.

And delete the sucker:-


Please sign up for automatic premium content access.

Just $15/year* will save you hours, maybe days!

Alternatively, the vpsBible forum is free and you are welcome.

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


Please sign up for automatic premium content access.

Just $15/year* will save you hours, maybe days!

Alternatively, the vpsBible forum is free and you are welcome.

Setup Unmanaged VPS: The Ubuntu-Nginx Guide

Take your virtual private server from zero to hero

with this easy-to-follow copy/paste guide.

“My local PC runs Windows” Show me for Linux/Mac

22+ parts with video, here’s the index ..

Manage Unmanaged VPS: Ubuntu-Nginx Administration

Already set it up? We’d best maintain it then.

Toggle to the ..  Ubuntu-Nginx Admin Index

Manage Unmanaged VPS: Ubuntu-Nginx Administration

Maintain your virtual private server with ..

.. cheatsheets, tutorials, tips & guides.

Head back to the ..  Ubuntu-Nginx Installation Index

Nginx Admin: In the Works ..

This lot’s marked for addition already:-

  • Setup or Edit DNS using Bind
  • Network Tools Troubleshooting Guide
  • The Comprehensive Permissions Guide
  • Configuring Nginx Rewrites
  • Custom Website Error Page
  • Setting up Cron Jobs
  • Rsync for Incremental Remote-to-Local Backup
  • Cron & Rsync for Automatic Backup
  • Cron & mysqldump for Auto DB Backup
  • Safeguard Bandwidth with Hotlink Protection
  • Block Access with Nginx’ IP Deny



Got a Question? Want to Comment?

This site has no comments system. We've got a better system!

Please use the link at the top of the post and goto this topic's forum thread:-

  • to help build community
  • for a superior knowledge base
  • to keep info in one place, not diluted between forum & comments.

For those posts ported from Guvnr.com (pre-Feb/2010), archive comments remain.

Handy info from these comments is in the process of being ported to the forum and attributed to the original author.

If you think this idea sucks, let me know.

Thank you.

  • 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 [...]

  • 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 [...]

  • 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 [...]

  • 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 [...]

  • 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 [...]

  • 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 [...]