Database not allowing me to use indexer

[nakul2612]

cd /Applications/MAMP/htdocs/Magento2
 php bin/magento indexer:reindex

[Zend_Db_Adapter_Exception]
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using pas
sword: YES)

[PDOException]
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using pas
sword: YES)

These are the two errors that i got when I wanted to reindex the invalid indexers. Please help me I'm not able to reindex my indexers.

[David Garbe]

Don't run that as root. Switch to the magento user and re-run the command. 

[nakul2612]

Thank you so much for you reply. Can u tell me how to switch to magento user . I'm really new to this thing.

[David Garbe]

su magento

enter the magento password if you're asked for it.

Then run

sudo bin/magento indexer:reindex

[nakul2612]

XXX-2:bin XXXX$ su magento
Password:
su: Sorry
------------------------NOR---------------------
XXXX-2:~ XXXX$ su magento
Password:
su: Sorry

Its not accepting any password that I have used. 

[nakul2612]

Should I have to input the magento account password or the database password that I have used ?

---

@David Garbe wrote:

su magento

enter the magento password if you're asked for it.

Then run

sudo bin/magento indexer:reindex

---

[David Garbe]

magento account password

[nakul2612]

I'm really sorry I'm unable to login or change the user that way, it is not accepting the password, I have shared the screen shot in my previous replies. Please look into and check if I am writing my commands in the right directory or not. If there is any link on this it would really great. 

[nakul2612]

The below are my technical details:

a) OS : Mac OS Seirra

b)localhost: MAMP & MAMP Pro 

c) Magento Version : Magento Community edition 2.1.3. 

I have done a web setup wizard. And I have stuck in this step. Hope these information might help for you to help me out.

[yjxm]

Hi, I have the same problem. Did you fixed the problem? thanks