Determine MySQL Version via Command Line

Want to find out what version MySQL you are running using only your command line interface? This one is super easy.

  1. Log in to MySQL (replace “root” with your username of choice or keep as root)
    mysql -u root -p
  2. Enter your password when prompted
  3. Run the following statement
    SHOW VARIABLES LIKE "%version%";

Your output might look something like this…

0 0 vote
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments