MySQL Basic Database Administration Commands – Part I

If You Appreciate What We Do Here On TecMint, You Should Consider:

  1. Stay Connected to: Twitter | Facebook | Google Plus
  2. Subscribe to our email updates: Sign Up Now
  3. Use our Linode referral link if you plan to buy VPS (it starts at only $10/month).
  4. Support us via PayPal donate - Make a Donation
  5. Support us by purchasing our premium books in PDF format.
  6. Support us by taking our online Linux courses

We are thankful for your never ending support.

Receive Your Free Complimentary eBook NOW! -

Download Free Linux eBooks

Advanced Bash-Scripting Guide
Linux Bible
A Newbie's Getting Started Guide to Linux
Introduction to Linux - A Hands on Guide

You may also like...

37 Responses

  1. Jelil Ayorinde says:

    It is a pity that I am using this site from a third world country, otherwise I would donate generously to Tecmint. Tecmint is one of few websites that tutors and teaches people just exactly how teaching should be delivered. I stumbled on MySQL tutorial at tecmint.com, as a beginner I followed the steps from installation of MySQL to creating database, table, and from there to creating records and manipulating the records on the database through different queries; the result of which is 100% accurate. I think one day I will be able to donate. This is a 5 stars rating. Please explain installation and administration of MySQL on Microsoft Windows platform. Thank you tecmint.com

    • Ravi Saive says:

      @Jelil,

      Thanks for appreciating our work, we will continue to work hard and produce 100% working quality articles for users like you. Keep connecting and support tecmint..

  2. Anand says:

    How to find out which database is currently used in MySQL

    • Ravi Saive says:

      @Anand,

      Just connect to MySQL prompt and type show databases; query to get all the available databases in MySQL, if you want to see which database is curring running, you can use show processlist; to see currently running queries on database.

    • Blesso says:

      select database(); or \r

Got something to say? Join the discussion.

Your email address will not be published. Required fields are marked *

Join Over 150K+ Linux Users
  1. 100,756
  2. 5,113
  3. 36,418

Enter your email to get latest Linux Howto's