Piwik mysql user pw

Hi folks. Havent found the answer for this by searching docs or forum.
I simply want to change the piwik user and password that piwik uses to connect to the mysql database.

I know how to change the user in the config.ini.php and have created a new user in the database with the proper credentials.
the password in config.ini.php a hash.

(from config.ini.php)

host = "localhost"
username = "user_piwik"
password = “0123456789”

What kind of hash? Can I generate a hash with my known pw?

The database password is clear text.

I disagree, at least not in config.ini.php.

database password is in clear text in the config file