From owner-freebsd-questions Wed Jan 23 10:21: 6 2002 Delivered-To: freebsd-questions@freebsd.org Received: from web12503.mail.yahoo.com (web12503.mail.yahoo.com [216.136.173.195]) by hub.freebsd.org (Postfix) with SMTP id 53F7337B404 for ; Wed, 23 Jan 2002 10:20:57 -0800 (PST) Message-ID: <20020123182057.71772.qmail@web12503.mail.yahoo.com> Received: from [216.250.215.7] by web12503.mail.yahoo.com via HTTP; Wed, 23 Jan 2002 10:20:57 PST Date: Wed, 23 Jan 2002 10:20:57 -0800 (PST) From: david lubowa Reply-To: deez_diablo@excite.com Subject: Re: MySQL Trouble PLEASE help! To: Andre` Niel Cameron , questions@FreeBSD.ORG In-Reply-To: <19df01c1a2e6$f30bd020$a50410ac@olmct.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-62568088-1011810057=:71769" Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG --0-62568088-1011810057=:71769 Content-Type: text/plain; charset=us-ascii oops i messed with the command i meant "show grant for ; Andre` Niel Cameron wrote: Hi, ok here is my problem. I created a DB added the user. Granted all privileges and when I try to use it I get this error: You have new mail in /var/spool/mail/root [root@hs4 thegamersoutlet]# mysql -uthegamersoutlet -psinbumi users < users.sql ERROR 1142 at line 11: create command denied to user: 'thegamersoutlet@localhost' for table 'nuke_authors' [root@hs4 thegamersoutlet]# Does anyone have any Ideas? Here is my mysql transcript: mysql> grant all privileges on users to thegamersoutlet@"%" identified by 'shibumi'; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) I even restarted mysql as a last shot!! Please help any body? Regards, André C. Technical Support Ô¿Ô¬ ---------------------------------------------------------------------------- - Visit our support manual at http://supportmanual.com/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message --------------------------------- Do You Yahoo!? Send FREE video emails in Yahoo! Mail. --0-62568088-1011810057=:71769 Content-Type: text/html; charset=us-ascii

oops i messed with the command i meant "show grant for <user_name>;

  Andre` Niel Cameron <AndreC@Axxs.net> wrote:

Hi,

ok here is my problem. I created a DB added the user. Granted all
privileges and when I try to use it I get this error:
You have new mail in /var/spool/mail/root
[root@hs4 thegamersoutlet]# mysql -uthegamersoutlet -psinbumi users <
users.sql
ERROR 1142 at line 11: create command denied to user:
'thegamersoutlet@localhost' for table 'nuke_authors'
[root@hs4 thegamersoutlet]#

Does anyone have any Ideas? Here is my mysql transcript:


mysql> grant all privileges on users to thegamersoutlet@"%" identified by
'shibumi';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

I even restarted mysql as a last shot!! Please help any body?

Regards,
André C.
Technical Support
Ô¿Ô¬
----------------------------------------------------------------------------
-
Visit our support manual at http://supportmanual.com/


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message


Do You Yahoo!?
Send FREE video emails in Yahoo! Mail. --0-62568088-1011810057=:71769-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message