As you know MYSQL is one of the largest and most used Database Management System.
It is developed by ORACLE.
In this article you will learn : How to setup MYSQL to access from COMMAND PROMPT.
It's installer comes with :
- 🔺 MYSQL Server
- 🔺 Workbench (MYSQL IDE)
- 🔺 Connectors for different Programming languages
- 🔺 and MYSQL Shell
We can use either Workbench or MYSQL Shell to execute SQL statements.
While dealing with database management task.
You can access the MYSQL tool from the command line using any of your favorite TERMINAL like HYPER, CMDER etc.
You can download MYSQL from here: 👉👉MYSQL DOWNLOAD 👈👈
🔆 STEP 1:
OPEN THE MYSQL INSTALLATION FOLDER and select ➢➣ "MYSQL SERVER x.x "
 |
| MYSQL COMMAND LINE SETUP | VILLAGEPROGRAMMER |
🔆 STEP 2:
SELECT ➢➣ "bin"
🔆 STEP 3:
Click on the address bar as shown in the picture below and copy the path :
🔆 STEP 4:
Right Click on THIS PC and Select PROPERTIES
🔆 STEP 5:
select :
- Advance System settings
- Environment Variables
- Path
🔆 STEP 6:
Create new path :
- click NEW
- ans PASTE THE PATH
🔆STEP 7:
press WIN + R and type cmd to open command prompt.
🔆 STEP 8:
Type your USERNAME and PASSWORD
🔆 STEP 9:
AN EXAMPLE IS SHOWN BELOW:
Thanks for reading. 🙏
If you liked it feel free to share with your dear ones.💗
And tell me what do you think in the comment box.💬
Post a Comment