WampServer

Hi,

I am totally bafflred. Everything was working just on my PC. Now I all of a sudden the WAMP Server icon does not want to turn green anymore.

I checked on the Internet before coming here and I think MySQL is not working.

I left clicked the wampmanager icon to reveal the menu-> Apache -> Service The Start/Resume service menu is no color so I think Apache IS running.

Left clicked the wampmanager icon to reveal the menu-> MySQL -> Service The Start/Resume service menu is Green which means MySQL IS NOT running.

What could be the problem and remedy?

Thanks,

Naveen

Have you checked the Troubleshooting Tips at [forum.wampserver.com]

when I type in [localhost] I get the following message:

Welcome to phpMyAdmin

Error
MySQL said: Documentation

#1045 - Access denied for user 'root'@'localhost' (using password: NO)
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.

toivo,

I was so busy giving the update that I did not see you replied. Will check it now. thanks.

Hello

Look at the MySQL Error log.

wampmanager -> MySQL -> Error log

I would expect that you have somehow corrupted one of your databases

---------------------------------------------------------------------------------------------
(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-

Riggsfolly,

there is not error log. There is only MySQL Log. And that is an empty notepad file. Is t hat possible or am looking in a wrong place?

thanks,

Naveen

Then look at the Windows Event Viewer for messages from MYSQL

---------------------------------------------------------------------------------------------
(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-

it says event ID 100

Gents,

Thanks for the help so far. I have been the link mentioned above. Since I got a Event ID 100 does it still make sense to follow instructions as mentioned in



=====================================================
- 19a - If you have set a password on the root username via the Privileges option of phpMyAdmin or the MySQL Console, and you no longer have access to phpMyAdmin with the message: "MySQL replied:#1045 - Access denied for user 'root'@'localhost' (using password: NO)"
Completely replace the file "wamp\apps\phpmyadminx.y.z\config.inc.php" (x.y.z denote the version number of PhpMyAdmin) :
<?php
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* config.inc.php file for PhpMyAdmin *
* phpMyAdmin initially load the libraries/config.default.php file *
* then overwrites those values with those of the config.inc.php. *
* It is therefore not necessary to include all values in the file *
* config.inc.php. *
* Are set as that different from the defaults. *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * **/
//Extension to be used (By default mysqli - can be mysql)
$cfg['Servers'][1]['extension'] = 'mysqli';
/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
This will cause phpMyAdmin to throw a login page each time you run it. User Username=root and Password=blank if you have not set a password or use the new password if you have set one. This also allows you to create new MYSQL Username/Passwords and test they work from the phpMyAdmin login page.

Note 1: If you have not set a password, the line $cfg['Servers'][$i]['AllowNoPassword'] = false; must be commented out, using // at the beginning of the line.

Note 2: This line $cfg['Servers'][$i]['extension'] = 'mysqli'; tells phpMyAdmin to use the mysqli_* PHP database access extension. Ensure that the extension "php_mysqli" is loaded on the PHP extensions menu. For information, the mysql_* extension is deprecated for PHP >= 5.6.0 and is completely removed in PHP 7 or greate
=====================================================


Thanks,

Naveen

There is normally more useful meesage that just an error code. What was the message?

---------------------------------------------------------------------------------------------
(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-

First uninstall Wampserver, deactivate Antivirus & install Wampserver again, it works for me.

Have fun....