Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 23 Jan 2002 10:19:30 -0800 (PST)
From:      david lubowa <ziggydavie@yahoo.com>
To:        Andre` Niel Cameron <AndreC@Axxs.net>, questions@FreeBSD.ORG
Subject:   Re: MySQL Trouble PLEASE help!
Message-ID:  <20020123181930.76205.qmail@web12501.mail.yahoo.com>
In-Reply-To: <19df01c1a2e6$f30bd020$a50410ac@olmct.net>

next in thread | previous in thread | raw e-mail | index | archive | help
--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 <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
Content-Type: text/html; charset=us-ascii

<P>&nbsp;i would suggest checking the grants on that username with the "show grants privileges for &lt;user_blah&gt;" 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!!.
<P>my $0.02
<P>&nbsp; <B><I>Andre` Niel Camerown &lt;AndreC@Axxs.net&gt;</I></B> wrote: 
<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">Hi,<BR><BR>ok here is my problem. I created a DB added the user. Granted all<BR>privileges and when I try to use it I get this error:<BR>You have new mail in /var/spool/mail/root<BR>[root@hs4 thegamersoutlet]# mysql -uthegamersoutlet -psinbumi users &lt;<BR>users.sql<BR>ERROR 1142 at line 11: create command denied to user:<BR>'thegamersoutlet@localhost' for table 'nuke_authors'<BR>[root@hs4 thegamersoutlet]#<BR><BR>Does anyone have any Ideas? Here is my mysql transcript:<BR><BR><BR>mysql&gt; grant all privileges on users to thegamersoutlet@"%" identified by<BR>'shibumi';<BR>Query OK, 0 rows affected (0.00 sec)<BR><BR>mysql&gt; flush privileges;<BR>Query OK, 0 rows affected (0.00 sec)<BR><BR>I even restarted mysql as a last shot!! Please help any body?<BR><BR>Regards,<BR>André C.<BR>Technical Support<BR>Ô¿Ô¬<BR>----------------------------------------------------------------------------<BR>-<BR>Visit our support manual at http://supportmanual.com/<BR><BR><BR>To Unsubscribe: send mail to majordomo@FreeBSD.org<BR>with "unsubscribe freebsd-questions" in the body of the message</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br>
Send FREE <a href="http://rd.yahoo.com/mail_us/tag/?http://promo.yahoo.com/videomail/">video</a>; emails in <a href="http://rd.yahoo.com/mail_us/tag/?http://mail.yahoo.com/">Yahoo! Mail</a>.
--0-699975917-1011809970=:76198--

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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20020123181930.76205.qmail>