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?

Could there be an issue with me using PHP 5 with the stated version of MySQL ?


Gaz

__________________
Gaz