WampServer

Hi,
since few days I can not log in into my phpmyadmin on localhost and all my sites on localhost break down because there is no connect to database. I did not change username or password so how it is happend? And what to do?
I am sure that I have correct username and password. I used these ones from last two years so somehow or someone it must had changed (username or password or both)

Could you please tell me what to do?
Regards
Daniel

Hi,

Please READ (and answer) BEFORE YOU ASK A QUESTION

And, after answering all the questions above, one last:
Do you have access to the MySQL console?
- Left-Click Wampmanager tray icon -> MySQL -> MySQL Console
On request "Enter password:" type the password you assigned to root, if you did not put one, just press the Enter key, you must get a window like this:

Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.17 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Whatever the error messages are, please copy them exactly as they are.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Hi

Please also check your MYSQL Error Log

- left click wampmanager->MYSQL->MySQL Log

And go to the bottom of the file and look for error messages. If there are any, and the error is not obvious, post a representative few of them from the LAST MySQL Startup attemp

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Hello,

1 - Windows 10 Home version 1607 64 bit
2 - WampServer Version 3.0.0 64bit
3 - Apache/2.4.17 (Win64) PHP/5.6.16
4 - PHP Version 5.6.16
5 - MySQL Version 5.7.9
6 - What color is the WampServer icon (in the notification area of the taskbar)
----- Green
7 - In the file c:\Windows\System32\drivers\etc\hosts, what are the active lines with the name [localhost] in them?
* Active means no # at the beginning of the line.

-----Yes, I think I don't have active because everywhere is #. Check screenshot. But How to change this?


8 - Do you have access to localhost (Homepage WampServer)?
----- Yes
8a - If so, is there an error message at the bottom of the page?
----- No

9 - Do you have access to phpMyAdmin?
----- No

10 - If you refer to an error message, please include the EXACT wording of the error in your post
----- "Cannot log in to the MySQL server"

11 - If you use an Antivirus and / or Firewall, please include the names of these
----- ESET NOD32 Antivirus version 9.0.407.0

12 - What is the full path to the installation of WampServer (eg D:\wamp\)
----- D:\wamp64

13 - If you have one or more Virtual Hosts defined, please show their definition(s)
----- I haven't

14. Do you have access to the MySQL console?
----- No, I don't. When I press "enter" window just disappears

15. Please also check your MYSQL Error Log
----- There are all my MySql errors:

2016-03-02T17:05:00.239307Z 0 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*320 pages, LSN=2473037
2016-03-02T17:05:00.408544Z 0 [Warning] InnoDB: Starting to delete and rewrite log files.
2016-03-02T17:05:00.725909Z 0 [Warning] InnoDB: New log files created, LSN=2473037

Regards
Daniel

ad. 7
I forgot about screenshot: [www.screencast.com]

Hi

Your HOSTS file shoudl look like this

127.0.0.1 localhost

::1 localhost

I guess you can leave the mcafee line in there, but I assume this is to stop reporting home to mcafee because its a ripped off version. Maybe this is part of your problem.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

What should I do?

Did you allow Apache access through your firewall when it first started and the firewall ask you if you wanted to allow this access?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

I don't think so but I am not sure

Then you will have to check your firewall rules

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

I don't know how to do this.

Then you will have to read up on your firewall and how to use it.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-