Re: Username/Password Basics

2004-06-02 Thread David Blomstrom
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

Re: Username/Password Basics

2004-06-02 Thread Paul DuBois
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,

Re: Username/Password Basics

2004-06-02 Thread Lou Olsten
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