It is currently Tue Aug 16, 2022 3:34 pm


All times are UTC


Forum rules


Please click here to view the forum rules



Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: root password reset successful but login fails - MSSql 5.6
PostPosted: Fri Jun 10, 2022 12:04 pm 
Newbie
Newbie

Joined: Mon May 30, 2022 12:28 pm
Posts: 4
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


Top
 Profile  
 
 Post subject: Re: root password reset successful but login fails - MSSql 5
PostPosted: Wed Jun 22, 2022 10:32 am 
Newbie
Newbie

Joined: Fri Apr 01, 2022 11:32 am
Posts: 6
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, ...


Top
 Profile  
 
 Post subject: Re: root password reset successful but login fails - MSSql 5
PostPosted: Mon Aug 01, 2022 12:32 pm 
Newbie
Newbie

Joined: Sat Jul 09, 2022 11:54 am
Posts: 4
Before restarting the service, just issue a 'flush privileges' and try logging in with another session.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ]  Moderators: Moderators, Support Team

All times are UTC


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Hosting | Domains | Servers | Extras | Order | Support | Contacts | FreeHostia © 2011