From owner-freebsd-questions Mon Jan 21 17:52:27 2002 Delivered-To: freebsd-questions@freebsd.org Received: from gaia.host4u.net (gaia.host4u.net [209.150.128.48]) by hub.freebsd.org (Postfix) with ESMTP id 24BE637B405 for ; Mon, 21 Jan 2002 17:52:21 -0800 (PST) Received: from andre (bricks.fastdns.net [216.71.43.117]) by gaia.host4u.net (8.8.5/8.8.5) with SMTP id TAA22482 for ; Mon, 21 Jan 2002 19:15:49 -0600 Message-ID: <19df01c1a2e6$f30bd020$a50410ac@olmct.net> Reply-To: "Andre` Niel Cameron" From: "Andre` Niel Cameron" To: Subject: MySQL Trouble PLEASE help! Date: Mon, 21 Jan 2002 20:48:54 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2462.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2462.0000 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 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