All posts tagged:

mariadb

Troubleshoot for Root Access Denied on MySqlDump

Background We received an automatic email saying the mysqldump: Got error: 1045: “Access denied for user ‘root’@’localhost’ (using password: YES)” when trying to connect and this is related to automysqlbackup. When we test this by running: automysqlbackup the error will show up and the backup file on /var/lib/automysql/daily are very…

Troubleshooting ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

Background After the virtual machine has been provisioning with LAMP and you check the MariaDB status systemctl status mariadb The MariaDB status showed the ERROR 1045 (28000): Access Denied for user ‘root’@’localhost’ (using password: NO). It happened before BUT no documentation to fix this. Solution From the other cloud services…