newbie - what and where is command prompt (mysql)

leeolive

I am completely new to php, apache and mysql and have just installed them. I am using Windows 98, PHP4.3.3, Apache, MySQL3.23.54-win.

I am following instructions in the PHP & MySQL development book by Luke Welling & Laura Thomson. I have loaded php and apache and both are working. I have installed MySQL, but apparently php/apache are not to MySQL. Anyway, first things first..

In the book it talks about 'opening a command prompt'.
For example , apparently to test if it works you do this
c:\mysql\bin\mysqlshow

or to delete an anonymous user:

c:\mysql\bin\mysql
use mysql
delete from user where user='';
quit
c:\mysql\bin\mysqladmin reload

Trying the first 'prompt', I went to the bin folder and clicking on the mysql file brought up the sql black console. It has the word 'mysql' within the black screen. I entered this code next to 'mysql' but it comes up with an error.

What exactly is command prompt?? Do I need to type this into the MySQL console window(the window with the traffic light icon)? Where and how do I do this?

Thanks
Lee

Blag

Well.....MySql works with the command prompt, that black windows were you put your querys.......maybe the code you are enter gives you an error, coz your supposed to get connected to the database first.

IMO you should download any MySQL graphical IDE like this one:

MySQL GUI

That way, you can take a better management of the DataBase, and still can make querys without bother yourself with that hatefull Black window.