Solved

MySql for Sysaid

Posted on 2012-04-02
1
674 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
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
join tables 4 56
Mysql sync between 3-4 mysql db 4 42
updating table data with inner join 9 46
Mysql Left Join Case 10 70
Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

827 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