Re: How do I regain the ability to create databases

Martin Luethi wrote:

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.