Apache Friends Support Forum

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:

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

Which ports did you change exactly?

changed apache httpd. conf to 8888
and mysql myini to 3307

also i uninstalled xampp 736 and tred the latest 3.7
that did not work either so i am trying 735 presently

no same errors on xampp 735

ok i have tried so many fixes

here are my steps after install on w10.
I open the C:\xampp\apache\conf\httpd.conf file and change the port:

Code: Select all

#Listen 12.34.56.78:80
Listen 8888

next I open C:\xampp\mysql\bin\my.ini and change the ports to 3307:

Code: Select all

# The following options will be passed to all MySQL clients
[client]
# password       = your_password
port            = 3307
socket          = "C:/xampp/mysql/mysql.sock"

Code: Select all

# The MySQL server
[mysqld]
port= 3307
socket = "C:/xampp/mysql/mysql.sock"
basedir = "C:/xampp/mysql"
tmpdir = "C:/xampp/tmp"
datadir = "C:/xampp/mysql/data"
pid_file = "mysql.pid"
# enable-named-pipe
key_buffer = 16M

then i go to the xampp control panel and in upper right corner
under config>>>services and port settings>>> under mysql:
I change the port to 3307.

next I start apache and mysql:
no errors, I test in chrome,
localhost:8888

So far everything is fine. I press the tab phpmyadmin.
I get these errors:

Welcome to phpMyAdmin

Error
MySQL said: Documentation

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.



Ok Ok Ok time to troubleshoot.

netstat from control panel
3307--mysqld
8888--apache

I have started xampp with admin rights

i have messed around a little with phpmyadmin put in a password, changed 127.0.0.1 to localhost. still nothing changed it back to where it was.

turned off windows firewall, anyway I use comodo firewall.


Still stuck?????????????????????

How did you tell phpmyadmin the new MariaDB port?

TY SO MuCH!!!!!
Spent a lot of time on this.

changed this line:
$cfg['Servers'][$i]['host'] = '127.0.0.1';

to
$cfg['Servers'][$i]['host'] = '127.0.0.1:3307';

earlier I kept changing this to 127.0.0.1:8888

I see the mistake now.

Thanks Again.

You don't need to specify that in the host setting, there is a port setting too.

zpupster wrote:TY SO MuCH!!!!!
Spent a lot of time on this.

changed this line:
$cfg['Servers'][$i]['host'] = '127.0.0.1';

to
$cfg['Servers'][$i]['host'] = '127.0.0.1:3307';

earlier I kept changing this to 127.0.0.1:8888

I see the mistake now.

Thanks Again.

===============
Hi !
Where is the file that you change 127.0.0.1 to 127.0.0.1:3307 ?
Thanks.

The file is /phpmyadmin/config.inc.php

But you should not change the host parameter.
Instead you should add a new line after the host parameter

Code: Select all

$cfg['Servers'][$i]['port'] = '3307';

Hi !
If I don't want to change port of mySQL (until 3306), only change port of Apache from 80 to 8080 ?
Thanks

Then there is nothing to do for you in the phpmyadmin configuration.

Altrea wrote:The file is /phpmyadmin/config.inc.php

But you should not change the host parameter.
Instead you should add a new line after the host parameter

Code: Select all

$cfg['Servers'][$i]['port'] = '3307';

Thanks.
After add that one, can I update more ? Or add only that line, not 80 to 8080, 443 to 4433 (for example)

You can find all config settings in the official phpmyadmin manual: http://docs.phpmyadmin.net/en/release_4 ... onfig.html