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';