Slim Application Error: SQLSTATE[HY000] [2002] Connection refused in XAMPP

Question

I am programming an application by using the Slim Framework in PHP and MySQL. I am on Mac OS X and using XAMPP.

I have tried this solution but no luck.

In my phpmyadmin I have the root user's servers in the three modes:

%
linux
localhost

This is the code of configs to connect to the database:

'db'    =>  [
    'driver'    =>  'mysql',
    'host'      =>  '127.0.0.1',
    'name'      =>  'rl',
    'username'  =>  'root',
    'password'  =>  'the_password',
    'charset'   =>  'utf8mb4',
    'collation' =>  'utf8mb4_unicode_ci',
    'prefix'    =>  ''
],

Any ideas to fix this?

FIXED

I changed 127.0.0.1 for localhost and now it works!

Now the question is, how can i make it work by using 127.0.0.1?

Can you try to login using the command line or any other software? — Davide Pastore, Jun 29 '15 at 22:35
Yeah, i tried this and decided to try `localhost` instead and now it works! But then how can i make it to work with `127.0.0.1`? — Pathros, Jun 30 '15 at 17:06
Can you check [this](http://serverfault.com/a/544196/276936)? — Davide Pastore, Jul 01 '15 at 07:02

score 0 · Answer 1 · answered Apr 09 '18 at 16:59

I had simmilar problem and the charset was wrong and it should be just utf8 like that:

'db'    =>  [
    'driver'    =>  'mysql',
    'host'      =>  'localhost',
    'name'      =>  'rl',
    'username'  =>  'root',
    'password'  =>  'the_password',
    'charset'   =>  'utf8',
    'collation' =>  'utf8_unicode_ci',
    'prefix'    =>  ''
],

Slim Application Error: SQLSTATE[HY000] [2002] Connection refused in XAMPP

1 Answers1