How to connect from windows command prompt to MySQL command line - MySQL DBA Tutorial

How to connect from windows command prompt to MySQL command line

To connect to MySQL server on Windows Machine, you can locate mysql application that is location in C:\Program Files\MySQL\MySQL Server xx\bin in case you have done default installation. If you have done manual installation then it depends where your base directory is. I have explained in video with details but most of the cases as you will have only single MySQL on Windows server, you will find mysql application under "C:\Program Files\MySQL\MySQL Server xx\bin".

xx defines the version. If I have used MySQL 8.0 for installation then it will be "C:\Program Files\MySQL\MySQL Server 8.0\bin".

To connect to MySQL Server on windows Machine, open Command line by going to search or going to Run and typing cmd.
On windows command line, go to "C:\Program Files\MySQL\MySQL Server 8.0\bin" by using

Check the link for commands used in the video

To follow step by step tutorial for MySQL DBA for beginner to Advance

MySQL Workbench Tutorial
MySQL DBA Certification Training
MySQL DBA Tutorial Step by Step
MySQL DBA Training online free
MySQL Real Time DBA Tutorial
MySQL Administration Course step by Step
MySQL Tools for Development and Admin