Hello list,

I have a server Windows 2003 r2, with OTRS 3.0.4 and MySQL database, this server is for test and try some functionality about OTRS.

Today I want to install OTRS on another server to production, so I do this

1 On Test server

- Save the config.pm on a share folder

- Save MySQL database (mysqldump –uroot otrs > otrs_dump.sql) and save it on a share folder

- Save sysconfig by administration tools on OTRS, and copy it in share folder

2 on Production server (also windows 2003 r2)

- Install OTRS 3.0.4

- Don’t run the web installer after

- Create the database : mysql> create database otrs character set utf8;

- Allow privileges: mysql –uroot –e “grant all on otrs.* to ‘otrs@localhost’ identified by ‘test’” && mysql –uroot –e “flush privileges”

- Restore database: mysql –uroot otrs < otrs_dump.sql

- Copy the old config.pm (test server) to the production server

-

After I try to run OTRS to import my sysconfig and I have this error: Access denied for user 'otrs'@'localhost' (using password: YES)

I think it’s mismatch witch credential about MySQL root but I don’t know where I can see it? And I have a  about the user (otrs@localhost) in the grant MySQL command, because in the config.pm the user is otrs and password hot

Best regards

Sébastien  Bory