How To create Database facing operation failed Error

Welcome @applemart Happy you are here

Kindly run the following command in SSH terminal mysqld_safe --syslog then retry creating the database and post the contents of cat /var/log/syslog

Also post any issues here https://<IP Address>:8090/serverstatus/cyberCPMainLogFile after retrying

remove special charter and try

Should help if you possible change mysql root password or there are inconsistencies

sorry, it is not clear where I should change the password and where I should update the new password so it can connect?

You have to use mysql console e.g.

> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';