#passwd admin
#passwd root
#cd /var/service/mysqld
#sv d .
#expand-template /root/.my.cnf
#expand-template /var/service/mysqld/set.password
#/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
#sv u .
#mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Still can't log in from shell logged in as root, without a password parameter to the mysql command.
mysql --user='USER' --password='PASSWORD' works for users, but not for root.
I do have a user with super permissions. Do you recommend I delete the root user and add it according to the faq? I have tried following the faq instructions for Restoring accidently deleted MySQL root user as well, but no joy.