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 host. So, [EMAIL PROTECTED] is really one user, [EMAIL PROTECTED] is another user, and so on. When MySQL resolves the connection, I believe it first looks at the host for resolution. 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' 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 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 standard platform on > which all the databases rest. > > I believe all my databases have the same setting - > localhost, newbie_user, Newbie > > Those aren't my real username and password, of course. > But I THINK newbie_user and Newbie are the username > and password for localhost, and none of my databases > have usernames or passwords. So how do I create one? > > I thought I remembered seeing the password command in > phpMyAdmin, but I can't find it now. > > And if I create a database username and password on > top of a localhost username and password, am I going > to have to log in with two usernames and passwords? > > Then again, I could be mistaken about the localhost > username and password; it might be that newbie_user > and Newbie are a DATABASE username and password shared > by all my databases. > > > > > __________________________________ > Do you Yahoo!? > Friends. Fun. Try the all-new Yahoo! Messenger. > http://messenger.yahoo.com/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
