[SWLUG] MySQL Question

[Terry John]

I've left the anon user as default. Anyone can mess about with the
"test" database but that's all - Terry

-----Original Message-----
From: discuss-bounces at swlug.org.uk [mailto:discuss-bounces at swlug.org.uk]
On Behalf Of Bron
Sent: 24 June 2005 18:12
To: discuss at swlug.org.uk
Subject: Re: [SWLUG] MySQL Question


On Fri, 2005-06-24 at 15:30, Terry John wrote:

> 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'"
> 
Are you allowing the anon. user to access the MySQL server on your
Server1.? 
This special account is created on install and is used when named users
try to log in locally.
- If so you should grant privs to all local users explicitly. [Remember
to flush afterwards]
- Or, delete this anon. user from mysql.user table.



_______________________________________________
SWLUG Discussion List - Discuss at swlug.org.uk
http://list.swlug.org.uk/mailman/listinfo/discuss

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.