How do you mod a password in MYSQL Workbench

TUGaming

New Member
May 10, 2019
2
0
0
#1
I am trying to work with MYSQL workbench to learn some of this and I had a buddy make an account for a server and then forget the password so I can figure out how to change it. But I'm not figuring out how to change the value to correspond to the new password. Any help is appreciated.
 

sudo

New Member
May 12, 2019
1
0
0
#2
The passwords are encrypted using a hash, a salt, and the dbsecret in your config.lua, the easiest way to reset your password would be to register another account using the password you want to use, and copy the hash and salt over to the original account.

I can't really comment on MySQL workbench as I feel it's pretty mediocre and I don't use it, but you can do this in terminal pretty easily.

Code:
mysql -u<user> -p
use swgemu;
select * from accounts where username='<newly created account name>';
Take note of the password and salt

Code:
update accounts set password='<the password from the newly created account>' where username='<account name you forgot the password for>';
update accounts set salt='<the salt from the newly created account>' where username='<account name you forgot the password for>';
Hope this helps.