Lou Olsten wrote, "You do not have to put a user into
the system for every location from
which
you want to connect. Instead, you can use wildcards
like:
GRANT ON *.* to 'Newbie'@'196.168.168.%'
or maybe 'Newbie'@'%.yourdomain.com'"
I don't know how to work with wildcards, but are you
descr
At 7:22 -0700 6/2/04, David Blomstrom wrote:
I've been studying MySQL for a few weeks now and am
about ready to publish some databases online. But I'm
confused about usernames and passwords. I understand
you can create usernames and passwords on three or
four different levels, like root, database,
David,
Think of users as the concatenation of the user and the host from which the
user is connecting. That's why in your GRANT statement, you will see the
'user'@'host' semantic employed.
When you say 'localhost' you're telling MySQL that the user you are
specifying is connecting from the local