Apache Friends Support Forum

first go i set a username and password in phpmyadmin. then went to phpmyadmin and used same user and password and can't log in. changed the config.ini.php file to reflect u and p restarted windows and still can't log in to mysql server.?
any help or suggestions would be vastly appreciated. thank you.

Where exactly did you set Username and Password? Setting username and password in the config.inc.php does not work without further configuration, you also have to change the authentication method. However, I do not recommend this setup, because that kind of renders the use of Credentials useless.

i now know what username and password i used. it was for mysql server in xampp localhost. i used cookies for authentication. should i change that? and i did change config.ini.php, but not correct settings for user nor password. should i leave them blank? that's for continued support. i'd be lost without your knowledge and willingness to share.

Please answer my question: Where exactly did you set your password? In the phpMyAdmin Interface or the XAMPP Security Console?

I recommend using a minimal configuration for phpMyadmin:

Code: Select all

<?php
$cfg['blowfish_secret'] = 'CHANGEME!!!';
$i = 0;
$i++;
$cfg['Servers'][$i]['auth_type']     = 'cookie';      // Authentication method (config, http or cookie based)
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
?>

thanks. i have set up everything and now i'm in wordpress and will configure themes etc tomorrow.
you have been a real help and the sign of intelligence is to share knowledge. that;s you.
thank you very much i'm sure that by helping me you have helped many others.

is control panel supposed to self start? mine does as soon as it boots apache and mysql start up? never happened previously.