1

Topic: mysql credentials .my.cnf not valid

==================== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.6
- Linux/BSD distribution name and version:  ubuntu
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

I do this upgrad of tool/  sudo bash upgrade_iredadmin.sh

then i get this error that there is no .my.cnf file in root folder.

So i added this and it shows

<<< ERROR >>> MySQL root user name or password is incorrect in /root/.my.cnf, please double check.

So this is my example:

[client]
host=127.0.0.1
port=3306
user=root
password="xxxxyyyyyzzzz"

when i type mysql  -> i get this result

ERROR 1045 (28000): Access denied for user 'COMPANYNAME'@'localhost' (using password: NO)

when i type mysql -u root -pxxxxyyyyyzzzz

mysql> this is good :-)

The bad thing is i can not get this to work with the .my.cnf file.

Can you help me ?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: mysql credentials .my.cnf not valid

Does it work if you switch to root user (with 'su -' or 'sudo su -') first and run the script as root user (not 'sudo bash ...')?

3

Re: mysql credentials .my.cnf not valid

The upgrade would not work from /root/, but did when I switched to  my "regular" user/home. I had to cp /root/.my.conf to ~ first.