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:[EMAIL PROTECTED] Sent: 2008年11月9日 14:05 PM To: [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>: > 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:[EMAIL PROTECTED] > Sent: 2008年11月9日 13:37 PM > To: [EMAIL PROTECTED]; 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 <[EMAIL PROTECTED]>: >> 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 >> > > _______________________________________________ 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
