Help needed - Reset heidi sql password

Daniel_bbox posted 10 months ago in General

Hi all,

I am working with Maria db and HeidiSQL as the connection manager. I forgot my Heidi SQL password to log into the database. I already tried the way of importing the data settings and looking for the password number in "Servers\Name\Password<|||>1<|||>....". Since I exported all data before forgetting the password I have been told that there are to options:

  1. Resetting the password
  2. Deleting both Programs completely.

I did the second step, however the system is always pulling the user information from somewhere?

I am looking for a way to get back access to the system. Either resetting the password or by deleting and downloading again to create a new user. Help would be highly appreciated.

ansgar posted 10 months ago

If you install HeidiSQL again, then import your old settings and log on to the server, you should be able to reset your password in the Query tab:

SET PASSWORD = PASSWORD('myNewPasswordAndIwontForgetItHonestly')

Please login to leave a reply, or register at first.