From owner-freebsd-questions Wed Jan 23 10:19:48 2002 Delivered-To: freebsd-questions@freebsd.org Received: from web12501.mail.yahoo.com (web12501.mail.yahoo.com [216.136.173.193]) by hub.freebsd.org (Postfix) with SMTP id 6ADD537B448 for ; Wed, 23 Jan 2002 10:19:30 -0800 (PST) Message-ID: <20020123181930.76205.qmail@web12501.mail.yahoo.com> Received: from [216.250.215.7] by web12501.mail.yahoo.com via HTTP; Wed, 23 Jan 2002 10:19:30 PST Date: Wed, 23 Jan 2002 10:19:30 -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-699975917-1011809970=:76198" 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-699975917-1011809970=:76198 Content-Type: text/plain; charset=us-ascii i would suggest checking the grants on that username with the "show grants privileges for " and see if all priv's are right then i would maybe to be sure restart mysql but skipping the grant tables ..to achive this you could try --skip-grant-tables switch and see if you can connect to the db!!. my $0.02 Andre` Niel Camerown 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-699975917-1011809970=:76198 Content-Type: text/html; charset=us-ascii

 i would suggest checking the grants on that username with the "show grants privileges for <user_blah>" and see if all priv's are right then i would maybe to be sure restart mysql but skipping the grant tables ..to achive this you could try --skip-grant-tables switch and see if you can connect to the db!!.

my $0.02

  Andre` Niel Camerown <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-699975917-1011809970=:76198-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message