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
Hmmmm... I'm a little confused. I don't find that particular code in my phpMyAdmin config file. But I suspect I may have done an unorthodox maneuver.
If I remember correctly, it instructed me to replace "user" with my user name on line 81 (see below) and type in a password on the next line.
* * * * * * * * * *
4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db"
tables)
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
[LINE 81] $cfg['Servers'][$i]['user'] = ''; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config'
auth_type)
$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only
* * * * * * * * * *
HOWEVER, it said the better method was to type in either "http" or (I can't remember the second choice offhand). I think I did it on line 133 (see below.
$cfg['Servers'][$i]['controlpass'] = ''; [LINE 133] $cfg['Servers'][$i]['auth_type'] = 'http'; $cfg['Servers'][$i]['user'] = 'root';
* * * * * * * * * *
It sounds like I need to go back and change these two lines:
[LINE 81] $cfg['Servers'][$i]['user'] = ''; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config'
inserting my username ("root") between the first = ''; then typing in my password between the next = '';
Then I need to go back and delete http; does that sound right?
I copied the original config file, so I could start from scratch.
Thanks.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php