You should definintely check the link Ruslan mentions, and do a fair bit of
reading to get more comfortable with MySQL (not a bad idea in any event). Not
sure if you were quoting yourself verbatim, but if so, that command has several
issues with how you typed it. I'd bookmark the 5.* doc pages for your exact
version, and look up every command you want to type for syntax as you work.
The punctuation is not optional :).
________________________________
From: [email protected]
[mailto:[email protected]] On Behalf Of Vance Walsh
Sent: Thursday, May 12, 2011 3:04 PM
To: [email protected]
Cc: [email protected]
Subject: Re: [rt-users] Allowing remote access to RT mySQL
Ruslan,
Thanks for the response, I was more curious if there is anything
specific to how RT connects to MySQL that would not allow for me to setup
standard GRANT permissions to the DB I have tried the standard
GRANT ALL PRIVILEGES ON *.* TO [email protected] IDENTIFIED by
"Password"; and have not been able to connect remotely from this IP and
username to the DB
-Vance
---
Vance Walsh
Network and Systems Administrator
Concord Academy - Concord, Mass.