Hello, Guys i tried grant acess and i got acess to database thanks a lot for ur help guys i am trying use my own custum templates. and i updated in my themes in database, lets if it works or not
thanks a lot guys shrikant On Wed, Dec 22, 2010 at 11:49 AM, Michael Mayaka <mikemay...@yahoo.co.uk>wrote: > You could also try "grant all privileges on otrs.* to o...@localhost;" > > Michael > > ------------------------------ > *From:* shrikant k <shrikant.k1...@gmail.com> > *To:* User questions and discussions about OTRS. <otrs@otrs.org> > *Sent:* Wed, 22 December, 2010 8:45:58 > *Subject:* Re: [otrs] Cant acess My Sql > > hey Lars > > check this config.pm file of mine > # ---------------------------------------------------- # > # database settings # > # ---------------------------------------------------- # > # DatabaseHost > # (The database host.) > $Self->{'DatabaseHost'} = 'localhost'; > # Database > # (The database name.) > $Self->{'Database'} = 'otrs'; > # DatabaseUser > # (The database user.) > $Self->{'DatabaseUser'} = 'otrs'; > # DatabasePw > # (The password of database user. You also can use bin/CryptPassword.pl > # for crypted passwords.) > $Self->{'DatabasePw'} = 'otrs'; > # DatabaseDSN > # (The database DSN for MySQL ==> more: "man DBD::mysql") > $Self->{DatabaseDSN} = > "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};"; > > The only thing i didnt mention is during the time of instation i have not > set a password for root user. > IS this could be a reason if so how can i overcome it. > > thanks > Shrikant. > On Tue, Dec 21, 2010 at 8:12 PM, Lars Jørgensen <i...@gyldendal.dk> wrote: > >> Hi Shikant >> >> >> >> Check out Kernel/Config.pm. There should be a section on connecting to the >> database. The username is missing. >> >> >> >> >> >> Lars >> >> >> >> *From:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *On Behalf >> Of *shrikant k >> *Sent:* Tuesday, December 21, 2010 12:15 PM >> *To:* otrs@otrs.org >> *Subject:* [otrs] Cant acess My Sql >> >> >> >> hello >> >> >> >> I have instaleed otrs on windows and i am facing problem i accessing my >> database as it shows an error when i do use otrs locally >> >> >> >> Error is :ERROR 1044 (42000): Access denied for user >> ''@'localhost'<%27...@%27localhost%27>to database 'otrs' >> >> >> >> i had run script checkdb.pl and it shows its ok >> >> >> >> any help as how can i acess by DB. >> >> >> >> shrikant >> >> --------------------------------------------------------------------- >> 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 >
--------------------------------------------------------------------- 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