Topic: Upgrading to 0.9.7 MariaDB mysql credentials /root/.my.cnf not valid
When attempting to upgrade to iRedAPD-2.1 or iRedAdmin-0.8 by running bash /tools/upgrade_iredapd.sh or /tools/upgrade_iredadmin.sh as root user it erros with:
<<< ERROR >>> MySQL user name 'root' or password is incorrect in /root/.my.cnf, please double check.
/root/.my.cnf is of the format below, and the password is correct:
[client]
host=127.0.0.1
port=3306
user=root
password="aaaabbbbcccc"
I wonder if this is caused by the use of the unix_socket authentication plugin?
MariaDB [(none)]> SELECT User, Password, plugin from mysql.user;
+-------------+-------------------------------------------+-----------------------+
| User | Password | plugin |
+-------------+-------------------------------------------+-----------------------+
| root | *xxxxxxxxxxxxxxxxxxxxxxxxxxx | unix_socket
cheers
Chris
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.