Re: Creating new username password
OK, I think that worked. I didn't get any error messages at least. :) Thanks. --- Eugene Kosov [EMAIL PROTECTED] wrote: David Blomstrom wrote: What's the easiest way to create a username and password for a new database? It's been so long since I created my original database, I forgot how. You can do it with a query like this: GRANT USAGE ON database_name.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'; Replace USAGE in query above with priveleges set you want for your new account. See http://dev.mysql.com/doc/mysql/en/grant.html for more info. Regards, Eugene Kosov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Creating new username password
What's the easiest way to create a username and password for a new database? It's been so long since I created my original database, I forgot how. When I created my new database with phpMyAdmin, I scanned the page looking for anything mentioning username or password but I couldn't find anything. I remember encountering this problem before. It seems only logical to prompt users for a username and password after they've created a database. Or am I missing something? Thanks. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Creating new username password
David Blomstrom wrote: What's the easiest way to create a username and password for a new database? It's been so long since I created my original database, I forgot how. You can do it with a query like this: GRANT USAGE ON database_name.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'; Replace USAGE in query above with priveleges set you want for your new account. See http://dev.mysql.com/doc/mysql/en/grant.html for more info. Regards, Eugene Kosov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]