Duh, ignore this message; I had my head misthreaded when I screwed it
on this morning.
Date: 10 Apr 2001 17:01:48 -0700
From: Rusty Wright <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: only 1 entry per user in user table?
What I want is there to just be 1 password entry for each user,
ignoring the host. As it is now the password is tied to both the user
and host. I would also like to be able to globally specify the hosts
that can connect to the server, ignoring the user, password, and
databases.
CC: [EMAIL PROTECTED]
Subject: Re: only 1 entry per user in user table?
If you mean use % for the host in the user table, that has the
negative consequence that they can connect to the mysql server from
any machine on the internet; e.g. they can do
mysql -p -u dentry -h hishos
o the server. If they were to somehow know the user name
(for example, a disgruntled former employee) they could use this to do
a brute-force password search.
From: "Jason Brooke" <[EMAIL PROTECTED]>
To: "Rusty Wright" <[EMAIL PROTECTED]>, <[EMAIL PROT
Did you try using % for the host instead?
> I'm trying to set it up so that I have only 1 entry per user in my
> mysql user table. My users will have the same privileges regardless
> of what host they come in from. There's only 1 database they'll be
> working with. There are 2 users, user "d
I'm trying to set it up so that I have only 1 entry per user in my
mysql user table. My users will have the same privileges regardless
of what host they come in from. There's only 1 database they'll be
working with. There are 2 users, user "dentry" can add and edit
information in the database n