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

 

Michael

---

From: shrikant k <shrikant.k1986@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 <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

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