phpMyAdmin 嘗試串連到 MySQL 伺服器，但伺服器拒絕串連。您應該檢查設定檔中的主機、使用者名稱和密碼

標籤：

需要修改phpmyadmin的設定檔，讓其串連到MySQL資料庫，用記事本開啟 config.inc.php 檔案

 1 <?php 2  3 /* Servers configuration */ 4 $i = 0; 5  6 /* Server: localhost [1] */ 7 $i++; 8 $cfg[‘Servers‘][$i][‘verbose‘] = ‘localhost‘; 9 $cfg[‘Servers‘][$i][‘host‘] = ‘localhost‘;10 $cfg[‘Servers‘][$i][‘port‘] = ‘3306‘;11 $cfg[‘Servers‘][$i][‘socket‘] = ‘‘;12 $cfg[‘Servers‘][$i][‘connect_type‘] = ‘tcp‘;13 $cfg[‘Servers‘][$i][‘extension‘] = ‘mysqli‘;14 $cfg[‘Servers‘][$i][‘auth_type‘] = ‘config‘;15 $cfg[‘Servers‘][$i][‘user‘] = ‘root‘;16 $cfg[‘Servers‘][$i][‘password‘] = ‘‘;17 $cfg[‘Servers‘][$i][‘AllowNoPassword‘] = true;18 19 /* End of servers configuration */20 21 $cfg[‘DefaultLang‘] = ‘en-utf-8‘;22 $cfg[‘ServerDefault‘] = 1;23 $cfg[‘UploadDir‘] = ‘‘;24 $cfg[‘SaveDir‘] = ‘‘;25 26 27 /* rajk - for blobstreaming */28 $cfg[‘Servers‘][$i][‘bs_garbage_threshold‘] = 50;29 $cfg[‘Servers‘][$i][‘bs_repository_threshold‘] = ‘32M‘;30 $cfg[‘Servers‘][$i][‘bs_temp_blob_timeout‘] = 600;31 $cfg[‘Servers‘][$i][‘bs_temp_log_threshold‘] = ‘32M‘;32 33 34 ?>

 

phpMyAdmin 嘗試串連到 MySQL 伺服器，但伺服器拒絕串連。您應該檢查設定檔中的主機、使用者名稱和密碼