Question: Unable to create MySQL database: Error: 71400050: Unable to Create db.
HC is unable to connect MySQL Server
This errors occurs if the MySQL root user specified in Hosting Controller settings doesn't has sufficient database privileges or MySQL server is not accepting connection remotely.
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 (X:\MySQL\Bin).
- Enter command on MySQL command line: mysql> grant all privileges on *.* to root@IPAddress identified by 'password' with grant option;
- To reload the grant tables, perform a flush-privileges operation by executing this command: mysql> FLUSH PRIVILEGES;
'password' is the password of root user and it must be given in the quotes.
IPAddress is IP which is given in HC panel for MySQL settings.