<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/1999/xhtml"><HEAD><TITLE></TITLE>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<STYLE type=text/css>BODY {
MARGIN: 10px
}
</STYLE>
<META name=GENERATOR content="MSHTML 8.00.6001.19046"></HEAD>
<BODY marginbottom="10" margintop="10" marginright="10" marginleft="10">
<DIV dir=ltr align=left><SPAN class=368321419-12052011>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 :).</SPAN></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <B>On Behalf Of </B>Vance
Walsh<BR><B>Sent:</B> Thursday, May 12, 2011 3:04 PM<BR><B>To:</B>
ruz@bestpractical.com<BR><B>Cc:</B>
rt-users@lists.bestpractical.com<BR><B>Subject:</B> Re: [rt-users] Allowing
remote access to RT mySQL<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt" size=+0
face=Arial>Ruslan, </FONT></DIV><BR>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt" size=+0
face=Arial>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
</FONT></DIV><BR>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt" color=#000000
size=+0 face=Arial>GRANT ALL PRIVILEGES ON *.* TO <A
href="mailto:vwalsh@10.2.8.17">vwalsh@10.2.8.17</A> IDENTIFIED by
"Password"; and have not been able to connect remotely from this IP and
username to the DB</FONT></DIV><BR>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt" color=#000000
size=+0 face=Arial>-Vance</FONT></DIV><BR><BR>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt" color=#000000
size=+0 face=Arial>---</FONT></DIV><BR>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt" color=#000000
size=+0 face=Arial>Vance Walsh</FONT></DIV>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt" color=#000000
size=+0 face=Arial>Network and Systems Administrator</FONT></DIV>
<DIV style="TEXT-ALIGN: left" align=left><FONT
style="FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt" color=#000000
size=+0 face=Arial>Concord Academy - Concord,
Mass.</FONT></DIV><BR></BLOCKQUOTE></BODY></HTML>