Phpmyadmin does not open after sena default change

Asked

Viewed 1,170 times

1

Good afternoon, everyone,

After modifying the default Mysql password (In the Xampp interface), it no longer opens and displays the following error message:

1045 - Access denied for user 'root'@'localhost' (using password: YES)

" phpMyAdmin tried 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 Mysql administrator. "

I made the following modifications in config.inc.php, without 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 typing localhost/phpmyadmin, a mysql configuration Wizard is displayed and it does not pass the first page. Then I returned to the previous state;

I tried to reset the root password using an existing bat in the shaman installation (resetaroot.bat), and the return was the following:

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’t be opened in read-write mode

[ERROR] Innodb: The tablespace system 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 modified the mysql password by the xammp interface itself, but the same error message is displayed:

1045 - Access denied for user 'root'@'localhost' (using password: YES)

" phpMyAdmin tried 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 Mysql administrator. "

Other information: Mysql does not appear as a service in services.Msc;

Thanks in advance for your support.

  • Niltão!!!! how’s my brother boy blz? how long boy! hahaha. Back to Fortal? My plate your problem seems to be permission in Mysql directory. A face hug!

  • Check here also: http://stackoverflow.com/questions/23907736/change-mysql-root-password-in-phpmyadmin

  • Faaaaala Gustavão! Beauty my brother? How long my brother! Back, I’m living in Jericoacoara! Interesting that a few days before posting this question, I went to your facebook profile but it seems that you do not access much there...hahaha.. Now I know which social network you usually interact with! hehehe.. Yes, I modified the default password of mysql by the interface of xampp and it seems that gave configuration divergence, not updating the password in all files. Then I had to leave it like this: mysql_safe -Skip-Grant-Tables -Skip-network & to back up the banks. thanks for the support! Hug!

  • Voce has to modify the password in config.inc.php also manually or delete the file and access the phpmyadmin setup to create one with new settings! config.sample.inc.php is a sample of how it should be! you should not change it manually!!!

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.