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

check if the user you defined in phpMyAdmin/config.inc.php ($cfg['Servers'][$i]['user'] = ???) has the right to create new databases (db: mysql / table: user / field: Create_priv='Y') restart the mysql-server after altering the database mysql g. martin luethi Fri, 23 Jan 2004 01:26:46 -0800 Freedomware <david_blomstrom@yahoo.com>:

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. --

PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php