phpmyadmin errors

Problems with the Windows version of XAMPP, questions, comments, and anything related.

phpmyadmin errors

Postby zpupster » 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:

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
zpupster
 
Posts: 6
Joined: 30. July 2019 13:28
XAMPP version: 7.36
Operating System: windows 10

Re: phpmyadmin errors

Postby Altrea » 30. July 2019 16:16

Which ports did you change exactly?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: phpmyadmin errors

Postby zpupster » 30. July 2019 19:50

changed apache httpd. conf to 8888
and mysql myini to 3307
Last edited by zpupster on 30. July 2019 20:21, edited 1 time in total.
zpupster
 
Posts: 6
Joined: 30. July 2019 13:28
XAMPP version: 7.36
Operating System: windows 10

Re: phpmyadmin errors

Postby zpupster » 30. July 2019 19:52

also i uninstalled xampp 736 and tred the latest 3.7
that did not work either so i am trying 735 presently
zpupster
 
Posts: 6
Joined: 30. July 2019 13:28
XAMPP version: 7.36
Operating System: windows 10

Re: phpmyadmin errors

Postby zpupster » 30. July 2019 20:21

no same errors on xampp 735
zpupster
 
Posts: 6
Joined: 30. July 2019 13:28
XAMPP version: 7.36
Operating System: windows 10

Re: phpmyadmin errors

Postby zpupster » 30. July 2019 21:25

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?????????????????????
zpupster
 
Posts: 6
Joined: 30. July 2019 13:28
XAMPP version: 7.36
Operating System: windows 10

Re: phpmyadmin errors

Postby Altrea » 30. July 2019 21:58

How did you tell phpmyadmin the new MariaDB port?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: phpmyadmin errors

Postby zpupster » 31. July 2019 00:46

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.
zpupster
 
Posts: 6
Joined: 30. July 2019 13:28
XAMPP version: 7.36
Operating System: windows 10

Re: phpmyadmin errors

Postby Altrea » 31. July 2019 00:50

You don't need to specify that in the host setting, there is a port setting too.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: phpmyadmin errors

Postby RobertMichaelin » 06. November 2019 14:56

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.
RobertMichaelin
 
Posts: 6
Joined: 05. November 2019 10:38
XAMPP version: 7.3
Operating System: windows

Re: phpmyadmin errors

Postby Altrea » 06. November 2019 15:45

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';
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: phpmyadmin errors

Postby RobertMichaelin » 06. November 2019 15:54

Hi !
If I don't want to change port of mySQL (until 3306), only change port of Apache from 80 to 8080 ?
Thanks
RobertMichaelin
 
Posts: 6
Joined: 05. November 2019 10:38
XAMPP version: 7.3
Operating System: windows

Re: phpmyadmin errors

Postby Altrea » 06. November 2019 15:55

Then there is nothing to do for you in the phpmyadmin configuration.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: phpmyadmin errors

Postby RobertMichaelin » 13. November 2019 11:18

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)
RobertMichaelin
 
Posts: 6
Joined: 05. November 2019 10:38
XAMPP version: 7.3
Operating System: windows

Re: phpmyadmin errors

Postby Altrea » 13. November 2019 12:04

You can find all config settings in the official phpmyadmin manual: http://docs.phpmyadmin.net/en/release_4 ... onfig.html
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 134 guests