1

Topic: Fresh install prob/fix - Access denied for user 'root'@'localhost'

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.8 MARIADB edition.
- Linux/BSD distribution name and version: Ubuntu 18.04.1 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): NGINX
- Manage mail accounts with iRedAdmin-Pro? N/A
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Fresh install produces following message for all database interactions...

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Attempting the normal /usr/sbin/mysqld --skip-grant-tables --skip-networking start + password reset produces...

ERROR 1131 (42000): You are using MariaDB as an anonymous user and anonymous users are not allowed to modify user settings

dpkg-reconfigure mariadb-server-10.3 - also fails to correct problem.

Only solution was to completely deinstall all mariadb + mysql packages + manually reinstall (before bash iRedMail.sh) via...

apt-get install mariadb-server mariadb-client libmariadb-dev-compat

This provides clean install.

----

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

2

Re: Fresh install prob/fix - Access denied for user 'root'@'localhost'

iRedMail requires a fresh server which doesn't have MySQL/MariaDB/OpenLDAP/PostgreSQL/Apache/Nginx installed.