![]() ![]() Now enter 'quit' at the mysql command promt to exist mysql. Note that the update may report that it has updated more than one row, that because there may be more than one user accounts with the userid of 'root' each with a different domain i.e. Post MYSQL version 5.7 the column name changed UPDATE er SET authentication_string=PASSWORD('MyNewPass') WHERE User='root' Pre MYSQL version 5.7 UPDATE er SET Password=PASSWORD('MyNewPass') WHERE User='root' ![]() Now we are going to reset the password for the root user, of course this could be used to reset any users password.Įnter the following 2 commands at the mysql> command prompt, each with a semi colon at the end of a line, and press ENTER after each line to issue the command to mysql. Open the MySQL console wampmanager -> MySQL -> MySQL Console wampmanager -> MySQL -> Service -> Start/Resume Service Stop the mysql service wampmanager -> MySQL -> Service -> Stop ServiceĮdit the my.ini file wampmanager -> MySQL -> my.iniįind the (32bit) or (64bit) section in the ini fileĪdd this line directly after that section heading skip-grant-tables Here is a method that will allow you to reset the MYSQL 'root' password quite simply. Unknown/unsupported storage engine: InnoDB 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. ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |