Hans, You're trying to insert into the wrong table to set up permissions. You should use the 'user' table for this. Eg:
INSERT INTO user VALUES........ But I would recommend the command line command "GRANT" to do that instead.... See: http://www.mysql.com/doc/en/GRANT.html for details... Cheers, Andrew -----Original Message----- From: hans schneidhofer [mailto:[EMAIL PROTECTED]] Sent: Mon 23 September 2002 07:44 To: [EMAIL PROTECTED] Subject: ERROR 1146 hi list, trying to do my first steps with mysql, i have done the following : mysql> USE mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> INSERT INTO mysql VALUES(localhost, sample_db, 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); ERROR 1146: Table 'mysql.mysql' doesn't exist hmm - what I have done wrong here ? or do I have to do something before ? these steps are a piece of description in a mysql-book "mysql in 21 days" and thanks for helping bye hans --------------------------------------------------------------------- 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
