<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>MySQL Question</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT FACE="Courier">Before I pull my remaining two hairs out of my head....</FONT>
</P>
<P><FONT FACE="Courier">I have 2 Linux servers Server1 running mysqld, and Server2. I want to create a user that can access a database on Server1 from both machines.</FONT></P>
<P><FONT FACE="Courier">So I create a user 'Bob'@'%'</FONT>
</P>
<P><FONT FACE="Courier">I can happily access the database from Server2 using the command:</FONT>
</P>
<P><FONT FACE="Courier">mysql -h Server1 -u Bob -p</FONT>
</P>
<P><FONT FACE="Courier">But when I go on Server1 & type in</FONT>
</P>
<P><FONT FACE="Courier"> mysql -u Bob -p I get "Access denied for user 'Bob'@'localhost'"</FONT>
<BR><FONT FACE="Courier"> mysql -u 'Bob'@'%' -p I get "Access denied for user 'Bob'@'%'@'localhost'"</FONT>
<BR><FONT FACE="Courier"> mysql -h Server1 -u Bob -p I get "Access denied for user 'Bob'@'Server1'"</FONT>
</P>
<P><FONT FACE="Courier">The only way I cam make it work is to create ANOTHER user 'Bob'@'localhost' and try to maintain passwords & privileges between the two accounts. Yuk!</FONT></P>
<P><FONT FACE="Courier">BTW myphpadmin has a similar issue in that it appends @localhost to every user ID entered.</FONT>
</P>
<P><FONT FACE="Courier">TErry</FONT>
</P>
<br>http://www.bbc.co.uk/<br><br>This e-mail (and any attachments) is confidential and may contain<br>personal views which are not the views of the BBC unless specifically<br>stated.<br>If you have received it in error, please delete it from your system. <br>Do not use, copy or disclose the information in any way nor act in<br>reliance on it and notify the sender immediately. Please note that the<br>BBC monitors e-mails sent or received. <br>Further communication will signify your consent to this.</BODY>
</HTML>