Hello Josep Your command seems to be wrong in accessing the db $mysql -u jupshoes -p phpbook Password: >
What you actually are doing is trying to access the "jupshoes" database;^) which infact is your password. HTH Norman -----Original Message----- From: josep <[EMAIL PROTECTED]> 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,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 > > > >--------------------------------------------------------------------- >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 > > --------------------------------------------------------------------- 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