command prompt not working

[Anon]

Right Im a newbie to this.

I have installed PHP4 and MYsql and mysql admin (web based). PHP works and so does the mysqladmin. It connects to the mysql database no problem. However when i try to connect in the command prompt, theres no sign of it. I want to administer it this way because im a begginer and its probably the best way of learning.

I also havent yet managed to connect to the database using php.

Any ideas

Paul

[Anon]

Just what is the problem here, you can't find the commandline program for mysql? or for php? or you can't connect to the server using the mysql binary?

About connecting from PHP, read the manual, it tells you everything about it.

[Anon]

Its not PHP im having trouble with its finding the commandline program for mysql

But as you so rightly pointed out RTFM
Paul

[Anon]

Findinf the commandline binary should be solved by doing a search :-)

[Anon]

what happens when you do this at command line :

which mysql

when that happens, it should print something out like this :

/usr/local/bin/mysql

then, you would type (whatever it tells you but for this example i use mine)

/usr/local/bin/mysql -uroot -p

and tell us what all these steps do and what errors you get.

[Anon]

When i run that command i get the error:
The name specified is not recognised is an internal or external program or batch file.

Is this because i havent got the command line binary. I take it they come as a separate package to the mysql server

Paul