New MySQL user..Need Advice
I have just started using MySQL and am making my first attempts to get a small trial database established.
I am using a Cobalt Raq4 server and have installed MySQL and PHP4 but I seem to be encountering a problem to which I cannot find a solution.
I log in to my server via Telnet, navigate to MySQL and login as root giving the password I set after installation.....and I get the mysql> command prompt.
When I try and perform any Commands I get the following error mesage "ignoring query to other database" and it doesn't seem to matter what I do, the error message is always the same, even if I switch to the "test" database.
Consequently I can neither CREATE, SHOW or DROP anything......does anyone have any idea what the problem might be?
Thanks and regards