Error: 71400050 : Unable to perform action. Error: Access denied for user: 'admin@localhost' (Using password: YES)
How do I resolve this?
Answer: This errors occurs if the mySQL root user specified in Hosting Controller settings doesn¬t has sufficient database privileges for the required operation.
SOLUTION
Grant all privileges to ¬root¬ user and set this user in mySQL settings in Hosting Controller.
To grant privileges to root user, follow these steps:
- Open command prompt. To open command prompt, click Start, click Run, and enter cmd.exe.
- Go to /bin directory of mySQL (C:/mySQL/Bin).
- Enter following command on command prompt:mysql -h 127.0.0.1 -u root -p
- Set privileges for root user by entering following command on mySQL command line:mysql> grant all privileges on *.* to root@127.0.0.1 identified by ¬password¬ with grant option;.
Note: ¬password¬ is the password of root user and it must be given in the quotes.