Re: [otrs] Cant acess My Sql

22 Dec 2010

      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