Re: Creating Password & Username with phpMyAdmin

2007-03-22 Thread David Blomstrom
To: David Blomstrom <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Wednesday, March 21, 2007 1:37:12 AM Subject: Re: Creating Password & Username with phpMyAdmin No need to miss a message. Get e

Re: Creating Password & Username with phpMyAdmin

2007-03-21 Thread David Blomstrom
Ah, that does look like a better way. Thanks! Schalk Neethling <[EMAIL PROTECTED]> wrote: Hi David, Actually the way to do this would be as follows: When you have created a new database, click on the SQL tab and the use the following to create the user and password: GRANT ALL PRIVILEGES ON data

Re: Creating Password & Username with phpMyAdmin

2007-03-21 Thread Schalk Neethling
Hi David, Actually the way to do this would be as follows: When you have created a new database, click on the SQL tab and the use the following to create the user and password: GRANT ALL PRIVILEGES ON databasename.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' Hit the submit button and you