i havent logged in to my server in a long time and i forgot the root administrator password that i had configured for the mysqld server, now i need to run a script with root access to the database but i forgot it.

is there a way to reset forgotten mysql password