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 <[EMAIL PROTECTED]>:
--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
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php