| FreeHostia Forums https://forum.freehostia.com/ |
|
| root password reset successful but login fails - MSSql 5.6 https://forum.freehostia.com/viewtopic.php?f=7&t=66270 |
Page 1 of 1 |
| Author: | Rajesh350 [ Fri Jun 10, 2022 12:04 pm ] |
| Post subject: | root password reset successful but login fails - MSSql 5.6 |
I'm attempting to reset the root password. While it seems to be successful (no sql errors & I can see the encrypted values change in the user table) I still cannot login. Any suggestions, thx in advance. Here's my process Add skip-grant-tables to my.ini & restart the service. Execute this sql use mysql; update user set password=PASSWORD('1234abcd') where User='root'; select * from user; 3) Remove skip-grant-tables to my.ini & restart the service. 4) Attempt to login with root & the new password using command line or the workbench. Login fails |
|
| Author: | Ricky786 [ Wed Jun 22, 2022 10:32 am ] |
| Post subject: | Re: root password reset successful but login fails - MSSql 5 |
Don't manually edit the system table. Use the proper command ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password' This ensures the right plugin and encoding format is being used, credentials are flushed, ... |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|