To log into MySQL as root user on a Plesk server, you will need to specify the username "admin" and use the Plesk administrator password.
You can also execute the following command if you are logged in via SSH:
mysql -uadmin -p$(cat /etc/psa/.psa.shadow)