WampServer
Apache, PHP, MySQL
on Windows
TROUBLESHOOTING TIPS
Posted by:
RiggsFolly
(---.as43234.net)
Date: August 17, 2015 10:49PM
Checks to be made if you have a problem after installing Wampserver.
Most of these checks can be done before installing WampServer.
Note : Do not reply to this message. Create a New discussion to describe your problem in a clear and detailed manner (With Versions of your System, Apache, PHP, MySQL, EXACT error message, etc.)
Prerequisites :
--- The Wampmanager icon in the taskbar MUST be GREEN.
--- If the icon is not green, there is no point expecting everything to work as it means that one of both of the Apache/MySQL services has not started.
--- Read ALL this document, do not stop at the first problem you have.
--- In order to be sure you are working on the right file, it is imperative to be able to "see" hidden files and all extensions. To do this, launch Explorer -> Tools -> Folder Options -> View and check:
- Show files, folders and hidden drives is checked
- Hide extensions of known file types is unchecked
- 01
- If you are trying to upgrade your existing version of WAMPServer to a newer version or the latest versions
- - Did you follow this post Installing a new release of Wampserver, If not, it may not be too late to do so!
- 02
- You must install WAMPServer as an Administrator (This is an Absolutely must)
- - Right-click the install *.exe file and select "Run as Administrator" from the menu.
- It is highly recommended to install Wampserver at the root of a partition (C:\Wamp, D:\Wamp, etc) and do not use an installation folder name with spaces or diacritical characters. So do not install in "Program Files".
- 03
- Do you have Skype installed or running?
- - If so, it is imperative to change the Skype configuration to NOT use port 80 or 443.
- - Do this by starting SKYPE and using the menus do - Tools -> Options -> Advanced Settings -> Connection:
- - Uncheck "Use ports 80 and 443 as an alternative."
- The Windows 8/8.1/10 tiled app versions of SKYPE may not allow you to change this, so uninstall the tiled app and install SKYPE from a download, it will work just the same, but it will also allow you to make the above configuration changes.
- 04 - If the Wampserver icon is not green, it means that at least one service is not started.
Note: Since Wampserver 3.0.7, there are three services (apache, mysql and mariadb) and no longer just two (apache and mysql)
They are called: wampapache, wampmysqld and wampmariadb for the 32-bit versions and wampapache64, wampmysqld64 and wampmariadb64 for the 64-bit versions.
What service(s) is(are) not Started?
- To check from the Services Manager: click Start, Run, and type services.msc or Administration Tools->Services and check the status of wampapache, wampmysqld and wampmariadb services (or wampapache64, wampmysqld64 and wampmariadb64with Wampserver 2.5 64 bit)
Even if the Wampmanager icon is not green, there is an integrated tool to check the status of services:
Right-click icon Wampmanager -> Tools -> Check status of services
- 05 - Always check, with the Services Manager that there is no Apache or MySQL services OTHER THAN wampapache(64) and wampmysqld(64) (See Note 1)
- 06 - Do you have other "php.ini" files on your system not contained in the wamp tree? If so, delete them.
- To check it in command line: Start, Run, cmd.exe
-- Go to the root of the disc CD / then Enter
- 07 - Are there other "my.ini" files on your system not contained in the wamp tree? If so, delete them.
--- The search procedure is similar to php.ini
- 08 - Do you have IIS installed?
Control Panel, Programs and Features, Turn Windows features on or off
(W7/W8/W10) Uncheck :
-- Main Web Internet service instance (IIS)
-- All items of the branch : Internet services(IIS)
-- All items of the branch : Activation Windows service process
(W10/W11) Uncheck :
-- Main instance Web of Internet Information Services (IIS)
-- All items of the branch : Internet Information Services
- 09 -In the file "Windows\System32\drivers\etc\hosts" you MUST have the following lines active that is to say not starting with # comment symbol. Some malware tools place a large number of bad sites in the HOSTS file to stop you ever accessing them. It is OK to leave those in the hosts file, but ensure the entries below are also there.
You are a Systems Administrator now, so it would be a good idea to know something about the use of the host file
ONLY if your system and your network supports IPv6 you can add a second line:
Note: 09-1 : By default, the hosts file is provided with the system attributes: hidden, read-only. It is therefore imperative to remove these attributes before you want to edit. Also some AV/Firewall apps also add protection to the hosts file. You may have to check if you are using one of these, so you can allow access to this file while you are making amendments. (See 10)
Note: 09-2 : Support of Ipv6
To see if your system supports IPv6, open a command window and run in this window the ping
Test for IPv4
Test for IPv6
If your system or connections (WiFi, Internet, etc.) do not support IPv6 or if you are unsure, disable the Internet Protocol Version 6 (TCP / IPv6) in properties of all your network connections.
- 10 - Make sure your antivirus or protection system does not block access to:
-- file Windows\System32\drivers\etc\hosts
-- wamp\Wampmanager.exe
-- wamp\bin\apache\apache2.2.x\bin\httpd.exe
-- wamp\bin\mysql\mysql5.x.y\bin\mysql.exe
-- wamp\bin\mysql\mysql5.x.y\bin\mysqlcheck.exe
-- wamp\bin\mysql\mysql5.x.y\bin\mysqld.exe
-- wamp\bin\php\php5.3.x\php.exe
-- 10a - Exclude a file or folder from the Windows Defender virus/threat scan
-- Start menu, Windows Security
-- Protection against viruses and threats
-- Manage parameters
-- Exclusions, Add or remove exclusions
-- Add an exclusion
-- You can add the hosts file and the Wampserver installation folder.
- 11 - Any other installation of a server (EasyPHP, XAMPP, IIS, or other) is incompatible with Wampserver and must be uninstalled completely before installing WAMPServer.
- 12 - Are there any ERRORS in MySQL or Apache log file? (Log files are in the /wamp/logs/ folder)
- 13 - Are there any errors in the Windows Event Viewer?
(Using the Event Viewer: [www.sevenforums.com])
- 14 - Make sure your firewall and your antivirus protection permits (and do not prohibit) the access to ports 80 and 3306
- 15 - If you have previously uninstalled Wampserver, verify that both services wampapache(64) and wampmysqld(64) had been deleted before installing a new version? (See note 1)
- 16 - Install Wampserver 64bit ONLY if you have a Windows 64bit Operating System, in this case, always take the latest version of WampServer.
-- With 64-bit Apache, PHP and MySQL and all extensions and modules must always be compiled 64bit Thread Safe.
- 17 - No more used
- 18 - No more used
- 19 - PhpMyAdmin. After installing Wampserver or a new version of MySQL or MariaDB, the connection to PhpMyAdmin is made with the "root" user and without a password, i.e. with the empty Password box.
- 19-a - Adminer. Adminer does not accept connections without a password. After installing Wampserver or a new version of MySQL or MariaDB, the only user is "root" without a password. To connect to Adminer, you must first set a password for the root user. This can be done:
- or by connecting to PhpMyAdmin and the User Accounts tab, root, Edit privileges, Change password.
- either by connecting to the MySQL or MariaDB console depending on the database manager used by default and the commands :
- 19-b - Add a MySQL (or MariaDB ) user via the console:
- 20 - Systematic error "Tray Menu Aestan has encountered a problem and needs to close" when launching Wampserver
Or sometimes white pages (no loaded page) to localhost and/or PhpMyAdmin
Recent versions (thus also recent versions of Apache, PHP or MySQL) are compiled VC9 (Microsoft Visual C++ 2008), VC10 (Microsoft Visual C++ 2010), VC11 (Microsoft Visual C++ 2012), VC14, VC15 and VC16 (Microsoft Visual C++ 2015-2019) for PHP 7
We must therefore ensure that you have installed the latest versions of all "package" Microsoft Visual C++
Make sure you are "up to date" in the redistributable packages VC9, VC10, VC11, VC13, VC14, VC15 and VC16
Even if you think you are up to date, install each package as administrator and if message "Already installed", validate Repair.
The following packages (VC9, VC10, VC11) are imperatively required to Wampserver 2.4 and 2.5 and 3.0.0, even if you use only Apache and PHP versions VC11 and VC13, VC14, VC15 and VC16 are required for Apache 2.4.17+ and PHP 7
WARNING : Sometimes Microsoft disables surreptitiously certain pages on VC ++ redistributable packages, without redirecting and without specifying the new page. You can find all the necessary files onhttps://wampserver.aviatechno.net/ in section Visual C++ Redistribuable Packages.
It may be that if you were not "up to date" with the redistributable packages VC9, VC10 and VC11 before installing WampServer, it has not been properly installed and that even this update does not resolve your problem. We must therefore uninstall Wampserver and verify that both services wampmysqld and wampapache (wampmysqld64 and wampmyapache64 for Wampserver 64 bit) no longer exist - if necessary remove them, see Note 1.
Restart the machine and install Wampserver.
- 20-b - Verify that all VC ++ packages are installed and with the latest versions.
To do this, use the tool:
Checks VC++ packages installed
And you will find all the packages on [wampserver.aviatechno.net] in section Visual C++ Redistribuable Packages
Do not forget that if you have a 64 bit Windows, you must install both 32 and 64 bit versions of each package.
You must install each package "as an administrator", so right-click the exe file and then run as Administrator.
- 21 - MYSQL worked yesterday, but today I get an Orange wampmanager icon and MYSQL does not start.
- This applies particularly if you are using INNODB databases rather than MYISAM.
- Check the MySQL log, in "/wamp/logs/" If you see messages in the log saying that MySQL has tried to recover a database or a database table and failed, for whatever reason, then it is likely you have a corrupted database and MYSQL cannot start because it failed to recover the database.
- The simplest solution is to just Restore your last backup. Assuming you have a backup, which of course you do, because you are not stupid!
- If you have made the mistake of not having a backup, you should check the messages in the MYSQL Log as they suggest possible recovery mechanisms, alternatively, read the InnoDB Backup and Recovery
- To reduce the likelyhood of this happening, please make sure that you close down WAMPServer by either using the "Exit" on the wampmanager Menu
- - right click wampmanager -> Exit
- Or stop the MYSQL Service using
- - left click wampmanager -> Stop All services
BEFORE you REBOOT or CLOSE WINDOWS
21-a Why do I need to close Wampserver BEFORE shutting down Windows?
The "normal" closure of Wampserver performs the following actions:
- Stop the Apache service
- Stop the MySQL service
- Stop the mariaDB service
What happens when services are stopped "normally"?
- For Apache:
- Closing the Apache server
- Close all Apache processes
- Close the "child" server of Apache
- For MySQL or MariaDB
-- Purging the queue.
-- Dumping buffer pool(s)
-- Removed temporary tablespace data file
-- Close MySQL server
When Windows is shut down without having previously closed Wampserver, in certain cases, the services are not stopped normally, but the tasks httpd.exe and mysqld.exe are "killed" (TASKKILL).
So, queues and buffers are not run or dumped and this can corrupt databases, which can give symptoms like:
"It worked well yesterday, but it does not work today! "
22 - New version Aestan Tray Menu (wampmanager.exe)
The following explanations take into account versions 3.2.2.1 and 3.2.2.2 of Aestan Tray Menu (wampmanager.exe) and assume that the installation folder of Wampserver 64 bit is E:\wamp64; this will be interpreted and modified according to your own versions and installation path.
When launching Wampserver, you can get an information window similar to :
New Update Available - Current Version 3.2.2.1 - New Version 3.2.2.2
This means that a new version of Aestan Tray Menu (wampmanager.exe) is available.
After confirming OK from this window and after the Wampmanager icon has turned green, double-click the icon to display the "About..." window
Then validate the Update tab, then the Verify button
You are using version 3.2.2.1 - Version 3.2.2.2 is available to download at the author's website - Do you want to update your application now?
Validate Yes
Would you like to read the information file ?
Validate Yes To obtain all the update and implementation information
What is important in the information displayed is the explanations for how to update wampmanager.exe
Be advised that the downloaded file is the one of AestanTrayMenu.
It is archived in Zip format so unarchive it to get the EXE.
You must rename it as the executable of your application.
Back up your old version before upgrading.
This is a security issue when bugs occur.
Validate OK
Dialog for choosing the download folder, by default it is proposed the installation folder of your version of Wampserver.
OK to download
Update will be downloaded to E:\wamp\AeTrayMenu_3222_64bits.zip
OK
Update has been downloaded
OK
Exit to quit "About..."
Exit Wampserver
With the file explorer, go to your Wampserver installation folder
Rename wampmanager.exe to wampmanager3221.exe or whatever you want, in this case, 3221 is the current version number.
Unzip AeTrayMenu_3222_64bits.zip in the wampserver installation folder and not in a new folder, you will get the file :
E:\wamp64\AeTrayMenu.exe
that you rename to E:\wamp\wampmanager.exe
You may delete the file AeTrayMenu_3222_64bits.zip
And now you can start Wampserver.
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
(Note 1) To remove a service:
Start, Run, Type "SC DELETE <service name>"
Or open a command window As an administrator and type the command above in this window. It is imperative that the commands of deletion of services are performed as Administrator , otherwise the deletions will not occur.
---------------------------------------------------------------
(Note 2) To Edit the hosts file and rights, not only must be in as an administrator, but in addition, you must verify that such administrator is owner of C:\Windows\System32\drivers\etc\hosts.
I know it sounds silly, but the administrator is not necessarily the owner of the file.
(In principle, this file owner is "System"
1) To change the permissions of a folder or file, you must:
- Be awarded the "total control" over this folder or file
- Or be the owner (or be a member of the group that owns it), allowing THEN to assign full control of this folder or file.
2) To be the owner of a folder or file, you must:
- Or by the creator
- Or belong to the Administrators group, allowing the change of the owner, therefore, to declare as the owner.
So Explorer, right-click on "C:\Windows\System32\drivers\etc\hosts", Security then Properties, Advanced, Owner.
If you are not the current owner: Edit and select the desired owner then Apply and OK twice. Once the ownership change applied, it must leave (Imperative) the properties window for this to be updated.
Back to file properties "C:\Windows\System32\drivers\etc\hosts" Security tab, select the new owner and verify that Full Control applies, otherwise Modify to choose the new owner and validate Full Control.
It is only from there that you can change permissions on the file and remove the read-only.
In addition, under 64-bit Windows, if you use a text editor or 32 bit software to open the hosts file, it may be that you are faced with a file open dialog, that will in windows/system32/drivers/ not show you sub folder etc, and therefore no hosts files. This is due to the fact that with a 32-bit software on Windows 64 bit, when you choose the folder system32 you are redirected transparently on the SysWOW64 folder while viewing the system32 folder. To choose the "right" system32 folder, you need to type (or select if visible) Sysnative instead of sytem32.
---------------------------------------------------------------
(Note 3) - Text editor ======
*Important Prerequisites About the text editor being used: To edit the files, you must use a text editor, but not just any one. Some text editors, such as Notepad (notepad.exe) in Windows, are not able to correctly view files with Unix line breaks*, others recode surreptitiously the line of type Unix in type Windows/DOS, others still change the used character sets or add headers ; However, it is imperative that the end-of-line types or the character sets of the Wampserver files are not altered, otherwise it will generate impossibilities and errors when it is used. That's why I strongly recommend to use a free, powerful text editor like Notepad++ that you can find at Notepad++ (If you use a text editor like UtraEdit, it will not be a problem).
* The characters indicating the end of lines are of three types:
- Windows/DOS : CR - LF (Carriage Return - Line Feed) Two bytes 0x0D and 0x0A
- Unix : LF (Line Feed) One byte 0x0A
- Mac : CR (Carriage Return) One byte : 0x0D
---------------------------------------------------------------
(Note 4) - Command windows ======
Note: Under Windows 10 - Command window - To do it in a simple and durable way.
Control Panel, Programs and Features, Enable or Disable Windows Features
(The following option can be found in the Device Lock submenu)
Check : Built-in shell launcher
-- OK
Close Control Panel
Now in the Start menu, you should see a Command Prompt item
Right-click Command Prompt and choose Run as Administrator
In command window should launch, with in the title bar :
[Administrator: Command prompt]
For all commands that must be launched via a Command Window, it is imperative to have Administrator in the title bar.
-- 4.1 Command window via desktop shortcut
Right-click on the desktop then New -> Shortcut
Enter the location of the element -> put "cmd.exe" (Without quotes)
Next Button
Enter a name for this shortcut -> put "Command window" (Without quotes)
Finish button
Right-click on this new shortcut -> Properties
Shortcut tab, Advanced button
Check Run as administrator
OK, Apply, OK
Now all command windows opened by this shortcut will be opened "as administrator".
---------------------------------------------------------------------------------------------
(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-
Edited 36 time(s). Last edit at 11/04/2023 04:39PM by Otomatic.
Most of these checks can be done before installing WampServer.
Note : Do not reply to this message. Create a New discussion to describe your problem in a clear and detailed manner (With Versions of your System, Apache, PHP, MySQL, EXACT error message, etc.)
Prerequisites :
--- The Wampmanager icon in the taskbar MUST be GREEN.
--- If the icon is not green, there is no point expecting everything to work as it means that one of both of the Apache/MySQL services has not started.
--- Read ALL this document, do not stop at the first problem you have.
--- In order to be sure you are working on the right file, it is imperative to be able to "see" hidden files and all extensions. To do this, launch Explorer -> Tools -> Folder Options -> View and check:
- Show files, folders and hidden drives is checked
- Hide extensions of known file types is unchecked
- 01
- If you are trying to upgrade your existing version of WAMPServer to a newer version or the latest versions
- - Did you follow this post Installing a new release of Wampserver, If not, it may not be too late to do so!
- 02
- You must install WAMPServer as an Administrator (This is an Absolutely must)
- - Right-click the install *.exe file and select "Run as Administrator" from the menu.
- It is highly recommended to install Wampserver at the root of a partition (C:\Wamp, D:\Wamp, etc) and do not use an installation folder name with spaces or diacritical characters. So do not install in "Program Files".
- 03
- Do you have Skype installed or running?
- - If so, it is imperative to change the Skype configuration to NOT use port 80 or 443.
- - Do this by starting SKYPE and using the menus do - Tools -> Options -> Advanced Settings -> Connection:
- - Uncheck "Use ports 80 and 443 as an alternative."
- The Windows 8/8.1/10 tiled app versions of SKYPE may not allow you to change this, so uninstall the tiled app and install SKYPE from a download, it will work just the same, but it will also allow you to make the above configuration changes.
- 04 - If the Wampserver icon is not green, it means that at least one service is not started.
Note: Since Wampserver 3.0.7, there are three services (apache, mysql and mariadb) and no longer just two (apache and mysql)
They are called: wampapache, wampmysqld and wampmariadb for the 32-bit versions and wampapache64, wampmysqld64 and wampmariadb64 for the 64-bit versions.
What service(s) is(are) not Started?
- To check from the Services Manager: click Start, Run, and type services.msc or Administration Tools->Services and check the status of wampapache, wampmysqld and wampmariadb services (or wampapache64, wampmysqld64 and wampmariadb64with Wampserver 2.5 64 bit)
Even if the Wampmanager icon is not green, there is an integrated tool to check the status of services:
Right-click icon Wampmanager -> Tools -> Check status of services
- 05 - Always check, with the Services Manager that there is no Apache or MySQL services OTHER THAN wampapache(64) and wampmysqld(64) (See Note 1)
- 06 - Do you have other "php.ini" files on your system not contained in the wamp tree? If so, delete them.
- To check it in command line: Start, Run, cmd.exe
-- Go to the root of the disc CD / then Enter
dir /s php.ini--- See Note 4 for how to use a Command Windows
- 07 - Are there other "my.ini" files on your system not contained in the wamp tree? If so, delete them.
--- The search procedure is similar to php.ini
- 08 - Do you have IIS installed?
Control Panel, Programs and Features, Turn Windows features on or off
(W7/W8/W10) Uncheck :
-- Main Web Internet service instance (IIS)
-- All items of the branch : Internet services(IIS)
-- All items of the branch : Activation Windows service process
(W10/W11) Uncheck :
-- Main instance Web of Internet Information Services (IIS)
-- All items of the branch : Internet Information Services
- 09 -In the file "Windows\System32\drivers\etc\hosts" you MUST have the following lines active that is to say not starting with # comment symbol. Some malware tools place a large number of bad sites in the HOSTS file to stop you ever accessing them. It is OK to leave those in the hosts file, but ensure the entries below are also there.
You are a Systems Administrator now, so it would be a good idea to know something about the use of the host file
127.0.0.1 localhostand exist only once.
ONLY if your system and your network supports IPv6 you can add a second line:
127.0.0.1 localhost ::1 localhost
Note: 09-1 : By default, the hosts file is provided with the system attributes: hidden, read-only. It is therefore imperative to remove these attributes before you want to edit. Also some AV/Firewall apps also add protection to the hosts file. You may have to check if you are using one of these, so you can allow access to this file while you are making amendments. (See 10)
Note: 09-2 : Support of Ipv6
To see if your system supports IPv6, open a command window and run in this window the ping
Test for IPv4
C:\Windows\System32>ping 127.0.0.1
Pinging 127.0.0.1 with 32 bytes of data:
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Ping statistics for 127.0.0.1:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
We can see that the four test 127.0.0.1 have been received, without any loss.Test for IPv6
C:\Windows\System32>ping ::1
Pinging ::1 with 32 bytes of data:
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Ping statistics for ::1:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
We can see that the four tests have all been received, without any loss, so the system supports IPv6If your system or connections (WiFi, Internet, etc.) do not support IPv6 or if you are unsure, disable the Internet Protocol Version 6 (TCP / IPv6) in properties of all your network connections.
- 10 - Make sure your antivirus or protection system does not block access to:
-- file Windows\System32\drivers\etc\hosts
-- wamp\Wampmanager.exe
-- wamp\bin\apache\apache2.2.x\bin\httpd.exe
-- wamp\bin\mysql\mysql5.x.y\bin\mysql.exe
-- wamp\bin\mysql\mysql5.x.y\bin\mysqlcheck.exe
-- wamp\bin\mysql\mysql5.x.y\bin\mysqld.exe
-- wamp\bin\php\php5.3.x\php.exe
-- 10a - Exclude a file or folder from the Windows Defender virus/threat scan
-- Start menu, Windows Security
-- Protection against viruses and threats
-- Manage parameters
-- Exclusions, Add or remove exclusions
-- Add an exclusion
-- You can add the hosts file and the Wampserver installation folder.
- 11 - Any other installation of a server (EasyPHP, XAMPP, IIS, or other) is incompatible with Wampserver and must be uninstalled completely before installing WAMPServer.
- 12 - Are there any ERRORS in MySQL or Apache log file? (Log files are in the /wamp/logs/ folder)
- 13 - Are there any errors in the Windows Event Viewer?
(Using the Event Viewer: [www.sevenforums.com])
- 14 - Make sure your firewall and your antivirus protection permits (and do not prohibit) the access to ports 80 and 3306
- 15 - If you have previously uninstalled Wampserver, verify that both services wampapache(64) and wampmysqld(64) had been deleted before installing a new version? (See note 1)
- 16 - Install Wampserver 64bit ONLY if you have a Windows 64bit Operating System, in this case, always take the latest version of WampServer.
-- With 64-bit Apache, PHP and MySQL and all extensions and modules must always be compiled 64bit Thread Safe.
- 17 - No more used
- 18 - No more used
- 19 - PhpMyAdmin. After installing Wampserver or a new version of MySQL or MariaDB, the connection to PhpMyAdmin is made with the "root" user and without a password, i.e. with the empty Password box.
- 19-a - Adminer. Adminer does not accept connections without a password. After installing Wampserver or a new version of MySQL or MariaDB, the only user is "root" without a password. To connect to Adminer, you must first set a password for the root user. This can be done:
- or by connecting to PhpMyAdmin and the User Accounts tab, root, Edit privileges, Change password.
- either by connecting to the MySQL or MariaDB console depending on the database manager used by default and the commands :
# Before MySQL 8 # Privileges for `root`@`127.0.0.1` GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY 'password' WITH GRANT OPTION; # Privileges for `root`@`::1` GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1' IDENTIFIED BY 'password' WITH GRANT OPTION; # Privileges for `root`@`localhost` GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION;
# MySQL 8 - Privileges for `root` ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password' PASSWORD EXPIRE NEVER; ALTER USER 'root'@'localhost' DEFAULT ROLE ALL; GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION; GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION; CREATE USER IF NOT EXISTS 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'password' PASSWORD EXPIRE NEVER; ALTER USER IF EXISTS 'root'@'127.0.0.1' DEFAULT ROLE ALL; GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' WITH GRANT OPTION; CREATE USER IF NOT EXISTS 'root'@'::1' IDENTIFIED WITH mysql_native_password BY 'password' PASSWORD EXPIRE NEVER; ALTER USER IF EXISTS 'root'@'::1' DEFAULT ROLE ALL; GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1' WITH GRANT OPTION;
- 19-b - Add a MySQL (or MariaDB ) user via the console:
# Before MySQL 8 # Usage privileges for `username`@`127.0.0.1` GRANT USAGE ON *.* TO 'username'@'127.0.0.1' IDENTIFIED BY 'plaintext password'; # Usage privileges for `username`@`localhost` GRANT USAGE ON *.* TO 'username'@'localhost' IDENTIFIED BY 'plaintext password'; # Usage privileges for `username`@`::1` GRANT USAGE ON *.* TO 'username'@'::1' IDENTIFIED BY 'plaintext password'; # Eventual privileges on a database GRANT SELECT, INSERT, UPDATE, DELETE ON `mabase`.* TO 'username'@'127.0.0.1'; GRANT SELECT, INSERT, UPDATE, DELETE ON `mabase`.* TO 'username'@'localhost'; GRANT SELECT, INSERT, UPDATE, DELETE ON `mabase`.* TO 'username'@'::1';
# MySQL 8 # Usage privileges for `username` CREATE USER 'username'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY 'plaintext password' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK; GRANT USAGE ON *.* TO 'username'@'localhost'; CREATE USER 'username'@'127.0.0.1' IDENTIFIED WITH 'mysql_native_password' BY 'plaintext password' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK; GRANT USAGE ON *.* TO 'username'@'127.0.0.1'; CREATE USER 'username'@'::1' IDENTIFIED WITH 'mysql_native_password' BY 'plaintext password' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK; GRANT USAGE ON *.* TO 'username'@'::1'; # Eventual privileges on a database GRANT SELECT, INSERT, UPDATE, DELETE ON `mabase`.* TO 'username'@'127.0.0.1'; GRANT SELECT, INSERT, UPDATE, DELETE ON `mabase`.* TO 'username'@'localhost'; GRANT SELECT, INSERT, UPDATE, DELETE ON `mabase`.* TO 'username'@'::1';
- 20 - Systematic error "Tray Menu Aestan has encountered a problem and needs to close" when launching Wampserver
Or sometimes white pages (no loaded page) to localhost and/or PhpMyAdmin
Recent versions (thus also recent versions of Apache, PHP or MySQL) are compiled VC9 (Microsoft Visual C++ 2008), VC10 (Microsoft Visual C++ 2010), VC11 (Microsoft Visual C++ 2012), VC14, VC15 and VC16 (Microsoft Visual C++ 2015-2019) for PHP 7
We must therefore ensure that you have installed the latest versions of all "package" Microsoft Visual C++
Make sure you are "up to date" in the redistributable packages VC9, VC10, VC11, VC13, VC14, VC15 and VC16
Even if you think you are up to date, install each package as administrator and if message "Already installed", validate Repair.
The following packages (VC9, VC10, VC11) are imperatively required to Wampserver 2.4 and 2.5 and 3.0.0, even if you use only Apache and PHP versions VC11 and VC13, VC14, VC15 and VC16 are required for Apache 2.4.17+ and PHP 7
- VC9 Packages
For Windows 2000 Service Pack 4; Windows Server 2003; Windows Server 2008; Windows Vista; Windows XP, W7, W8
Microsoft Visual C++ 2008 SP1 Redistributable Package (x86) (32 bits)
Microsoft Visual C++ 2008 SP1 Redistributable Package (x64) (64bits)
- VC10 Packages
For Windows 7; Windows Server 2003; Windows Server 2008; Windows Server 2008 R2; Windows Vista; Windows XP
Microsoft Visual C++ 2010 SP1 Redistributable Package (x86)
Microsoft Visual C++ 2010 SP1 Redistributable Package (x64)
- VC11 Packages Nota: VC11 is not supported by Windows XP
Windows 7 Service Pack 1; Windows 8; Windows Server 2008 R2 SP1; Windows Server 2012; Windows Vista Service Pack 2
The two files VSU4\vcredist_x86.exe and VSU4\vcredist_x64.exe to be download are on the same page:
Visual C++ Redistributable for Visual Studio 2012 Update 4 (x86 and x64)
- VC13 Packages (Required for Apache 2.4.17 and PHP 7)
Windows 7 Service Pack 1; Windows 8; Windows Server 2008 R2 SP1; Windows Server 2012; Windows Vista Service Pack 2
The two files VSU4\vcredist_x86.exe and VSU4\vcredist_x64.exe to be download are on the same page:
Visual C++ Redistributable Packages for Visual Studio 2013
- VC14 and VC15 Packages are replaced by VC16 (VC 2015-2019) packages
- VC16 Paquetages - VC 2015-2019 14.23.27820
Visual C++ Redistributable Packages for Visual Studio 2015-2019 x86
Visual C++ Redistributable Packages for Visual Studio 2015-2019 x64
VC2015-2019 (VC16) is backward compatible to VC2015 (VC14) and VC2017 (VC15). That means, a VC14 or VC15 module can be used inside a VC16 binary. Because this compatibility the version number of the Redistributable is 14.2x.xx and after you install the Redistributable VC2015-2019, the Redistributable packages VC2015 (VC14) and VC2017 (VC15) are eventually deleted but you can still use VC14 and VC15.
- Update for Universal C Runtime in Windows
This is necessary if you have errors of the style: api-ms-win-crt-runtimel1-1-0. dll is missing.
Windows 10, Windows 7 Service Pack 1, Windows 8, Windows 8.1, Windows Server 2008 R2 SP1, Windows Server 2008 Service Pack 2, Windows Server 2012, Windows Vista Service Pack 2
Follow the links on this page for your specific environment
Update for Universal C Runtime in Windows
WARNING : Sometimes Microsoft disables surreptitiously certain pages on VC ++ redistributable packages, without redirecting and without specifying the new page. You can find all the necessary files onhttps://wampserver.aviatechno.net/ in section Visual C++ Redistribuable Packages.
It may be that if you were not "up to date" with the redistributable packages VC9, VC10 and VC11 before installing WampServer, it has not been properly installed and that even this update does not resolve your problem. We must therefore uninstall Wampserver and verify that both services wampmysqld and wampapache (wampmysqld64 and wampmyapache64 for Wampserver 64 bit) no longer exist - if necessary remove them, see Note 1.
Restart the machine and install Wampserver.
- 20-b - Verify that all VC ++ packages are installed and with the latest versions.
To do this, use the tool:
Checks VC++ packages installed
And you will find all the packages on [wampserver.aviatechno.net] in section Visual C++ Redistribuable Packages
Do not forget that if you have a 64 bit Windows, you must install both 32 and 64 bit versions of each package.
You must install each package "as an administrator", so right-click the exe file and then run as Administrator.
- 21 - MYSQL worked yesterday, but today I get an Orange wampmanager icon and MYSQL does not start.
- This applies particularly if you are using INNODB databases rather than MYISAM.
- Check the MySQL log, in "/wamp/logs/" If you see messages in the log saying that MySQL has tried to recover a database or a database table and failed, for whatever reason, then it is likely you have a corrupted database and MYSQL cannot start because it failed to recover the database.
- The simplest solution is to just Restore your last backup. Assuming you have a backup, which of course you do, because you are not stupid!
- If you have made the mistake of not having a backup, you should check the messages in the MYSQL Log as they suggest possible recovery mechanisms, alternatively, read the InnoDB Backup and Recovery
- To reduce the likelyhood of this happening, please make sure that you close down WAMPServer by either using the "Exit" on the wampmanager Menu
- - right click wampmanager -> Exit
- Or stop the MYSQL Service using
- - left click wampmanager -> Stop All services
BEFORE you REBOOT or CLOSE WINDOWS
21-a Why do I need to close Wampserver BEFORE shutting down Windows?
The "normal" closure of Wampserver performs the following actions:
- Stop the Apache service
- Stop the MySQL service
- Stop the mariaDB service
What happens when services are stopped "normally"?
- For Apache:
- Closing the Apache server
- Close all Apache processes
- Close the "child" server of Apache
- For MySQL or MariaDB
-- Purging the queue.
-- Dumping buffer pool(s)
-- Removed temporary tablespace data file
-- Close MySQL server
When Windows is shut down without having previously closed Wampserver, in certain cases, the services are not stopped normally, but the tasks httpd.exe and mysqld.exe are "killed" (TASKKILL).
So, queues and buffers are not run or dumped and this can corrupt databases, which can give symptoms like:
"It worked well yesterday, but it does not work today! "
22 - New version Aestan Tray Menu (wampmanager.exe)
The following explanations take into account versions 3.2.2.1 and 3.2.2.2 of Aestan Tray Menu (wampmanager.exe) and assume that the installation folder of Wampserver 64 bit is E:\wamp64; this will be interpreted and modified according to your own versions and installation path.
When launching Wampserver, you can get an information window similar to :
New Update Available - Current Version 3.2.2.1 - New Version 3.2.2.2
This means that a new version of Aestan Tray Menu (wampmanager.exe) is available.
After confirming OK from this window and after the Wampmanager icon has turned green, double-click the icon to display the "About..." window
Then validate the Update tab, then the Verify button
You are using version 3.2.2.1 - Version 3.2.2.2 is available to download at the author's website - Do you want to update your application now?
Validate Yes
Would you like to read the information file ?
Validate Yes To obtain all the update and implementation information
What is important in the information displayed is the explanations for how to update wampmanager.exe
Be advised that the downloaded file is the one of AestanTrayMenu.
It is archived in Zip format so unarchive it to get the EXE.
You must rename it as the executable of your application.
Back up your old version before upgrading.
This is a security issue when bugs occur.
Validate OK
Dialog for choosing the download folder, by default it is proposed the installation folder of your version of Wampserver.
OK to download
Update will be downloaded to E:\wamp\AeTrayMenu_3222_64bits.zip
OK
Update has been downloaded
OK
Exit to quit "About..."
Exit Wampserver
With the file explorer, go to your Wampserver installation folder
Rename wampmanager.exe to wampmanager3221.exe or whatever you want, in this case, 3221 is the current version number.
Unzip AeTrayMenu_3222_64bits.zip in the wampserver installation folder and not in a new folder, you will get the file :
E:\wamp64\AeTrayMenu.exe
that you rename to E:\wamp\wampmanager.exe
You may delete the file AeTrayMenu_3222_64bits.zip
And now you can start Wampserver.
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
(Note 1) To remove a service:
Start, Run, Type "SC DELETE <service name>"
Or open a command window As an administrator and type the command above in this window. It is imperative that the commands of deletion of services are performed as Administrator , otherwise the deletions will not occur.
---------------------------------------------------------------
(Note 2) To Edit the hosts file and rights, not only must be in as an administrator, but in addition, you must verify that such administrator is owner of C:\Windows\System32\drivers\etc\hosts.
I know it sounds silly, but the administrator is not necessarily the owner of the file.
(In principle, this file owner is "System"
1) To change the permissions of a folder or file, you must:
- Be awarded the "total control" over this folder or file
- Or be the owner (or be a member of the group that owns it), allowing THEN to assign full control of this folder or file.
2) To be the owner of a folder or file, you must:
- Or by the creator
- Or belong to the Administrators group, allowing the change of the owner, therefore, to declare as the owner.
So Explorer, right-click on "C:\Windows\System32\drivers\etc\hosts", Security then Properties, Advanced, Owner.
If you are not the current owner: Edit and select the desired owner then Apply and OK twice. Once the ownership change applied, it must leave (Imperative) the properties window for this to be updated.
Back to file properties "C:\Windows\System32\drivers\etc\hosts" Security tab, select the new owner and verify that Full Control applies, otherwise Modify to choose the new owner and validate Full Control.
It is only from there that you can change permissions on the file and remove the read-only.
In addition, under 64-bit Windows, if you use a text editor or 32 bit software to open the hosts file, it may be that you are faced with a file open dialog, that will in windows/system32/drivers/ not show you sub folder etc, and therefore no hosts files. This is due to the fact that with a 32-bit software on Windows 64 bit, when you choose the folder system32 you are redirected transparently on the SysWOW64 folder while viewing the system32 folder. To choose the "right" system32 folder, you need to type (or select if visible) Sysnative instead of sytem32.
---------------------------------------------------------------
(Note 3) - Text editor ======
*Important Prerequisites About the text editor being used: To edit the files, you must use a text editor, but not just any one. Some text editors, such as Notepad (notepad.exe) in Windows, are not able to correctly view files with Unix line breaks*, others recode surreptitiously the line of type Unix in type Windows/DOS, others still change the used character sets or add headers ; However, it is imperative that the end-of-line types or the character sets of the Wampserver files are not altered, otherwise it will generate impossibilities and errors when it is used. That's why I strongly recommend to use a free, powerful text editor like Notepad++ that you can find at Notepad++ (If you use a text editor like UtraEdit, it will not be a problem).
* The characters indicating the end of lines are of three types:
- Windows/DOS : CR - LF (Carriage Return - Line Feed) Two bytes 0x0D and 0x0A
- Unix : LF (Line Feed) One byte 0x0A
- Mac : CR (Carriage Return) One byte : 0x0D
---------------------------------------------------------------
(Note 4) - Command windows ======
Note: Under Windows 10 - Command window - To do it in a simple and durable way.
Control Panel, Programs and Features, Enable or Disable Windows Features
(The following option can be found in the Device Lock submenu)
Check : Built-in shell launcher
-- OK
Close Control Panel
Now in the Start menu, you should see a Command Prompt item
Right-click Command Prompt and choose Run as Administrator
In command window should launch, with in the title bar :
[Administrator: Command prompt]
For all commands that must be launched via a Command Window, it is imperative to have Administrator in the title bar.
-- 4.1 Command window via desktop shortcut
Right-click on the desktop then New -> Shortcut
Enter the location of the element -> put "cmd.exe" (Without quotes)
Next Button
Enter a name for this shortcut -> put "Command window" (Without quotes)
Finish button
Right-click on this new shortcut -> Properties
Shortcut tab, Advanced button
Check Run as administrator
OK, Apply, OK
Now all command windows opened by this shortcut will be opened "as administrator".
---------------------------------------------------------------------------------------------
(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-
Edited 36 time(s). Last edit at 11/04/2023 04:39PM by Otomatic.
Sorry, you can't reply to this topic. It has been closed.
