I need to run a command
mysql_upgrade which, when ran as root, returns
Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect FATAL ERROR: Upgrade failed
So I decided I need to log in as user
mysql. How can I do it?
I set up the password for the user
passwd and try to log in:
$ ssh -l mysql 126.96.36.199 firstname.lastname@example.org's password: Permission denied, please try again.
I logged in as root and set shell for
chsh -s /bin/bash mysql.
I checked that
AllowUsers entry contains user
DenyGroups contains only
deniedssh; the latter group doesn't contain user
# getent group deniedssh deniedssh:x:500:
What can I do to log in as the non-interactive user