In the video Basic Security Part 2 https://youtu.be/AMceyWao3Ao, the instructor says that after you create your first user, the localhost exception closes. However, in testing, having created a user, if I turn off authorization in the config file and restart the server, then I can get back in on the localhost exception. I ran show dbs to confirm and it came back fine, although I haven’t tried other commands.
Obviously, the video is correct on the assumption that you have authorization enabled in your config file, but it doesn’t seem to be…how can I say it…entirely accurate? Obviously, turning off authorization once your system is in general use and possibly accessible from the outside world is a major no-no and you wouldn’t normally do that.
PS. Great course! I am really enjoying it