Everything is easy when you know how!
Command+Shift+G
Everything is easy when you know how!
Command+Shift+G
Needed to set a MySQL root password. Found this article which suggested a way when no password is yet configured:
mysqladmin -u root password NEWPASSWORD
And a way when a password is already configured:
mysqladmin -u root -p'oldpassword' password newpass
Note: you use ‘mysqladmin’ not ‘mysql’.
If you want to allow root logins to your server, but want to disallow root logins with a password (leaving key logins enabled), then you can edit your /etc/ssh/sshd_config file and specify PermitRootLogin without-password.