[RESOLVED] can't get mysql monitor running

johnm1958

I am a complete newbie. Sorry. I have installed xampp and it seems to be OK. i am now reading a book on php and it tells me to "open the MySQL monitor in a root shell window, or a Command Prompt window on windows systems, then type "show databases" at the mysql>prompt to see all databases".

Sorry to be complete numpty but how do i get to the mysql prompt?

tsinka

Hi,

I think in your case there are easier ways to see a list of all databases. xampp comes with phpMyAdmin. Simply open the url http://localhost with your browser and click on the phpMyAdmin link in the left menu. In the left frame of phpmyadmin is a dropdown that shows all databases. Alternatively you can execute queries (e.g. the show databases query) in phpMyAdmin.

johnm1958

great . thanks for that. its a minefield out there!