41
px06
7y

Setting up mysql_server and then forgetting the mysql root password 😀

Comments
  • 1
    If you have root access you can easily change it
  • 2
    mysql --defaults-file=/dev/mysql/debian.cnf
  • 1
    That's happens with me always n then I have to uninstall or google for root password 😂😂
  • 1
    Skip grant tables ;)
  • 2
    Not a fan of using .my.cnf? I understand the security implications, but for my dev environment I consider it a massive time saver.
  • 1
    @coderme never really used it because I usually make the password just "password" and disable all remote logins etc because the only reason for it is to host local databases for testing and dev.
  • 1
    @px06 Right, that's my typical use case. I find that even when stored in LastPass, it gets forgotten and I always spend extra time resetting it. That's when I started storing it in my.cnf.
  • 2
    @px06 Same here. But still the password will not be "password", rather a bit more complicated.
Add Comment