• Home
  • Technology
    • Ebullientech
    • Entrepreneurship
    • Video Technology
    • Cloud Computing
    • Business Analysis
  • Healthcare
    • Pharmacology
  • Thoughts
    • Food
    • General
    • Stories
    • Places
    • Workplace
    • Social Issues
    • Reviews
  • Quotes
  • Ebullientech News and Events
  • About

Kamalika's Notebook

thinking nothing...............!!

You are here: Home / Kamalika / Technology / MySQL / A Few Useful MySQL Commands / Queries for Amateur DBAs – Part 1

A Few Useful MySQL Commands / Queries for Amateur DBAs – Part 1

February 4, 2013 By Kamalika Leave a Comment

MySQL DBA

I consider myself an amateur DBA because I’m not a professional MySQL DBA but at times I have to work with some MySQL Commands / Queries which are piece of cake for professional DBAs but require me to Google every time I need to use them. Currently some of them are lying in my GMail’s draft and some are lying in a Google Drive Doc and for the rest of them I still need to Google!! One Monday morning decided to create a ready reference out of those Commands / Queries and publish under my Blog for all future requirements and for other amateur MySQL DBAs out there in the World Wide Web!

1. Login to MySQL Command Prompt as root user

#mysql -uroot -p (this will require you to enter password after you press the return key)

OR

#mysql -uroot -prootpwd (here “rootpwd” is the password for root user)

Using the full MySQL Server path: /usr/local/mysql/bin/mysql -uroot -p OR /usr/local/mysql/bin/mysql -uroot -prootpwd

Pages: 1 2 3 4

Filed Under: MySQL, Server Administration Tagged With: MySQL, MySQL Commands, MySQL Queries

« How to rename a stored procedure in MySQL?
Load Balanced Databases hosted in Cloud, MySQL ORDER BY and PHP Array Multi Sort! »

Leave a Reply Cancel reply

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

Connect with Facebook

Let’s connect…

  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
  • YouTube

Hello There…

I'm Kamalika, a techpreneur & startup mentor, blogger, hobbyist photographer, Netflix & Kindle indulgent, food connoisseur, Starbucks aficionado and former Disney employee ...next

Looking for something?

Tags

All in One SEO Pack AWS Banaras Blogger Blogging Blogs Dasaswamedh Ghat Ebullientech Ebullientech Interactive LLP Facebook Facebook Developers father's day father's day wishes father's day wishes for dad fathers day love Fathers Day Special Fathers Day wishes from daughter Father’s day memories GeoTech GeoTech Informatics HipHop for PHP Kamalika Guha Roy Kashi Ganga LAMP MySQL Nabaneeta Guha Roy Online Marketing PayPal PayPal's suspension of Indian bank transactions PHP PHP & MySQL Saraswati Puja Search Engine Optimization SEO Startup The Ganges TypePad UCO HUT Varanasi Web 2.0 Web 2.0 Design Web Design Web Marketing WordPress WordPress.COM

Timeline

  • 2021 (3)
  • 2020 (7)
  • 2019 (4)
  • 2018 (1)
  • 2015 (6)
  • 2014 (13)
  • 2013 (9)
  • 2010 (7)
  • 2009 (2)

Topics

Copyright © 2021 · Kamalika Guha Roy, Powered by: Ebullientech