Monday 24 March 2014

How To Make A Command-Line Tool For MySQL (Which Will Always Open MySQL)

Usually You Will Go To CMD and Go To Directory Where XAMPP is and blah blah blah blah....

There's An Easy And Fast Way.

Follow These Steps.

Step 1 - Open Notepad

Step 2- Now You Know What To Do Ctrl + C and Ctrl + V. What Else Can You Do? :D






title MySQL

D:

cd xampp

cd mysql

cd bin

cls

mysql -u your username -p your password -h localhost




Step 3- Save The File As Anything.bat I Would prefer MySQL.bat.

Note: Remove "your username" and replace it by your username which is root by default, remove "your password" and replace it with your password which is nothing by default.


From 2nd to 5th line I Have Guided computer to the location of MySQL wherever your xampp is remember you have to guide computer to bin which is present in MySQL Folder.

After Doing It Right It'll Look Like This


Now You'll Have To Enter The Password Enter If You Have Set One and By Default its Nothing So Just Hit Enter.

Happy Programming!

Follow Me On My Facebook Account

No comments:

Post a Comment