How to fix forgotten wordpress password

Yesterday I installed a new WP in the GD space. After I installed it in a hurry, I left because of something. The default password specified by the system was still the default password specified by the system. Later, when I tried to log in to the backend to check, I found that I forgot to copy and save the password and did not change it. What should I do? If you search online, there is still a way.
Enter the database where WordPress is located and execute the SQL command:
“update user set password=password(“new password”)  where user=”username”;”

Subscribe to wordpress password