It's MySQL adding the @localhost.  You need to add the usr at localhost to
MySQL and give it permissions on the database that you need access to.  
 
For example:
Login to the database:
bash$  mysql -u root -p
 
Create the user and grant permissions on the database:
mysql>  grant INSERT,SELECT,DELETE on databasename.* to usr at localhost;
 
This should fix your problem.  Replace "databasename" witht the name of the
database your php stuff is using.
 
Jay

-----Original Message-----
From: Brett Astleford [mailto:bastleford at platinumdg.com]
Sent: Monday, December 04, 2000 8:55 AM
To: tclug-list at mn-linux.org
Subject: [TCLUG] php&&mysql


hello all,
 
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 at localhost.  Mysql
doesn't like that @localhost.  So is that conf in php, mysql or what???
 
TIA

Brett Astleford 
Platinum Design Group 
bastleford at platinumdg.com <mailto:bastleford at platinumdg.com> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://shadowknight.real-time.com/pipermail/tclug-list/attachments/20001204/f3e124f4/attachment.html