Upgraded from MySQL 5.5 to MariaDB 10.0

If you use old pre-4.1-style MySQL passwords, change it to minimum 8 characters. 12-18 characters recommended.

To change your MySQL Database password:
cPanel > MySQL Databases
Current Users > Change Password

And update the applications to utilize them
e.g.
edit wp-config.php file for WordPress