MySQL Basic Database Administration Commands – Part I

Best Affordable Linux and WordPress Services For Your Business
Outsource Your Linux and WordPress Project and Get it Promptly Completed Remotely and Delivered Online.

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. Get your own self-hosted blog with a Free Domain at ($3.45/month).
  4. Become a Supporter - Make a contribution via PayPal
  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.

RedHat RHCE and RHCSA Certification Book
Linux Foundation LFCS and LFCE Certification Preparation Guide

You may also like...

48 Responses

  1. Manik says:

    Very Good Tutorial, keep it up

  2. sriram says:

    Very good for beginners. Thank you.

  3. juadmin says:

    Very good article ..

  4. Andrew says:

    Where is part 2?

  5. lethargos says:

    Moreover: “Note: The above query, as performed is not a good idea. It will change the id to ‘4‘ where ever the first name is ‘tecmint’. “. Should it be “3” instead of “4”?

  6. quas says:

    The second time this command is run (“UPDATE minttec SET id = 3 WHERE first_name = ‘tecmint’;”) it should show “Change: 0”, and not “Change: 1”. That’s the whole point, isn’t it? Or am I getting it wrong?

  7. inderjeet says:

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

  8. Pierre BAY says:

    Verry good newbie guide.
    I appreciate well.

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

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.