Apache Friends Support Forum

Hello friends,

I found a great tutorial series on youtube that teaches MYSQL programming. The person in the tutorial uses a command line interface called MYSQL Monitor. However I can only interact with my database using PHPmyadmin. I want to learn MYSQL on a hand coding level not just use the PHPmyadmin GUI. Is there a way in XAMPP to use a command line interface to work with the database?

Please help.

Missing support info - what XAMPP version and which Windows OS?
So assuming latest stable XAMPP version and Windows XP.

Click on the Shell button in the XAMPP Control Panel then at the # prompt type mysqladmin --help for a list of commands.

To access when MySQL is running type at the # prompt mysql --help for list of commands.

http://dev.mysql.com/doc/refman/5.1/en/index.html
http://dev.mysql.com/doc/refman/5.1/en/tutorial.html

Some useful and helpful reading for new XAMPP users:
\xampp\readme_en.txt file
or
http://www.apachefriends.org/winxampp/readme_en.txt

http://www.apachefriends.org/en/xampp-windows.html
http://www.apachefriends.org/en/faq-xampp-windows.html

Thanks for the response but I found the solution. What I wanted was to get the mysql prompt "mysql>", but entering the bin folder in the mysql directory and trying to start mysql.exe didn't work. It caused a beep sound with an error message like this: ERROR 1045 <28000>: Access denied for user 'ODBC'@'localhost'...
But I found this thread that helped out http://forums.mysql.com/read.php?60,200408,222836

After typing mysql -u root -p and entering my root password I recived the proper prompt and now I am able to work with the DB in command line. Hurray now I just have to learn SQL. By the way I am using Windows 7 and the latest version of XAMPP.