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' 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
