Here is a method that will allow you to reset the MYSQL 'root' password quite simply. Unknown/unsupported storage engine: InnoDB
#LOST PHPMYADMIN ROOT PASSWORD WAMP REGISTRATION#
Plugin 'InnoDB' registration as a STORAGE ENGINE failed. Plugin 'InnoDB' init function returned error. InnoDB: The system tablespace must be writabe! \ibdatai can't be opened in read-write mode InnoDB: Completed initialization of buffer pool
InnoDB: Initializing buffer pool, size = 128.0M InnoDB: Not using CPU crc32 instructions InnoDB: Compressed tables use zlib 1.2.3 InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: The InnoDB memory heap is disabled InnoDB: Using atomics to ref count buffer pool pages (I wrote a new question here to troubleshoot this since I feel like this is a different issue.)Įdit 2: I tried the instructions in the link provided by in the comments and when I set the console to return feedback on the instructions, it reported this, and failed to change anything: C:\wamp\bin\mysql\mysql5.6.17\bin>mysqld -skip-grant-tables -console While I can access the my.ini file, make changes without problem, and restart MySQL without issue through WAMP or otherwise, the line skip-grant-tables is not taking effect, leaving me with a password prompt or no access to do anything.
I am just getting the hang of using a stack for web development, and configuring access to a LAN site through WAMP was quite an adventure, so if possible, I would prefer something that does not require reinstalling everything again.Įdit 1: Went ahead and tried ’s solution. I would appreciate any advice and apologise if this is a newbie type of thing to ask.
#LOST PHPMYADMIN ROOT PASSWORD WAMP HOW TO#
This video explains how to change passwords, and it agrees with the answers in the StackExchange answer above, but evidently, I need another method to do this now since I did not know I would lose access as the guy warns. WAMP comes with a MySQL Console but I am unable to use it since it prompts me for a password which as I stated, no longer have. Some solutions ask one to reset the password via command line ( including this source), and I have tried that through the Windows command line without success because I now have no privileges: mysql> SET PASSWORD FOR = PASSWORD('mynewpassword') ĮRROR 1044 (42000): Access denied for user to database 'mysql'
The solutions offered on that question don’t work for me because unfortunately I have lost the password that I reassigned root to. I changed the password for my account in PHPMyAdmin and like ( this person asking here) and locked myself out of PHPMyAdmin on my browser.
0 kommentar(er)
