How can I access MYSQL Monitor in XAMPP?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How can I access MYSQL Monitor in XAMPP?

Postby TransPersonal123 » 21. December 2009 00:21

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.
TransPersonal123
 
Posts: 2
Joined: 21. December 2009 00:15

Re: How can I access MYSQL Monitor in XAMPP?

Postby Izzy » 21. December 2009 00:38

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
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: How can I access MYSQL Monitor in XAMPP?

Postby TransPersonal123 » 21. December 2009 01:22

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.
TransPersonal123
 
Posts: 2
Joined: 21. December 2009 00:15


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 48 guests