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]

Reply via email to