php - phpMyAdmin mysqli::real_connect(): (HY000/2002): Connection refused ← (PHP, MySQL)

I'm tring to set up phpmyadmin on my mac, mysql already running on my mac, but I got mysqli::real_connect(): (HY000/2002): Connection refused error, anyone knows how to fix it, thanks


this is the phpmyadimin page


mysql is working on my mac

Answer



Answer



Answer



Answer



Answer



------

config.inc.php file:

<?php
/*
 * Generated configuration file
 * Generated by: phpMyAdmin 5.0.4 setup script
 * Date: Tue, 20 Oct 2020 11:36:42 +0000
 */

/* Servers configuration */
$i = 0;

/* Server: 127.0.0.1 [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'password';

/* End of servers configuration */

$cfg['blowfish_secret'] = 'C0DH:ogx;5K1W`tteE3T%xL`0TzHYSD~';
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>

Source