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

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

Follow