I am just getting started with PHP & MYSQL. I have had MAMP installed for quite a while and have used it to dabble in local development mostly with Wordpress.
Following along with the instructions in the book "Build Your Own Database Driven Web Site Using PHP & MySQL”; I installed MySQL Server. All the terminal commands were reacting as set out in the book.
But.... I am now trying to connect to the MySQL server using the command:
mysql -u root -p
I enter my password and I keep getting the following error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
I even went ahead and changed my password (via MAMP) but still no joy.
I am getting the feeling that there might be some kind of conflict between the MAMP program and the newly installed MySQL Server program but I have no idea how to sort this out.
As you can imagine, I am hyped to get started with the coding/programming (:
How do I solve this?
Thank you in advance for your help