Can't log in PHPMyadmin or SQLbudyy (only errors appear)
Posted by: wonderland (---.cust.tele2.lv)
Date: July 24, 2017 06:10PM

1 - Windows version used Windows 10 64bit
2 - Version WampServer 2.4, unfortunately I'm not sure whether its 32bit or 64bit
3 - Apache Version 2.4.4
4 - PHP Version 5.4.16
5 - MySQL Version 5.6.12
6 - What color is the WampServer icon - green

Hello,

I'm currently experiencing problems with my WAMP server installation. I've been using wamp for past 4 years, and have had no problems at all during this time. Recently I noticed that I can't log in PHPMyadmin or SQLbudyy at all.

Please do note, I haven't made any configuration changes during these past 4 years, this just happened one day.

When trying to log in to SQLBuddy I get this error - There was a problem logging you in.
When trying to log in to phpMyAdmin I get this error - #1045 Cannot log in to the MySQL server.

All the sites work with no problems.
I actually just wanted to clean up my wamps "www" directory, backup sites, uninstall wamp (2.4) and install the newer version.

I've been searching internet for quite some time, trying to find what could have caused this problem, mostly errors like this are due to misconfiguration in configuration files, but I haven't even touched those.



Edited 1 time(s). Last edit at 07/24/2017 06:16PM by wonderland.

Options: ReplyQuote
Re: Can't log in PHPMyadmin or SQLbudyy (only errors appear)
Posted by: RiggsFolly (Moderator)
Date: July 24, 2017 06:19PM

Hi

Have you checked you error log files?
Have you checked the Windows Event Viewer for messages from Apache or MYSQL?

---------------------------------------------------------------------------------------------
(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: Can't log in PHPMyadmin or SQLbudyy (only errors appear)
Posted by: wonderland (---.cust.tele2.lv)
Date: July 24, 2017 06:31PM

I hadn't checked those, but I did now.

Could this be because of - TIMESTAMP with implicit DEFAULT value is deprecated

===MYSQL===
Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
InnoDB: Not using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: Completed initialization of buffer pool
InnoDB: Highest supported file format is Barracuda.
InnoDB: 128 rollback segment(s) are active.
InnoDB: Waiting for purge to start
InnoDB: 5.6.12 started; log sequence number 3444877564
Server hostname (bind-address): '*'; port: 3306
IPv6 is available.
- '::' resolves to '::';
Server socket created on IP: '::'.
Event Scheduler: Loaded 0 events
wampmysqld: ready for connections.
Version: '5.6.12-log' socket: '' port: 3306 MySQL Community Server (GPL)
wampmysqld: Normal shutdown


===ACCESS===
"GET / HTTP/1.1" 200 5408
"GET /index.php?img=gifLogo HTTP/1.1" 200 4549
"GET /index.php?img=pngPlugin HTTP/1.1" 200 548
"GET /index.php?img=pngWrench HTTP/1.1" 200 741
"GET /index.php?img=pngFolder HTTP/1.1" 200 850
"GET /index.php?img=pngFolderGo HTTP/1.1" 200 694
"GET /index.php?img=favicon HTTP/1.1" 200 1429
"GET /phpmyadmin/ HTTP/1.1" 200 2615
"GET /phpmyadmin/phpmyadmin.css.php?server=1&token=6b94af1f0fbb20a80a077f8f291613d9&nocache=4243399829ltr HTTP/1.1" 200 88608
"POST /phpmyadmin/index.php HTTP/1.1" 302 25
"GET /phpmyadmin/index.php?token=6b94af1f0fbb20a80a077f8f291613d9 HTTP/1.1" 200 2621
"GET /phpmyadmin/js/messages.php?lang=en_GB&db=&server=0&token=6b94af1f0fbb20a80a077f8f291613d9 HTTP/1.1" 200 16647
"GET /phpmyadmin/ HTTP/1.1" 200 2615
"GET /phpmyadmin/phpmyadmin.css.php?server=1&token=f9b30f1a5e9e40874d31847d44b5de91&nocache=4243399829ltr HTTP/1.1" 200 88608
"GET /index.php?img=favicon HTTP/1.1" 200 1429
"GET /sqlbuddy/ HTTP/1.1" 302 -
"GET /sqlbuddy/login.php HTTP/1.1" 200 1249
"POST /sqlbuddy/login.php HTTP/1.1" 200 1286


===APACHE===
[pid 4092:tid 648] AH00455: Apache/2.4.4 (Win32) PHP/5.4.16 configured -- resuming normal operations
[pid 4092:tid 648] AH00456: Server built: Feb 23 2013 13:07:34
[core:notice] [pid 4092:tid 648] AH00094: Command line: 'e:\\wamp\\bin\\apache\\apache2.4.4\\bin\\httpd.exe -d E:/wamp/bin/apache/Apache2.4.4'
[pid 4092:tid 648] AH00418: Parent: Created child process 8932
[pid 8932:tid 712] AH00354: Child: Starting 150 worker threads.
[pid 4092:tid 648] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[pid 8932:tid 712] AH00364: Child: All worker threads have exited.
[pid 4092:tid 648] AH00430: Parent: Child process 8932 exited successfully.


===WINDOWS===
TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
The wampmysqld service terminated unexpectedly. It has done this 6 time(s).



Edited 1 time(s). Last edit at 07/24/2017 06:32PM by wonderland.

Options: ReplyQuote
Re: Can't log in PHPMyadmin or SQLbudyy (only errors appear)
Posted by: RiggsFolly (Moderator)
Date: July 24, 2017 06:42PM

Well that looks like it is the probelm. Did you look at the manual and fix it yet?

---------------------------------------------------------------------------------------------
(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: Can't log in PHPMyadmin or SQLbudyy (only errors appear)
Posted by: wonderland (---.cust.tele2.lv)
Date: July 24, 2017 07:11PM

I did a search on forums, but nothing came up except this forum topic. Which manual are you referring to?

I did a search on forums, but nothing came up except this forum topic. Which manual are you referring to?

Edit - I tried to add "explicit_defaults_for_timestamp=true", however that didn't help with my situation.
Edit 2 - I tried to access MySQL console, by entering "root" as password and console just exits.

Do you think that my problems are related to MySQL?



Edited 1 time(s). Last edit at 07/24/2017 08:00PM by wonderland.

Options: ReplyQuote
Re: Can't log in PHPMyadmin or SQLbudyy (only errors appear)
Posted by: wonderland (---.cust.tele2.lv)
Date: July 24, 2017 08:11PM

As suggested on stackoverflow, I tried to install MySQL workbench, but I got this error - [imgur.com]

It seems that I don't have access to MySQL? What could be at fault?

Options: ReplyQuote


Sorry, only registered users may post in this forum.