Useful MySQL Commands

How to connect to MySQL?

  • Open your command prompt (type ‘run’ in your windows search)
  • Go to <mysql installation folder>\bin
  • Type “–user=<root username> –password=<your root password>

How to check MySQL version?

  • Connect  to MySQL
  • Type the following command:
    SHOW VARIABLES LIKE "%version%";

Leave a Reply

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