In chapter 4 I have placed the file index.php in the directory connect and have amended the following line in order to connect to the sql server on my computer: mysqli_connect('localhost', 'root', 'mypassword');

The issue: adding 'mypassword' won't open a connection to the database server. I have to substitute the password 'root' to open a connection.

However, I changed the password from 'root' as instructed in Ch. 1 Installation. I have checked that 'mypassword' is correct by using the terminal and establishing a connection that way.

Could you advise? I am am Apple user using MAMP.
thanks in advance