I am trying to implement your solution, it is much better. But ...
The /etc/mysql/debian.cnf file is as follows:
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = root
password =
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = root
password =
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
How do I enter the correct credentials. Just put the password after the equal signs?
I am also worried that the file starts with the warning 'DO NOT TOUCH'. Please comment ...