FreeHostia Forums
http://forum.freehostia.com/

root password reset successful but login fails - MSSql 5.6
http://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/