Username/Password Basics

2004-06-02 Thread David Blomstrom
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, etc. As I understand it, localhost is the

Re: Username/Password Basics

2004-06-02 Thread Lou Olsten
can use wildcards like: GRANT ON *.* to 'Newbie'@'196.168.168.%' or maybe 'Newbie'@'%.yourdomain.com' Lou - Original Message - From: David Blomstrom [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 10:22 AM Subject: Username/Password Basics I've been studying

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 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