OK! Now it works. I've just didn't create the database.
I thought tha it was created automatically by the GRANT command, but in fact
it sets up the user and the privileges but don't create the database.
So only thing left was:
CREATE DATABASE phpbook;
and after that populate it with tables, etc.
Try doing this
mysql> use databasename
mysql> select * from tablename;
You haven't selected any database from which to retrieve info.
-Original Message-
From: Carl Troein [mailto:[EMAIL PROTECTED]]
Sent: 11 December 2001 10:26
To: [EMAIL PROTECTED]
Subject: Re: unknow
TED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, December 11, 2001 9:23 AM
Subject: unknown data base
>I'm new to mysql, but going on ...
>
>I've set up user jupshoes to the data base phpbook with the GRANT command:
>
>GRANT SELECT,INSER
josep writes:
> mysql>select* from phpbook;
> No data base selected
Hmm.. unless you typed that in rather than copied & pasted,
there's something really odd going on. Anyway, it looks like
you're trying to select stuff from the table phpbook, but
you haven't selected a database yet. Maybe you'r
I'm new to mysql, but going on ...
I've set up user jupshoes to the data base phpbook with the GRANT command:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON phpbook.*
TO jupshoes@localhost
IDENTIFIED BY 'jupshoes';
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DRO
