I am not able to perform action. Error-access denied for user - root@localhost (using password: YES)

 am trying to add mySQL database but getting this error:

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:

  1. Open command prompt. To open command prompt, click Start, click Run, and enter cmd.exe.
  2. Go to /bin directory of mySQL (C:/mySQL/Bin).
  3. Enter following command on command prompt:mysql -h 127.0.0.1 -u root -p
  4. 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.
  • 22 Utenti hanno trovato utile questa risposta
Hai trovato utile questa risposta?

Articoli Correlati

How To Create Tables / Move Data to SQL Server On Hosting Server?

First step is database creation on the host server. Follow these steps: Step 1: Create SQL...

MS SQL Server Error: Unable To Create The SQL Server Object

Answer: If you are trying to install Hosting Controller on a machine where MS SQL server is not...

When I try to add MS SQL database, I get error

This error occurs in two cases: MS SQL services are not running Hosting Controller is...

What is MySQL, MS SQL, etc?

Answer: MySQL and MS SQL are database systems. Depending on what your host provides, you can use...

What is MySQL Database?

MySQL is an open-source RDBMS (Relational Database Management System) that relies on SQL for...

Powered by WHMCompleteSolution