Hi all,
This question should be, and probably is in, the FAQ -- but either the
FAQ or my fonts are hosed and I couldn't read the FAQ very well at all.
Apologies up front if it's in there.
I'm trying to figure out a graceful way to allow a user account access
to a DB from both 'localhost' as well as off-host ('%') without having 2
separate entries for the user in the 'mysql.user' table. I'm trying to
do this as, inevidably, a user will not keep their passwords
(user@localhost and user@%) in sync. and they're not necessarily skilled
at understanding they have 2 DB accounts with 2 separate passwords.
I would tend to think that granting access to user@'%' would also allow
connections from localhost, but apparently this is not so. I'm working
with MySQL 3.23.36, Red Hat Linux 7.1. And yes BTW -- my /etc/hosts is
setup properly :-)
TIA,
-Fred
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
