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. Sorry my newbie errors! Thank's to everybody in the mailing lists arround the net!!!!! Bye. Josep. My problem was: > >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,DROP > > ON phpbook.* > > TO jupshoes@panera > > IDENTIFIED BY 'jupshoes'; > > > >After that I've checked there are the related entries in to the user and > >the database tables. > > > >And now I want to populate the database, but the user jupshoes can't even > >see the database: > > > >(The user jupshoes connects to the host panera via TELNET) > > > >$ mysql -ujupshoes -pjupshoes phpbook > >unknown database > > > >or > > > >mysql>select* from phpbook; > >No data base selected > > > >or > > > >$ mysql -ujupshoes -pjupshoes phpbook<phpbook.sql (to populate the > >table) > >Unknown database > > > >What is going wrong? > > > >Thanks in advance! > > > > > >Josep > > 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. Sorry my newbie errors! Thank's to everybody in the mailing lists arround the net!!!!! Bye. Josep. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
