Solved

MySql for Sysaid

Posted on 2012-04-02
1
683 Views
Last Modified: 2012-05-02
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,
0
Comment
Question by:tiki1017
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 24

Accepted Solution

by:
johanntagle earned 500 total points
ID: 37799417
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
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question