I have recently began reading Beginning PHP5, Apache, MySQL Web Development by Wrox Press.

Having successfully installed, configured and tested Apache and PHP5. I have run into problems with MySQL Ver 4.0.15

Using the DOS prompt I'm able to run another of tests such as:

c:\mysql\bin\mysql test

or

NET START / STOP MySQL

or

show databases;

However when I attempt to run any kind of query such as:

SHOW COLUMNS FROM user FROM mysql;

or

SELECT user, host FROM user;

or

DELETE FROM user WHERE Host='localhost' AND User='';

I get the following error each time:

ERROR 1046: NO DATABASE SELECTED

Having followed the instructions in the book, I'm a little puzzled to how some commands work, while others dont. Could somebody advise where I might be going wrong?

Gaz

__________________
Gaz

Try starting with:

  use database_name_here;

This should tell MySQL what database you are wishing to operate on.

Regards

Jeremy

SHOW DATABASES;

will show you what databases are available to USE also.