I went through the post installation instructions and the following command didn't worked for me:
mysql_upgrade -S /run/user/$(id -u)/akonadi/default/mysql.socket --defaults-file=~/.local/share/akonadi/mysql.conf
it gave me the error:
mysql_upgrade: unknown variable 'defaults-file=~/.local/share/akonadi/mysql.conf'
According to "mysql_upgrade --help" the --defaults-file option is "specified before remaining options"
So, changing the command to:
mysql_upgrade --defaults-file=~/.local/share/akonadi/mysql.conf -S /run/user/$(id -u)/akonadi/default/mysql.socket
gave me this:
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/user/1000/akonadi/default/mysql.socket' (2)
FATAL ERROR: Upgrade failed
When checking where mysql.socket is I found out that it's in the path /run/user/1000/akonadi/
mysql_upgrade --defaults-file=~/.local/share/akonadi/mysql.conf -S /run/user/$(id -u)/akonadi/mysql.socket
Actually upgraded the DB successfully.
Steps to Reproduce:
1. See Description
Akonadi MySQL DB doesn't get (manually) upgraded due to wrong instructions.
Akonadi MySQL DB should be upgraded