Good afternoon guys,
After modifying the default Mysql password (in the Xampp interface), it does not open anymore and displays the following error message:
1045 - Access denied for user 'root' @ 'localhost' (using password: YES)
"phpMyAdmin attempted to connect to the MySQL server, and the server rejected the connection. Check the host, username and password in config.inc.php and make sure they match the information provided by the administrator MySQL. "
I made the following changes to config.inc.php, with no success:
/ * Authentication type and info * /;
$ cfg ['Servers'] [$ i] ['auth_type'] = 'config';
$ cfg ['Servers'] [$ i] ['user'] = 'root';
$ cfg ['Servers'] [$ i] ['password'] = 'NEW PASSWORD';
$ cfg ['Servers'] [$ i] ['extension'] = 'mysqli';
$ cfg ['Servers'] [$ i] ['AllowNoPassword'] = true;
$ cfg ['Lang'] = '';
After that, I made a copy of config.inc.php
I renamed config.sample.inc.php to config.inc.php;
When you type localhost / phpmyadmin, a mysql configuration wizard is displayed and it is only the first page. Then I returned to the previous state;
I tried to reset the root password using an existing bat in the xampp installation (resetaroot.bat), and the return was as follows:
c: \ xampp \ mysql> resetroot.bat
[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --ex plicit_defaults_for_timestamp server option (see documentation for more details).
[Note] Plugin 'FEDERATED' is disabled.
[Note] InnoDB: Using atomics to ref count buffer pool pages
[Note] InnoDB: The InnoDB memory heap is disabled
[Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
[Note] InnoDB: Compressed tables use zlib 1.2.3
[Note] InnoDB: Not using CPU crc32 instructions
[Note] InnoDB: Initializing buffer pool, size = 128.0M
[Note] InnoDB: Completed initialization of buffer pool
[ERROR] InnoDB:. \ ibdata1 can not be opened in read-write mode
[ERROR] InnoDB: The system tablespace must be writable!
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] Unknown / unsupported storage engine: InnoDB
[ERROR] Aborting
[Note] Binlog end
[Note] bin \ mysqld.exe: Shutdown complete
Passwoerter fuer Benutzer "root" und "pma" wurden geloescht.
Passwords for user "root" and "pma" were deleted.
Press any key to continue. . .
I have modified the mysql password through the xammp interface itself, but the same error message is displayed:
1045 - Access denied for user 'root' @ 'localhost' (using password: YES)
"phpMyAdmin attempted to connect to the MySQL server, and the server rejected the connection. Check the host, username and password in config.inc.php and make sure they match the information provided by the administrator MySQL. "
Other information: MySql does not appear as a service in services.msc;
Thanks in advance for your support.