mysqli: (HY000/2002) problem
Posted by: Him (122.191.204.---)
Date: January 07, 2019 05:17PM

I am new to WAMP and MySQL, tried to login to phpMyAdmin in WAMP + Windows 10. But cannot log in to the MySQL server when I tried to login as root ( no password ) ,mysqli_real_connect(): (HY000/2002)

mysqli.log and apche.log as follow:

2019-01-07T15:54:09.861840Z 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: .\ibdata1, Space ID:0, Flags: 0. Please refer to [dev.mysql.com] for how to resolve the issue.
2019-01-07T15:54:09.865998Z 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.
2019-01-07T15:54:09.869140Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-01-07T15:54:10.214311Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-01-07T15:54:10.215541Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-01-07T15:54:10.216638Z 0 [ERROR] Failed to initialize builtin plugins.
2019-01-07T15:54:10.217605Z 0 [ERROR] Aborting
----------------------------------------------------------------------------------
[Mon Jan 07 23:54:10.144454 2019] [mpm_winnt:notice] [pid 1304:tid 704] AH00455: Apache/2.4.35 (Win64) PHP/7.2.10 configured -- resuming normal operations
[Mon Jan 07 23:54:10.144454 2019] [mpm_winnt:notice] [pid 1304:tid 704] AH00456: Apache Lounge VC15 Server built: Sep 19 2018 16:08:47
[Mon Jan 07 23:54:10.144454 2019] [core:notice] [pid 1304:tid 704] AH00094: Command line: 'C:\\App\\wamp\\bin\\apache\\apache2.4.35\\bin\\httpd.exe -d C:/App/wamp/bin/apache/apache2.4.35'
[Mon Jan 07 23:54:10.144454 2019] [mpm_winnt:notice] [pid 1304:tid 704] AH00418: Parent: Created child process 12936
[Mon Jan 07 23:54:10.594182 2019] [mpm_winnt:notice] [pid 12936:tid 4] AH00354: Child: Starting 64 worker threads.

It will be great if someone can help me out. Thanks.

The WAMP icon is Orange in color

Options: ReplyQuote
Re: mysqli: (HY000/2002) problem
Posted by: Otomatic (Moderator)
Date: January 07, 2019 05:24PM

Hi,

> The WAMP icon is Orange in color
- 1 - READ (and answer) BEFORE YOU ASK A QUESTION

- 2 - Result of
Right-Click Wampmanager tray icon -> Tools -> Check state of services

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.7 32 bit - Apache 2.4.38 - PHP 7.3.2/7.2.15/7.1.26/7.0.33/5.6.40 - MySQL 5.7.25 - MariaDB 10.3.13
Wampserver 3.1.7 64 bit - Apache 2.4.38 - PHP 7.3.2/7.2.15/7.1.26/7.0.33/5.6.40 - MySQL 5.7.25/8.0.14 - MariaDB 10.3.13
PhPMyadmin 4.8.5 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
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


Sorry, only registered users may post in this forum.