cancel
Showing results for 
Search instead for 
Did you mean: 

Database not allowing me to use indexer

Database not allowing me to use indexer

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.

9 REPLIES 9

Re: Database not allowing me to use indexer

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

Re: Database not allowing me to use indexer

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

Re: Database not allowing me to use indexer

su magento

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

 

Then run

 

sudo bin/magento indexer:reindex

 

Re: Database not allowing me to use indexer

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. 

 

Re: Database not allowing me to use indexer

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

 


 

Re: Database not allowing me to use indexer

magento account password

Re: Database not allowing me to use indexer

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. 

Re: Database not allowing me to use indexer

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.

Re: Database not allowing me to use indexer

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