Some
developers still like to use the command line feature of MySQL other than
phpMyAdmin. the main advantage of the command line is fast accessing. and it’s
can access any platform too.
To
work with command line on your XAMPP installation, first go to your command
line on windows and find MySQL “bin” folder.
1.
type “cmd” on run box in windows.
2.
type
cd c:\xampp\mysql\bin
(specify
drive letter if your XAMPP not in c: drive)
3.
type
mysql.exe -u root -p
{password}
that’s
it. now you can run your MySQL queries.