MySql for Sysaid

tiki1017
tiki1017 used Ask the Experts™
on
Hi Guys,
Anybody knows how to setup mysql for Sysaid? I don't know much about sql and setting it up. When I test the database connection in the sysaid installtion I get a prompt "Host <name> is not allowed to connect to this MySQL server"

Kind Regards,
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2012
Commented:
That usually means you haven't granted a user from that host to access the database.  Using a mysql root/admin user run the following:

grant all on username@ip_address_or_hostname_of_sysaid_host identified by 'password';

See http://dev.mysql.com/doc/refman/5.1/en/grant.html for more information on granting privileges

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial