I believe I have granted all priviledges to these user's, and logging in from any machine. I followed a tutorial < <a href="http://dev.mysql.com/doc/refman/5.0/en/adding-users.html">http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
</a> > on mysql for creating users. although it was for a later version it seems to have worked for CLI logon's. I've read where other people have problems with this. they say the only way they got it workiing was through cookie based authentication. However the one file I've found referenced so far I don't seem to have in gentoo.
<br><br><div><span class="gmail_quote">On 5/18/06, <b class="gmail_sendername">Nick Kwiatkowski</b> <<a href="mailto:kwiatk27@msu.edu">kwiatk27@msu.edu</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Make sure that the login you are trying to
use has more privileges than just logging in locally. That is usually the case
of -u root</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">-Nick</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<div>
<div style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">
<hr align="center" size="2" width="100%">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;">
<a href="mailto:linux-user-bounces@egr.msu.edu" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">linux-user-bounces@egr.msu.edu</a> [mailto:<a href="mailto:linux-user-bounces@egr.msu.edu" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
linux-user-bounces@egr.msu.edu</a>] <b><span style="font-weight: bold;">On Behalf Of </span></b>Caleb Cushing<br>
<b><span style="font-weight: bold;">Sent:</span></b> Wednesday, May 17, 2006 9:36
PM<br>
<b><span style="font-weight: bold;">To:</span></b> Linux User<br>
<b><span style="font-weight: bold;">Subject:</span></b> [GLLUG] MySQL phpMyAdmin
login problems</span></font></p>
</div></div><div><span class="q">
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">I'm using the usernames and passwords that I use to logon to mysql on
the command line but they won't authenticate. any Idea's why?<br>
<br>
I've tried looking at the phpmyadmin site but it's docs section isn't working
properly. I'm looking at mysql page... but... to see if I can find anything
that helps... nothing so far. I know this has to be something stupid that I'm
overlooking. </span></font></p>
</span></div><div></div>
</div>
</div></blockquote></div><br>