How do I regain the ability to create databases (phpMyAdmin)?

From: Date: Fri, 23 Jan 2004 09:26:46 +0000
Subject: How do I regain the ability to create databases (phpMyAdmin)?
Groups: php.general 
Request: Send a blank email to php-general+get-175496@lists.php.net to get a copy of this message
I've finally got both PHP and MySQL up and running, and I've learned how to create new users and databases (at least the basics). But I was told I should add a password to root/localhost, and that's been a major pain in the butt. First, it knocked out phpMyAdmin. Then I learned how to edit a file (phpMyAdmin.config.inc, or something like that), which restored phpMyAdmin. But I next discovered that I can no longer create databases. When I open up phpMyAdmin, near the top of the page is a function for creating new databases. It now says "No Privilieges," just under "Create New Database." I tried to retrace my steps in creating a password. I clicked on Privileges, then clicked Edit in the root/localhost row. Then I went down to where it says "Change Password," clicked the Password radio button and typed in my password twice. I don't think I did anything else. So why would that knock out my databases? More important, how do I get them back? Thanks.

« previous php.general (#175496) next »