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 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-bounces@otrs.org [mailto:otrs-bounces@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' 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

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 wrote:

You could also try "grant all privileges on otrs.* to otrs@localhost;"

Michael

------------------------------ *From:* shrikant k *To:* User questions and discussions about OTRS. *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 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-bounces@otrs.org [mailto:otrs-bounces@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%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