[rt-users] Allowing remote access to RT mySQL
So this may seem rudimentary but I am not a solid SQL tech. My Boss would like to make remote ODBC connections to RT's DB. Is there a set of instructions I can review to set this up for him? Thanks in advance -Vance --- Vance Walsh Network and Systems Administrator Concord Academy - Concord, Mass.
Re: [rt-users] Allowing remote access to RT mySQL
Hi, On Thu, May 12, 2011 at 10:43 PM, Vance Walsh vance_wa...@concordacademy.org wrote: So this may seem rudimentary but I am not a solid SQL tech. My Boss would like to make remote ODBC connections to RT's DB. Is there a set of instructions I can review to set this up for him? It's incorrect list for this question. Start from http://dev.mysql.com/doc/refman/5.1/en/connector-odbc.html. Thanks in advance -Vance --- Vance Walsh Network and Systems Administrator Concord Academy - Concord, Mass. -- Best regards, Ruslan.
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 vwalsh@10.2.8.17 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.
Re: [rt-users] Allowing remote access to RT mySQL
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: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Vance Walsh Sent: Thursday, May 12, 2011 3:04 PM To: r...@bestpractical.com Cc: rt-users@lists.bestpractical.com 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 vwalsh@10.2.8.17 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.
Re: [rt-users] Allowing remote access to RT mySQL
Hi, Nothing RT specific. mysql by default may be configured without listening network. You may have firewall that blocks connections. Start from telnet or mysql client on anther machine. On Thu, May 12, 2011 at 11:03 PM, Vance Walsh vance_wa...@concordacademy.org wrote: 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 vwalsh@10.2.8.17 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. -- Best regards, Ruslan.