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 mysqlselect* from phpbook; No data base selected or $ mysql -ujupshoes -pjupshoes phpbookphpbook.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
Re: unknown data base
josep writes: mysqlselect* 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're intending to do a SHOW TABLES? Unknown database Just a hunch: Have you actually CREATEd the database? That is, have you done a CREATE DATABASE phpbook? Note that it's legal to grant permissions on databases that haven't been created yet. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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
Re: unknown data base
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 mysqlselect* from phpbook; No data base selected or $ mysql -ujupshoes -pjupshoes phpbookphpbook.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
RE: unknown data base
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: unknown data base josep writes: mysqlselect* 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're intending to do a SHOW TABLES? Unknown database Just a hunch: Have you actually CREATEd the database? That is, have you done a CREATE DATABASE phpbook? Note that it's legal to grant permissions on databases that haven't been created yet. //C -- Carl Troein - Cmrdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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
SUCCESS!! unknown data base
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 mysqlselect* from phpbook; No data base selected or $ mysql -ujupshoes -pjupshoes phpbookphpbook.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
