[no subject]

I imagine that would work. Also, you don't have to subscribe to a new
list to ask such a question. The folks in #mysql on freenode are
usually very helpful.

On 6/13/05, Michael B. Trausch <fd0man at gmail.com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
> 
> Having searched about, before subscribing to a new specialty list to ask
> what I rather suspect to be a fairly stupid question, I'm going to ask
> it here:  How in the *world* do you get it so that a MySQL user can only
> see, create, manipulate databases that are their MySQL username, an
> underscore, and their database name?  I've seen this in use in places
> before, where if my MySQL username is fd0man, the only databases I
> create have to be in my own "namespace", e.g.:
> 
>         fd0man_webusers
>         fd0man_phonedb
> 
> Or whatever.  I would then have full permissions to those databases, and
> zero permissions to anything else.  I thought the solution to this
> problem would be to grant full permissions on 'fd0man_%' and have no
> permission to the MySQL database 'mysql' or any other databases on the
> system (e.g., 'mtrausch_%', for example).  However, I can still login to
> something like phpMyAdmin and see everything.  I only want to see what I
> am allowed to see.
> 
> I know it's possible; the question really just is, how?  And why doesn't
> simple searches from Google yield me a result?  Perhaps I'm just too
> stupid to figure out the keywords... I'm still working on that, though.
> 
>         - Mike
> 
> - --
> Michael B. Trausch                                     fd0man at gmail.com
&gt; Web: <a  rel="nofollow" href="http://fd0man.theunixplace.com/";>http://fd0man.theunixplace.com/</a>        Jabber: mtrausch at jabber.com
&gt; Phone: +1-(678)-522-7934                  FAX (US Only): 1-866-806-4647
&gt; =======================================================================
&gt;   Do you have PGP or GPG?  Key at pgp.mit.edu, Please Encrypt E-Mail!
&gt; 
&gt; -----BEGIN PGP SIGNATURE-----
&gt; Version: GnuPG v1.4.1 (GNU/Linux)
&gt; Comment: Using GnuPG with Thunderbird - <a  rel="nofollow" href="http://enigmail.mozdev.org";>http://enigmail.mozdev.org</a>
&gt; 
&gt; iD8DBQFCrYQ4PXInbkqM7nwRAw9HAJ0RW4/lcLRa+UI0aEB4vvoQBILt9QCgn2OU
&gt; XlQep1NCzlsJeVK198YAGVY=
&gt; =1IMz
&gt; -----END PGP SIGNATURE-----
&gt; _______________________________________________
&gt; Ale mailing list
&gt; Ale at ale.org
&gt; <a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>
&gt; 


-- 
James Sumners
<a  rel="nofollow" href="http://james.roomfullofmirrors.com/";>http://james.roomfullofmirrors.com/</a>

&quot;All governments suffer a recurring problem: Power attracts
pathological personalities. It is not that power corrupts but that it
is magnetic to the corruptible. Such people have a tendency to become
drunk on violence, a condition to which they are quickly addicted.&quot;

Missionaria Protectiva, Text QIV (decto)
CH:D 59


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<ul><li><strong>Follow-Ups</strong>:
<ul>
<li><strong><a name="00526" href="msg00526.html">[ale] [Slightly OT] Simple(?) MySQL question</a></strong>
<ul><li><em>From:</em> fd0man at gmail.com (Michael B. Trausch)</li></ul></li>
</ul></li></ul>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00519" href="msg00519.html">[ale] [Slightly OT] Simple(?) MySQL question</a></strong>
<ul><li><em>From:</em> fd0man at gmail.com (Michael B. Trausch)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00519.html">[ale] [Slightly OT] Simple(?) MySQL question</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00521.html">[ale] &quot;resolving host&quot; time, waaaay too long ?</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00519.html">[ale] [Slightly OT] Simple(?) MySQL question</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00526.html">[ale] [Slightly OT] Simple(?) MySQL question</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00520"><strong>Date</strong></a></li>
<li><a href="threads.html#00520"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>