As a DevOps person you get to deal with lot of different databases flavours, MySQL is one of the most commonly used database. One of pain point is since DevOps are not DBA’s so if we don’t get to deal with SQL servers we will forget commands. Mostly we keep a list of commands in our notepad/notes/local editor etc to fetch it quickly whenever we need, So here I am going to share commonly used MySQL commands from my experience. This post is meant for only commonly used MySQL commands by Ops or System Admin.
Personally I use mycli in order to connect to mysql server, mycli is a command line interface for MySQL and MariaDB with auto-completion and syntax highlighting. Okay! lets gets thing keep rolling.
NOTE: All the below commands are for Unix based system (Mac, Linux) and works if you install mycli.