Im busy updating my iRedMail setup from 0.9.6 to 0.9.7
My first issue is already coming when I try to update iRedAPD to 2.1 .. I keep on getting the below error, and I have confirmed that my password is correct by looking in the tips file and the backup script which is working. I run the update script and I get this error:
<<< ERROR >>> MySQL root user name or password is incorrect in /root/.my.cnf, please double check.
After digging around for a long while, I discovered that this could be due to Ubuntu applying the auth_socket plugin to my root mysql account. I am not sure if this is the problem or not? Maybe someone can shed some light, but I cant even log into my root mysql account from root, the only way I can login to the root mysql account is to sudo mysql -u root from a normal user.
What are the options here? Do I create another user with full privileges and update the .my.cnf file with those credentials or do I remove the auth_socket plugin and change it to the mysql_native_password plugin?
<<< EDIT >>>
Just in case anyone else has this problem, I went with my first option of creating a new user with all privileges and this fixed my issue.