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