Re: [otrs] How to access the MySQL!

Thanks Paul, I've tried. It only works locally. And the root password is empty. It seems I have to make some setup on MySQL so I can access it remotely. I installed SQL Manager Lite on the localhost, and then setup a root account with "%" (Global) access. Now I can access it remotely. Jack -----Original Message----- From: Paul Dale [mailto:paul.dale@gmail.com] Sent: 2008年11月9日 14:05 PM To: j.zhu@impactek.com Subject: Re: [otrs] How to access the MySQL! It's possible that you have to access it locally. It depends on how the user is set up (I'm not sure how otrs sets it up by default), mysql does have the ability to allow local and not remote. root with empty password is probably also only @ localhost, but I'm not sure about that either. paul 2008/11/9 Jie(Jack) Zhu :

Thanks for your prompt answer Paul,

I have phpmyadmin installed on another server. I tried to access OTRS's MySQL through it. I used empty password for root, and also tried user otrs. Both of them don't work. Do I have to access the database locally?

-----Original Message----- From: Paul Dale [mailto:paul.dale@gmail.com] Sent: 2008年11月9日 13:37 PM To: j.zhu@impactek.com; User questions and discussions about OTRS. Subject: Re: [otrs] How to access the MySQL!

I believe the default mysql root password is empty.

To access the database login to mysql and type use otrs; to switch to the otrs DB.

2008/11/9 Jie(Jack) Zhu :

...

Hi there,

I installed the OTRS win32 package. It created everything automatically including the MySQL.

The server is working fine. However, I am just wondering how can I access MySQL database?

What is the default password for root?

Thanks for your help!

Jack

_______________________________________________ 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