Re: Not understanding the simplest security scenario

[jon gore]

The reason why the first command worked while the second one failed is because the syntax of the second command is incorrect. When using the -u option, you should specify only the username and not include the hostname. Therefore, the correct syntax should be:

Copy code
mysql -u root -h localhost
This will connect to the MySQL server as the root user and specify the host as "localhost".

In the first command, you did not specify a hostname, so it defaults to the local host which is also "localhost". The command is equivalent to:

Copy code
mysql -u root -h localhost
This is why it worked without any issues.