---
title: "SQL Audit Logging"
canonical: "https://manual.cimon.com/space/AUR/4566909058/SQL%20Audit%20Logging"
format: markdown
---
If using the new password format
If you are using a server with the new password encryption method, it is still possible to connect. You can modify a user to use the legacy password encryption by running the following command in MySQL Workbench:
`ALTER USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'password';`
Replace “username” and “password” with your remote account credentials.
You may need to run the command `FLUSH PRIVILEGES;` to apply the change.
You can also change the default password encryption method for an existing server by editing its config file. By default, this is located at “C:\ProgramData\MySQL\MySQL Server 8.0\my.ini”.
Add or edit the following line (You may already have this at line 109):
`authentication_policy=mysql_native_password,,`
Then restart the server. Any existing users may still need to be altered.
Editing users
If you do not wish to use the root user, HeidiSQL provides a GUI for editing users. Go to “Tools” -> “User Manager”:
