[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cobalt-users] MySQL Database



>  * The 'cookie' auth_type uses blowfish algorithm to encrypt the password.
>  * If at least one server configuration uses 'cookie' auth_type,
>  * enter here a passphrase that will be used by blowfish.
>  */
> $cfg['blowfish_secret'] = 'c0b@ltr@Q';

Not relevant, but good to know/notice...

> $cfg['Servers'][$i]['auth_type']     = 'http';    // Authentication method
> (config, http or cookie based)?

So it's apparently using .htaccess files for it's authentication. Check the 
file in the web dir(s) for the domain(s) this is installed under.

If there is no .htaccess file, you'll need to make one.

Remember you can always start MySQL manually with the --skip-grant-tables 
option to bypass the passwords if you don't know/can't figure out what root's 
is.  Then set root's password via mysqladmin and flush the grants table (all 
well documented on the MySQL site).

Then you could reset/rebuild/create the .htaccess file to put the new password 
in for root.

Likewise for other users who you grant access to certain databases/tables/etc, 
but that will all come after you have phpMyAdmin up and running.

> $cfg['Servers'][$i]['user']          = 'root';      // MySQL user

'root' should apparently still be the MySQL 'master' user...