MySQL Service Test

[david_sh]

Hi I'm setting up Enkompass for the first time and everything is going well except the MySQL service is not testing correctly. The Server Connection test passes but the MySql Service Test fails. I checked under Windows -> Services and it appears to be running (as Local System).

I'm not sure what else to do. I followed the instructions from Enkompass. Not sure where I could have gone wrong.

Thanks for any help. And sorry if this post is in the wrong section of the forums.

[cPanelThrash]

Typically I see two reasons why this doesn't work.

1) Remote Root access isn't enabled
2) A value gets entered for Instance (which is a MSSQL thing)

If neither of these are the case, please open a ticket so we can investigate further.

[david_sh]

Yeah it was that remote root access wasn't enabled... Thanks!

[trackpads]

How did you enable remote access?

[cPanelSalinas]

If MySQL is on the same server as Enkompass, you can log into PhpMyAdmin as 'root' and add % to root under the Privileges tab.

http://localhost:2078
Server: localhost
username: root
password: root_password

OR

Use command line on MySQL server

mysql -u root -p

Password: root_password

THEN

use mysql;

THEN

grant ALL on *.* to root@"%" identified by "root_password" with grant option; (be sure to use quotes around the wildcard and the root password)

THEN

flush privileges;

THEN

quit