phpmyadmin errors
Posted: 30. July 2019 13:51
hello forum,
new to xampp. installed xampp ok, i changed the ports because i have other servers running on my windows.
when trying to start phpmyadmin I get these errors:
below is the xampp control panel messages:
I tried putting a password in between the single quotes, here is the phpmyadmin config.inc.php file as it stands.
There are many errors. I have tried many other things but the errors remain
Any suggestions???????
TY
Zpupster
new to xampp. installed xampp ok, i changed the ports because i have other servers running on my windows.
when trying to start phpmyadmin I get these errors:
- Code: Select all
Error
Cannot connect: invalid settings.
mysqli_real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.
Connection for controluser as defined in your configuration failed.
mysqli_real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
below is the xampp control panel messages:
- Code: Select all
7:24:15 AM [main] Initializing Control Panel
7:24:15 AM [main] Windows Version: Enterprise 64-bit
7:24:15 AM [main] XAMPP Version: 7.3.6
7:24:15 AM [main] Control Panel Version: 3.2.4 [ Compiled: Mar 7th 2019 ]
7:24:15 AM [main] Running with Administrator rights - good!
7:24:15 AM [main] XAMPP Installation Directory: "c:\xampp\"
7:24:15 AM [main] Checking for prerequisites
7:24:15 AM [main] All prerequisites found
7:24:15 AM [main] Initializing Modules
7:24:15 AM [main] Starting Check-Timer
7:24:15 AM [main] Control Panel Ready
7:24:23 AM [Apache] Attempting to start Apache app...
7:24:23 AM [Apache] Status change detected: running
7:24:32 AM [mysql] Attempting to start MySQL app...
7:24:32 AM [mysql] Status change detected: running
I tried putting a password in between the single quotes, here is the phpmyadmin config.inc.php file as it stands.
- Code: Select all
*/
$i = 0;
/*
* First server
*/
$i++;
/* 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'] = '';
/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';
/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
/*
* End of servers configuration
*/
?>
There are many errors. I have tried many other things but the errors remain
Any suggestions???????
TY
Zpupster