<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.3103.1000" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=810435215-04122000>It's
MySQL adding the @localhost. You need to add the usr@localhost to MySQL
and give it permissions on the database that you need access to.
</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=810435215-04122000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=810435215-04122000>For
example:</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=810435215-04122000>Login
to the database:</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=810435215-04122000>bash$ mysql -u root -p</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=810435215-04122000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=810435215-04122000>Create
the user and grant permissions on the database:</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=810435215-04122000>mysql> grant INSERT,SELECT,DELETE on
databasename.* to usr@localhost;</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=810435215-04122000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=810435215-04122000>This
should fix your problem. Replace "databasename" witht the name of the
database your php stuff is using.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=810435215-04122000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=810435215-04122000>Jay</SPAN></FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Brett Astleford
[mailto:bastleford@platinumdg.com]<BR><B>Sent:</B> Monday, December 04, 2000
8:55 AM<BR><B>To:</B> tclug-list@mn-linux.org<BR><B>Subject:</B> [TCLUG]
php&&mysql<BR><BR></DIV></FONT>
<DIV><FONT face=Tahoma size=2>hello all,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Tahoma size=2>I gotta problem, however this problem wanes
between programming & system administration. Here it goes, when I
log in mysql I get in fine. But when I try through code, something adds
@localhost, example usr@localhost. Mysql doesn't like that
@localhost. So is that conf in php, mysql or what???</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Tahoma size=2>TIA</FONT></DIV>
<DIV><FONT face=Tahoma size=2><BR>Brett Astleford <BR>Platinum Design Group
<BR><A
href="mailto:bastleford@platinumdg.com">bastleford@platinumdg.com</A></FONT></DIV></BLOCKQUOTE></BODY></HTML>