system upgrade install fails when a mysql root password is set

Setup a mysql root user password following the below instructions and got an error reported from postConfigure:

post-mysqld-install Successfully Completed
NOTE: Using MariaDB Columnstore password from /root/.my.cnf
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Error running post-mysql-install, /tmp/post-mysql-install.log

---------------------------------------------------------------------

setup:

/usr/local/mariadb/columnstore/mysql/bin/mysqladmin --socket=/usr/local/mariadb/columnstore/mysql/lib/mysql/mysql.sock -u root password 'Calpont1'

You will then also need to let cron jobs work on the database so create a personal mysql config file for root in /root/.my.cnf containing:

[mysqladmin]
user = root
password = Calpont1

Make sure the permissions are set appropriately:

1. chmod 0600 /root/.my.cnf