[SOLVED] Installation on remote mysql

[ruzzetto]

Hi all,
apologize if my post is already opened by someone else, but i try to install otrs on my test environment and i have mysql server already installed. Reading some posts i tried to modify Config.pm modify host parameter with the mysql IP address, but it seems the installer still check for a local DB....is there anything else i could do in order to fix?

Thanks a lot,
Fabio

[reneeb]

You can define the host in the installer...

See "host" in http://www.unixmen.com/wp-content/uploa ... ox_006.jpg

[ruzzetto]

@reeneb i tried but i got the same error...

[reneeb]

Which error message?

[ruzzetto]

otrs.PNG

in the "host" field i put mysql IP Address, while in the second line i covered there localhost hostname, where otrs is running.

thanks

[zzz]

Hello ruzzetto ,
your Host (server on which you're running OTRS) is probably not allowed to connect to your MySQL server.

Login to your MySQL server and try this:
CREATE USER 'root'@'IPADRESSOFYOURHOST' IDENTIFIED BY 'somepass';
grant all privileges on *.* to 'root'@'IPADRESSOFYOURHOST' with grant option;
flush privileges;

You should keep in mind that this could lead to a security issue and should be adjusted after the installation of OTRS.

Good luck

[ruzzetto]

it works! now i'm proceeding to install a then revoke grants!

thanks