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

Linux BASH Programming Cookbook
Getting Started with Ubuntu 16.04
A Newbie's Getting Started Guide to Linux
Introduction to Linux - A Hands on Guide

You may also like...

39 Responses

  1. inderjeet says:

    this is very useful web site , i think that anyone can implement, awesome.
    i use this site in most cases

  2. Pierre BAY says:

    Verry good newbie guide.
    I appreciate well.

  3. 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, 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

    • Ravi Saive says:


      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..

  4. Anand says:

    How to find out which database is currently used in MySQL

    • Ravi Saive says:


      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 300K+ Linux Users
  1. 177,942
  2. 8,310
  3. 37,548

Are you subscribed?