Re: Create DataBase tabe for a user
Did you first create a database named 'poll'? - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 19, 2002 4:33 AM Subject: Create DataBase tabe for a user Hello, When I run "grant all on poll.* to edward@localhost identified by 'edward';" command... I found there is no "poll" directory at /var/lib/mysql/poll ! So, can you help me ? PS : My system is Linux RH 6.2 Thanks, Edward. - 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: Create DataBase tabe for a user
Hello! [EMAIL PROTECTED] wrote: >Hello, > >My system is Red Hat 6.2, My MySQL is 3.23.46 ( rpm package )... >Now, when I run "grant all on poll.* to edward@localhost identified by >'edward';" command... >I found there is no "poll" directory at /var/lib/mysql/poll ! >So, can you help me ? > > Maybe stupid question, but you issued 'CREATE DATABASE poll;'? Greetings Ralf sql , query -- Ralf Narozny SPLENDID Internet GmbH & Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - 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: Create DataBase tabe for a user
You have to create the database (poll) before doing any operation on it. Use ~mysql/scripts/mysql_install_db.sh to create a database. There may be an SQL command also to create the database - just check the mysql command reference. Regards Barnali -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 19, 2002 3:04 PM To: [EMAIL PROTECTED] Subject: Create DataBase tabe for a user Hello, When I run "grant all on poll.* to edward@localhost identified by 'edward';" command... I found there is no "poll" directory at /var/lib/mysql/poll ! So, can you help me ? PS : My system is Linux RH 6.2 Thanks, Edward. - 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
