MySQL question and RT

RT Users
1

I need to write some custom reports (depending on the value of a custom
field, how many requests are there, how much time was spent, etc).

I’d like to write these reports outside of RT (since my company is not
familiar with perl or Linux, it is best to have it in the familiar
environment).

I am trying to connect to the RT database, but I am getting a message
"#ip address of my computer# is not allowed to connect to this MySQL server"

Could someone point me in the right direct to give my computer access? I am
guessing that there is a permissions file somewhere where I need to add
permissions, but I am not finding it.

Thanks!
Brett

2

I am trying to connect to the RT database, but I am getting a message
“#ip address of my computer# is not allowed to connect to this MySQL server”

Could someone point me in the right direct to give my computer access? I am
guessing that there is a permissions file somewhere where I need to add
permissions, but I am not finding it.

This is really OT. http://dev.mysql.com/doc/mysql/en/index.html,
especially section 5.4.

Michael
Michael S. Liebman m-liebman@northwestern.edu
http://msl521.freeshell.org/
“I have vision and the rest of the world wears bifocals.”
-Paul Newman in “Butch Cassidy & the Sundance Kid”

3

Brett Barnhart wrote:

I need to write some custom reports (depending on the value of a custom
field, how many requests are there, how much time was spent, etc).

I’d like to write these reports outside of RT (since my company is not
familiar with perl or Linux, it is best to have it in the familiar
environment).

I am trying to connect to the RT database, but I am getting a message
“#ip address of my computer# is not allowed to connect to this MySQL server”
You should read about administrating MySQL server. Your IP isn’t granted
with required rights to access this server.

Please read mysql manual.