Access to phpmyadmin
Posted by: danielB (---.mtm-info.pl)
Date: March 02, 2017 07:53AM

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

Options: ReplyQuote
Re: Access to phpmyadmin
Posted by: Otomatic (Moderator)
Date: March 02, 2017 09:45AM

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.

------------------------------------------------------------------------------------------------------------
(W7 Pro 64 bit)-Wampserver 3.0.8 32 bit - Apache 2.4.25 - PHP 7.1.3/7.0.17/5.6.30 - MySQL 5.7.17 - MariaDB 10.1.21
Wampserver 3.0.8 64 bit - Apache 2.4.25 - PHP 7.1.3/7.0.17/5.6.30 - MySQL 5.7.17 - MariaDB 10.1.22
PhPMyAdmin 4.6.6 - MysqlDumper 1.24.5

Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Access to phpmyadmin
Posted by: RiggsFolly (Moderator)
Date: March 02, 2017 11:02AM

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 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.1.2/7.0.16/5.6.28/5.5.38/5.4.45/5.3.29> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.6.5.2> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: Access to phpmyadmin
Posted by: danielB (---.mtm-info.pl)
Date: March 15, 2017 06:43PM

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

Options: ReplyQuote
Re: Access to phpmyadmin
Posted by: danielB (---.mtm-info.pl)
Date: March 15, 2017 06:44PM

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

Options: ReplyQuote
Re: Access to phpmyadmin
Posted by: RiggsFolly (Moderator)
Date: March 16, 2017 01:56AM

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 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.1.2/7.0.16/5.6.28/5.5.38/5.4.45/5.3.29> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.6.5.2> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: Access to phpmyadmin
Posted by: danielB (---.mtm-info.pl)
Date: March 16, 2017 06:34AM

What should I do?

Options: ReplyQuote
Re: Access to phpmyadmin
Posted by: RiggsFolly (Moderator)
Date: March 16, 2017 10:05AM

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 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.1.2/7.0.16/5.6.28/5.5.38/5.4.45/5.3.29> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.6.5.2> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: Access to phpmyadmin
Posted by: danielB (---.mtm-info.pl)
Date: March 16, 2017 11:17AM

I don't think so but I am not sure

Options: ReplyQuote
Re: Access to phpmyadmin
Posted by: RiggsFolly (Moderator)
Date: March 16, 2017 12:11PM

Then you will have to check your firewall rules

---------------------------------------------------------------------------------------------
(Windows 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.1.2/7.0.16/5.6.28/5.5.38/5.4.45/5.3.29> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.6.5.2> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: Access to phpmyadmin
Posted by: danielB (---.mtm-info.pl)
Date: March 16, 2017 09:14PM

I don't know how to do this.

Options: ReplyQuote
Re: Access to phpmyadmin
Posted by: RiggsFolly (Moderator)
Date: March 17, 2017 01:05PM

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

---------------------------------------------------------------------------------------------
(Windows 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.1.2/7.0.16/5.6.28/5.5.38/5.4.45/5.3.29> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.6.5.2> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote


Sorry, only registered users may post in this forum.