WampServer

First the answer about 13 questions:

1 - Windows version: Windows 7 pro x64 Sp1 with updates...
2 - Version WampServer: 3.1.0 64b services
3 - Apache Version : 2.4.27
4 - PHP Version: 5.6.31
5 - MySQL Version : 5.7.19
6 - What color is the WampServer icon: Orange

The next is the situation after turn on e try to enter in PHPmyAdmin and MySQL console:

a - Apache : Look like OK

-- ( wampmanager -> Apache -> Apache error log )
C:/wamp64/bin/apache/apache2.4.27'
[Tue Nov 14 11:23:44.101239 2017] [mpm_winnt:notice] [pid 1268:tid 400] AH00418: Parent: Created child process 4848
[Tue Nov 14 11:23:44.559265 2017] [mpm_winnt:notice] [pid 4848:tid 316] AH00354: Child: Starting 64 worker threads.

-- ( wampmanager -> Apache -> Apache access log )
::1 - - [14/Nov/2017:11:31:57 -0200] "GET / HTTP/1.1" 200 5653
::1 - - [14/Nov/2017:11:31:57 -0200] "GET /index.php?img=gifLogo HTTP/1.1" 200 4549
::1 - - [14/Nov/2017:11:31:58 -0200] "GET /index.php?img=pngPlugin HTTP/1.1" 200 548
::1 - - [14/Nov/2017:11:31:58 -0200] "GET /index.php?img=pngFolderGo HTTP/1.1" 200 694
::1 - - [14/Nov/2017:11:31:58 -0200] "GET /index.php?img=pngWrench HTTP/1.1" 200 741
::1 - - [14/Nov/2017:11:32:00 -0200] "GET /phpmyadmin/ HTTP/1.1" 200 3342
::1 - - [14/Nov/2017:11:32:09 -0200] "POST /phpmyadmin/index.php HTTP/1.1" 200 3528

b - MySQL error log wampmanager -> MySQL -> MySQL log ) : Empty

c - PHP error log ( wampmanager -> PHP -> PHP error log ) :
[14-Nov-2017 11:23:42 UTC] No error - Only to create the file

d - The windows event viewer: Found this:

Nivel Date Font Identification Category
Aviso 14/11/2017 11:32:10 PHP-5.6.31 3 (5)

Event 3, PHP-5.6.31

General:
-Can not find the description of Event ID 3 in source "PHP-5.6.31". The component that generates this event is not installed
on the local computer or the installation is damaged. You can install or repair the component on the local computer.
-If the event originated on another computer, the display information had to be saved with the event.
-The following information was included with the event:
phpMyAdmin [4848]
user denied: root (mysql-denied) from :: 1
Details:
- System
- Provider
[ Name] PHP-5.6.31
- EventID 3
[ Qualifiers] 32768
Level 3
Task 5
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2017-11-14T13:32:10.000000000Z
EventRecordID 24885
Channel Application
Computer Mer-PC
Security
- EventData
phpMyAdmin[4848]
user denied: root (mysql-denied) from ::1

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.
- No hosts there...

If the WampServer icon is green: No it´s Orange but;

8 - Do you have access to localhost (Homepage WampServer)?
Yes, i do.

8a - If so, is there an error message at the bottom of the page?
No, it's look like normal...

9 - Do you have access to phpMyAdmin?
After enter user and enter;
Message on top of page:
# 2002 - & mdash; The server is not responding (or the local server socket is misconfigured).
Message belos the page:
  mysqli_real_connect (): (HY000 / 2002): No connection can be made because the target machine actively refused them.

10 - If you refer to an error message, please include the EXACT wording of the error in your post
My error message is:
Over the orange icon : local server 2 of 3 servers running
When a try to start the MySQL console:
Mysql.exe - Application Error
The application can not be initialized correctly (0xc000007b). Click OK to close the application.

11 - If you use an Antivirus and / or Firewall, please include the names of these
Microsoft Security Essencials : No file in quarantine or blocked.
Windows native FireWall : Found no file blocked.

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

13 - If you have one or more Virtual Hosts defined, please show their definition(s)
I don't know where to see this, I didn't do any...


MY ANOTHER OBSERVATIONS:
I download and install the last original versions, on their original sites, of WampServer, VC++, all recomended by Wamp, and too directx and .net Framework.
I download and run the check_vcredist, and it´s all ok.
The unique problem i see, it's MySQL is not run , because message of iten 10. "The application can not be initialized correctly (0xc000007b)."
The problem is that I have exhausted my possibilities. And didn't found more any information on Internet sites...


PLEASE HELP ME...

Thanks for your cooperation...

Hi,

MySQL always tries to connect with an IPv6 and as it is not defined in the hosts file, there is no connection possible.

The contents of the file C:\Windows\System32\drivers\etc\hosts (Item 7) MUST be :

127.0.0.1 localhost
::1 localhost

For changes to the hosts file to be taken into account, it is necessary either to restart the machine after the modifications, or to restart the DNS which can be done by:
Right-Click Wampmanager tray icon -> Tools -> Restart DNS

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

Sorry, it did not work yet.

MySQL.exe still does not run, whenever I try to run ...gives the error:

Mysql.exe - Application Error
The application can not be initialized correctly (0xc000007b). Click OK to close the application.

Hi,

Exit Wampserver.

With Files explorer, delete the totality of files and folders into wamp64\bin\mysql\mysql5.7.19\data\ and the folder "data" itself.

Open a command windows "as an administrator" (The word administrator MUST be in the title bar) on the folder wamp64\bin\mysql\mysql5.7.19\bin\
In this command windows type :

mysqld.exe --initialize-insecure

This will recreate the data folder.

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

Hi, Otomatic.
As for your answer, I saw in the 'hosts' file that the statements already existed, but they were with the '#' up front.
I think the MySQL.exe file can not start due to some system incompatibility, which I do not know what it is.
In the way you said he was already trying to connect, but I do not think he can even carry it.

I look forward to some idea to try to fix this problem.

I've thought about trying to install WampServer 32b, to try it, I do not know if it would be a good idea or if it would work.

Better to wait ....

Hi,

> I saw in the 'hosts' file that the statements already existed, but they were with the '#' up front.
To be more understandable, I'll say that the only two lines of the hosts file should be:

127.0.0.1 localhost
::1 localhost

and nothing else.

In my humble opinion, installing a 32-bit version will not change anything.

Open a command windows "as an administrator" (The word administrator MUST be in the title bar) and post here the result of a command:

fsutil fsinfo ntfsinfo c:

Of course, if necessary, replace "c:" with the drive letter on which Wampserver is installed.
Now this is the time I turn off my PC (Hey, yes, we are not in the same time zone); So, see you tomorrow.

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

Hi, Otomatic

I was trying to do what you say... and:

1 - Didn't have 'data' folder in that way ...

2 - I trayed run de mysqld.exe like adminstrador on that way ... and a got the same error :

Mysqld.exe - Application Error
The application can not be initialized correctly (0xc000007b). Click OK to close the application.

This happened whit 2 files , only until now, mysql.exe and mysqld.exe.

Hi, Otomatic...

Comands with suport

8dot3name Gerenciamento de 8dot3name
behavior Comportamento do sistema de arquivos de controle
dirty Gerenciar bit incorreto do volume
file Comandos específicos de arquivos
fsinfo Informações do sitema de arquivos
hardlink Gerenciamento de links físicos
objectid Gerenciamento de identificações de objetos
quota Gerenciamento de cotas
repair Gerenciamento de auto-recuperação
reparsepoint Gerenciamento de pontos de nova análise
resource Gerenciamento do gerenciador de recursos de transação
sparce Controle de arquivos esparsos
transaction Gerenciamento de transações
usn Gerenciamento de USN
volume Gerenciamento de volumes


I thought is this what you asked...

Ok, Otomatic...

It's true , i'm in São Paulo, Brasil, now it's 6:21 pm ...

How about de 'hosts' file , i thought that what is with '#' infront of ... it's a coments, right?

Because i let thats coments , and after the 2 lines what you said...

I expect and thank you for your support.

Emerson

Hi, Otomatic...

I was searching the internet, on MySQL site, and they said the following about this error,

# for hex 0xc000007b / decimal -1073741701
STATUS_INVALID_IMAGE_FORMAT ntstatus.h
# {Bad Image}
# %hs is either not designed to run on Windows or it contains
# an error. Try installing the program again using the
# original installation media or contact your system
# administrator or the software vendor for support.
Often seen with 32-64bit dll mismatch.


I don't know if can help us ... but ... i posted...

Emerson

Oi, Otomatic


I was testing the mysql folder , and all '.exe' files on the folder , don't run , all have a same error... when i try run on the Windos Command like a Administrator...


????????.exe - Application Error
The application can not be initialized correctly (0xc000007b). Click OK to close the application.


What a ambient need para run MySQL,

Hi,

It must be determined first, if the disk (volume c is properly formatted NTFS type.

(Note: The results of the commands will be in French, I can not do otherwise.)

Open a command windows "as an administrator" (The word administrator MUST be in the title bar) and type:

fsutil fsinfo volumeinfo c:

There MUST be NTFS in the result, like this:

C:\Windows\System32>fsutil fsinfo volumeinfo c:
Nom du volume : SATA_1_K
Numéro de série du volume : 0xf6e12af3
Longueur maximale du composant : 255
Nom du système de fichiers : NTFS
Prend en charge les noms de fichiers respectant la casse
Préserve la casse des noms de fichiers
Prend en charge Unicode dans les noms de fichiers
Préserve & Applique les ACL
Prend en charge la compression de fichier
Prend en charge les quotas de disques
Prend en charge les fichiers fragmentés
Prend en charge les points d'analyse
Prend en charge les identificateurs d'objets
Prend en charge le système de fichiers EFS
Prend en charge les flux nommés
Prend en charge les transactions
Prend en charge les liens physiques
Prend en charge les attributs étendus
Prend en charge l'ouverture par ID de fichier
Prise en charge du journal USN

C:\Windows\System32>

If there is no NTFS, it is not worth continuing, Wampserver can only work on an NTFS disk

We will now look at the characteristics of NTFS formatting as the sizes of physical and logical sectors, with the command:

fsutil fsinfo ntfsinfo c:

The result is like this :

C:\Windows\System32>fsutil fsinfo ntfsinfo c:
Numéro de série du volume NTFS :         0x636649c8f6e12af3
Version :                                3.1
Nombre de secteurs :                     0x000000001289dff8
Nombre total de clusters :               0x0000000002513bff
Clusters libres  :                       0x00000000011c1562
Total réservé :                          0x0000000000000cf0
Octets par secteur  :                    512
Octets par secteur physique :            512
Octets par cluster :                     4096
Oct./segment d'enreg. de fich.    :      1024
Clust./segment d'enreg. de fich. :       0
Longueur de données valide MFT :         0x0000000019f00000
LCN de démarrage MFT  :                  0x000000000005769d
LCN de démarrage MFT2 :                  0x0000000000000002
Début de la zone MFT :                   0x000000000138fb60
Fin de la zone MFT   :                   0x000000000139c380
Identificateur du Gestionnaire de ressources:        F5F337EA-6B02-11E2-8975-806E6F6E6963

C:\Windows\System32>

It is this result that I ask you.

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

Hi, Otomatic...

Follow the data what you ask:


fsutil fsinfo volumeinfo c: ( in Portuguese)...

num serie - 0xd43f75d2
tam comp - 255
sist arquiv - NTFS
Suporta nome de arquivos que deferenciam maiusculas de minusculas
Presserva maisc/minus. nos nomes de arquivos
Dá suporte a Unicode em nome de arquivos
Preserva e aplica ACLs
Suporta compactação
Suporta cotas de discos
Suporta arquivos esparsos
Suporta pontos de nova análise
Da suporte a identificadores de objeto
... etc.


fsutil fsinfo ntfsinfo c:

num serie volume NTFS: 0x08d43f87d43f75d2
Versão : 3.1
Num de setores : 0x000000001866dfff
Total clusters : 0x00000000030cdbff
Clusters livres : 0x00000000016a6aac
Total reserved : 0x0000000000000420
Bytes por setor : 512
Bytes por cluster : 4096
Bytes por segu filerecord: 1024
Clusters por seg. filereco: 0
Tam dados Mft válido : 0x00000000208c0000
Lcn de inic de Mft : 0x00000000000c0000
Lcn de inic de Mft2 : 0x0000000000000002
Inicio zona Mft : 0x000000000114dd00
Final zona Mft : 0x000000000115a520
Ident de RM : 8FC621E1-7C3F-11E7-A503-D12B142E4C7B

Hi,

It's OK, the disk is well formatted NTFS and the logical sectors are 512 bytes. This is not a "native 4K" disc and it should not be a problem with MySQL.
We will try to install another version of MySQL, for example version 5.7.20 and see if the data folder was created during the installation.
To do this, download:
MySQL 5.7.20 64 bit x64
Then run the dowloaded file "as an administrator" -> Right-Click on the file then run as an administrator.

After this install, go to wamp64/bin/mysql/mysql5.7.20/ folder to see if there is a 'data' folder inside with some files like :

J:\wamp64\bin\mysql\mysql5.7.20>dir
 Le volume dans le lecteur J s'appelle SATA_1_J
 Le numéro de série du volume est DD8A-2E62

 Répertoire de J:\wamp64\bin\mysql\mysql5.7.20

17/10/2017  10:03    <REP>          .
17/10/2017  10:03    <REP>          ..
17/10/2017  10:03    <REP>          bin
13/09/2017  16:48            17 987 COPYING
14/11/2017  10:04    <REP>          data
17/10/2017  10:03    <REP>          docs
17/10/2017  10:03    <REP>          include
17/10/2017  10:03    <REP>          lib
14/11/2017  10:04             6 474 my.ini
13/09/2017  16:48             2 478 README
17/10/2017  10:03    <REP>          share
11/12/2015  11:55               346 wampserver.conf
               4 fichier(s)           27 285 octets
               8 Rép(s)  92 440 162 304 octets libres

J:\wamp64\bin\mysql\mysql5.7.20>cd data

J:\wamp64\bin\mysql\mysql5.7.20\data>dir
 Le volume dans le lecteur J s'appelle SATA_1_J
 Le numéro de série du volume est DD8A-2E62

 Répertoire de J:\wamp64\bin\mysql\mysql5.7.20\data

14/11/2017  10:04    <REP>          .
14/11/2017  10:04    <REP>          ..
17/10/2017  10:03                56 auto.cnf
17/10/2017  10:04               859 DOMI.err
14/11/2017  10:04        12 582 912 ibdata1
14/11/2017  10:04               351 ib_buffer_pool
14/11/2017  10:04        67 108 864 ib_logfile0
17/10/2017  10:04        67 108 864 ib_logfile1
17/10/2017  10:03    <REP>          mysql
17/10/2017  10:03    <REP>          performance_schema
17/10/2017  10:03    <REP>          sys
               6 fichier(s)      146 801 906 octets
               5 Rép(s)  92 440 162 304 octets libres

J:\wamp64\bin\mysql\mysql5.7.20\data>

It is necessary that the folder 'data' exists with its files so that one can continue.

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

I did not understand if I first uninstalled the WampServer ...
or install directly over the existing ...????

Hi, Otomatic...

I tryed over , because i see it was a 'addon', and i do according you said...

But, is the same , after install , when start a mysqld.exe , get a same error...

And i search de 'data' folder , but it isn't exist...


Don't forget any files '.exe' run in mysql folder...

and only 2 of 3 services running...


Emerson

What is the environment required to run MySQL?
Why the others (Apache and MariaD are running ??

Hi,

I do not understand why the date folder can not be created, nor where can these errors come from when running mysqld.exe!
We will install a "addon" of a MySQL version of branch 5.6 which includes the basic data folder, version 5.6.37.

Download this addon : MySQL 5.6.37 64 bit x64 then run it as an administrator.

Then see if there is data folder for wamp64/bin/mysql/mysql5.6.37/

If yes, we can do some other tips.

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

Hi,


Yes, now in the 5.6.37 have the 'data' folder...


I try to select this in WampServer ... but when i start it say...


Mysqld.exe - erro de aplicativo

O aplicativo não pode ser inicializado corretamente (0xc000007b). Click em OK para fechar o aplicativo.


...and after this;


Aestan Tray Menu
Could not execute menu item(internal error) [Exception] Could not perform built-in action: No service has been opened yet!

I think the problem is because the .exe file does not even open, so it can not do anything ...

And why not open ??? What does it take for it to open ???

But the strange thing is that the others (Apache and MariaD are opening normal ...