Re: [otrs] Access to the MYSQL database

Just read the mysql documentation on user management and that should be all you need. I wouldn't use the otrs account, rather create a select only user for querying the database as it sounds like you don't have all that much experience in this realm - it will keep you from doing anything rash to the database other than causing performance issues stemming from bad queries. http://www.google.com/search?q=mysql+user+management HTH, Andy Lubel On 3/13/07 9:33 PM, "Salvador Manzo" wrote:

You provided them on install, I think. The defaults are included in the basic documentation as I recall (it's the ROOT account listed in the docs.)

On 3/13/07 18:03, "Getchell, Adam" wrote:

...

Hello,

I'm looking to directly connect to the OTRS database (with Aquadata Studio), so I can run some reports not in the system.

Before I do that, I have to allow my host to connect to MySQL.

Before I do that, I have to be able to login to the OTRS database (with MySQL Administrator) to set the permissions.

So -- where do I find the username/password info?

I've been looking at the OTRS 2.0 Administrator manual, but I haven't found where this is documented.

Thanks,

*************** * Adam Getchell, M.S. * Director of Information Technology * College of Agricultural & Environmental Sciences * acgetchell@ucdavis.edu (530)752-8008 *************** "Invincibility is in oneself, vulnerability in the opponent." -- Sun Tzu

----- Salvador Manzo [ 620 W. 35th St € Los Angeles, CA 90089 e. manzo@usc.edu ] Auxiliary Services IT, Datacenter University of Southern California 818-612-5112 Discourage self-help, and loyal subjects become the slaves of ruffians. Over-stimulate self-assertion, and for the arbitrament of the Courts you substitute the decision of the sword or the revolver. - The Law of the Constitution, by A.V. Dicey (MacMillan, London 1885).

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? => http://www.otrs.com/

--