mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)
I have it setup as user='root' and no password.
Upon checking my config.inc.php file this is whats there
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';
and at the start of my.ini is
[client]
#password = my-password
port = 3306
socket = "C:/xampp/mysql/mysql.sock"
I am assuming that both are correct. (from what I have read)
I also read the you can put cookie in
$cfg['Servers'][$i]['auth_type'] = 'cookie';
and myphpadmin will ignore the values of "user" and" password". So I changed my config.inc.php file to
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'thepassword';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Lang'] = '';
and got error code
mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)
I have now changed it back to the settings as it was.
What else can I try. thanks