The Ultimate Guide to High Availability with MariaDB

Comments - Spurious - "Access denied for user 'root'@'localhost' (using password: NO)" in the /var/log/mysql/error.log.1 file

2 years, 10 months ago Daniel Black
Re: Spurious - "Access denied for user 'root'@'localhost' (using password: NO)" in the /var/log/mysql/error.log.1 file [Answer]

Because this is so soon after startup, I'm assuming the Mint service file has a trigger that attempts to run `mysql_upgrade` or something similar automaticly. It also could be a check that the mariadb service is running.

If there are entries at a periodic interval that would probably be a logrotate script attempting to integrate with the server to rotate log files.

Regular intervals could also be some monitoring program

Solutions include:

  • ignoring it
  • changing the root user to use unix_socket authentication only (as these scripts run as root) and this keeps it secure without a password. In 10.4 onwards unix_socket auth and passwords are supported at the same time.
  • find the two or more instances and edit their interaction with the server
  • remove the need, edit the service file to not attempt mysql_upgrade, and change the error-log to default blank (stdout) and let journalctl manage all the things done by logrotate (and disable the log-rotate).
 
2 years, 10 months ago Stephen Rynas
Re: Spurious - "Access denied for user 'root'@'localhost' (using password: NO)" in the /var/log/mysql/error.log.1 file

SOLVED. The problem has been attributed to the lack of passwords being placed in the file: "/etc/mysql/debian.cnf". I had initially avoided doing any modifications to this file, as it had the admonition "# Automatically generated for Debian scripts. DO NOT TOUCH!". After running out of options, I went ahead and modified.

Of course things were not that simple. I am using PHPMyAdmin and Firefox. Firefox has its own password saving feature. Turns out that the password that you need to enter in the file debian.cnf, after being generated by PHPMyAdmin and then saved by Firefox are the passwords that you need to enter in the file: "/etc/mysql/debian.cnf"

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.