I am setting up a mass email server (all the .sql files working correctly, can use username and pass to use MySQL workbench. To send the emails I need to run a .php file (through XAMPP) when I try this I get the error: Access denied for user 'xxxxx'@'localhost' (using password: YES) (xxx is my user). I will post a snippet of my config.inc file within XAMPP (me trouble shooting using previous answers on here but none seem to work) I assume the issue lays somewhere in here. I am a bit of a newbie so thank you for any help you can give :)

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'MY_USERNAME';
$cfg['Servers'][$i]['password'] = 'MY_PASSWORD';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'MY_PASSWORD';

0 Answers