0

I got following errors when I start the server. I did not changed any password or username before stop the xampp and shutdown the computer.

Cannot connect: invalid settings.
Packets out of order. Expected 0 received 1. Packet size=68
mysqli::real_connect(): Error while reading greeting packet. PID=5140
mysqli::real_connect(): (HY000/2006): MySQL server has gone away
Connection for controluser as defined in your configuration failed.
Packets out of order. Expected 0 received 1. Packet size=68
mysqli::real_connect(): Error while reading greeting packet. PID=5140
mysqli::real_connect(): (HY000/2006): MySQL server has gone away
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.

enter image description here

Update: when I changed the $cfg['Servers'][$i]['AllowNoPassword'] = true; to false; now only shows following error

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.
Sandeep Himasha
  • 273
  • 1
  • 3
  • 8
  • is mysql still running in the background? or are you trying to connect different machine? – Bagus Tesa Oct 21 '22 at 06:41
  • @BagusTesa It's run in the background. no it's the same machine xampp installed. – Sandeep Himasha Oct 21 '22 at 07:12
  • check in the file `xampp\phpMyadmin\config.inc.php`, take a look on the `$cfg['Servers'][$i]['host']`, is it pointing to `127.0.0.1`? if yes, see if you have newly installed firewall/anti virus. – Bagus Tesa Oct 21 '22 at 08:58
  • @BagusTesa Yes it is pointing to 127.0.0.1 I use only windows security and already turned off the firewalls and checked. – Sandeep Himasha Oct 21 '22 at 09:25
  • ok, the error message changed.. so.. some progress i guess.. is the `root` still have no password? – Bagus Tesa Oct 21 '22 at 10:38
  • oh, also double check firewall settings, see if `php` somehow blocked there. – Bagus Tesa Oct 21 '22 at 10:39
  • @BagusTesa Yes it is root and no password. how I find the php block in the firewall? I use windows – Sandeep Himasha Oct 21 '22 at 11:14
  • If you are facing any error message, please share it in text form – Nico Haase Oct 21 '22 at 11:14
  • thats odd, i'm running out of checklist. if the `root` has no password `AllowNoPassword` being `true` is the correct one. anyway, you can open windows firewall following [this guide](https://learn.microsoft.com/en-us/windows/security/threat-protection/windows-firewall/open-windows-firewall-with-advanced-security). oh right, is the problem persist after you did some changes to your machine? try to think back what you have done so far before the issue arise. – Bagus Tesa Oct 21 '22 at 14:07
  • oh right, running out of memory can also cause `mysql` to be sluggish and unresponsive. double check how much of ram you have left. and don't forget, try to restart your computer and see if the problem persist. more than often naughty software or driver leaking memory in the background. if that was the case, you gotta fix it first. – Bagus Tesa Oct 21 '22 at 14:12
  • @BagusTesa I will go through the gudie. I installed the day to day updates that include windows defender updates and turned off the computer. – Sandeep Himasha Oct 21 '22 at 15:23
  • @BagusTesa I found the solution by reinstall the xampp and add old databases folders to the mysql/data folder. and replaced the ibdata1 file with the old one. but can't able to find real solution and cause. when observe the sql log files I found the following error ```[ERROR] InnoDB: Page [page id: space=0, page number=243] log sequence number 381975 is in the future! Current system log sequence number 300306.``` in several times. I searched that error and found this thread https://stackoverflow.com/questions/71558617/access-denied-on-phpmyadmin-using-xampp symptoms are same – Sandeep Himasha Oct 21 '22 at 17:49

0 Answers0