Mysql Environment Variable

[zabidin5417]

Hi,

How to set variable for remote mysql? Mysql server is on linux and ip is 172.16.30.20. I want to install crystal report on server A and mysql is server B which ip is 172.16.30.20 and keep asking environment variable. Anyone knows how?

Thanks.

[atreyu]

Hi,

Perhaps you need to set the MYSQL_HOME variable, which points to your location of my.cnf, see an explanation here.

to set a variable, you can just do this in a terminal:

export MYSQL_HOME=/etc/my.cnf

The location of your my.cnf file might be different.

You can put this command in a login script for the current user, so it is automatically set at login. For example, you can use ~/.bashrc.