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 are set. HTH Schalk Neethling AlliedBridge (code.google.com/p/alliedbridge) David Blomstrom wrote:
Sorry for the beginner's question, but I'm confused. I can easily create passwords and usernames for my online databases by going into my C-Panel and clicking a MySQL icon. It fetches a page that allows me to easily create and delete databases, add and change passwords, etc. But I can't remember how I created my password and username for the database on my PC. I'm now trying to duplicate that database on a MacBook Pro running MySQL 5 and the current version of phpMyAdmin. But I'm not sure about creating a password and username with phpMyAdmin. Suppose I have a database named World, and I want to give it the password Global and the username Citizen. I created the database, then clicked the Privileges tab, which took me to the page User 'root'@'localhost' : Edit PrivilegesAm I correct in ignoring everything (Global Privileges, Database-Specific Privileges, etc.) except the section?...
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]