[SWLUG] MySQL Question

[Terry John]

Before I pull my remaining two hairs out of my head....

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.

So I create a user 'Bob'@'%'

I can happily access the database from Server2  using the command:

mysql -h Server1 -u Bob -p

But when I go on Server1 & type in

  mysql -u Bob -p               I get "Access denied for user
'Bob'@'localhost'"
  mysql -u 'Bob'@'%' -p         I get "Access denied for user
'Bob'@'%'@'localhost'"
  mysql -h Server1 -u Bob -p    I get "Access denied for user
'Bob'@'Server1'"

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!

BTW myphpadmin has a similar issue in that it appends @localhost to
every user ID entered.

TErry

http://www.bbc.co.uk/

This e-mail (and any attachments) is confidential and may contain
personal views which are not the views of the BBC unless specifically
stated.
If you have received it in error, please delete it from your system. 
Do not use, copy or disclose the information in any way nor act in
reliance on it and notify the sender immediately. Please note that the
BBC monitors e-mails sent or received. 
Further communication will signify your consent to this.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.lug.org.uk/pipermail/swlug/attachments/20050624/b098aa86/attachment.html>