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

3 years, 9 months ago Stephen Rynas

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.