[no subject]

Great,  thanks.

Looks like part of it was I had the ' around username and host screwed
up.  Also mysql binds to localhost only by default which doesn't work
with the database on one system and web server on another.

Robert

Thus spake Christopher Coleman (Christopher.Coleman at nsc.com):

> mysql> GRANT ALL PRIVILEGES on database_name.* to username@'%';"
> mysql> SET PASSWORD FOR username@'%' = PASSWORD( 'password' );"
> mysql> FLUSH PRIVILEGES;"
> mysql> SHOW GRANTS FOR username@'%';"
> 
> Robert L. Harris wrote:
> >
> >  Has anyone set up a fresh mysql database for use with gallery2?  I'm
> >trying to set it up and mysql isn't happy with my user creation
> >commands?  Anyone have a typescript or HOWTO for creating a user?  I
> >have notes on creating databases, etc...
> >
> >
> >:wq!
> >---------------------------------------------------------------------------
> >Robert L. Harris                     | GPG Key ID: E344DA3B
> >
> >DISCLAIMER:
> >      These are MY OPINIONS             "We can't solve problems by using
> >       ALONE.  I speak for                the same kind of thinking we used
> >       no-one else.                         when we created them."
> >                                          - Einstein
> >
> >
> >
> >------------------------------------------------------------------------
> >
> >_______________________________________________
> >Ale mailing list
> >Ale at ale.org
&gt; &gt;<a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>


&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>

:wq!
---------------------------------------------------------------------------
Robert L. Harris                     | GPG Key ID: E344DA3B

DISCLAIMER:
      These are MY OPINIONS             &quot;We can't solve problems by using
       ALONE.  I speak for                the same kind of thinking we used
       no-one else.                         when we created them.&quot;
                                          - Einstein

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature



</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00285" href="msg00285.html">[ale] mysql and gallery2? (creating users)</a></strong>
<ul><li><em>From:</em> Robert.L.Harris at rdlg.net (Robert L. Harris)</li></ul></li>
<li><strong><a name="00286" href="msg00286.html">[ale] mysql and gallery2? (creating users)</a></strong>
<ul><li><em>From:</em> Christopher.Coleman at nsc.com (Christopher Coleman)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00286.html">[ale] mysql and gallery2? (creating users)</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00288.html">[ale] L.A.M.P. Server Setup</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00286.html">[ale] mysql and gallery2? (creating users)</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00290.html">[ale] OT: Ripping Instant Immersion Spanish</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00287"><strong>Date</strong></a></li>
<li><a href="threads.html#00287"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

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