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