I've just installed MySQL server with no password on root account. I was prompted to enter root password 3 times and I left it blank all three times because I don't want to use password. But now it seems to me that may not be such a great idea.
I try to connect from Workbench (with now password entered) and I get error:
Access denied for user 'root'@'localhost'.
Why if there is no password??
I realize now, that if I only have had provided some dummy password on installation I would have no problems no, so I try to set it by typing:
mysqladmin -u root -p password; enter blank password, and again, get the following:
mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost'
If I just type "mysql" into console I get:
Access denied for user 'me'@'localhost' (using password: NO)
If I can have root account without password, and if I won't have much problems in that case, than I'd like to leave it without pass, but if that isn't good, than please tell me how set password. And if it's good to leave it without password then please tell me how to connect without pass :)
EDIT: Linux distro: Mint Cinnamon 64-bit; MySQL version: 5.7