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> 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!!. <P>my $0.02 <P> <B><I>Andre` Niel Camerown <AndreC@Axxs.net></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 <<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> grant all privileges on users to thegamersoutlet@"%" identified by<BR>'shibumi';<BR>Query OK, 0 rows affected (0.00 sec)<BR><BR>mysql> 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>