Find the answer to your Linux question:
Results 1 to 2 of 2
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Nov 2012
    Posts
    24

    Mysql Environment Variable


    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.
    Attached Images Attached Images

  2. #2
    Trusted Penguin
    Join Date
    May 2011
    Posts
    4,307
    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:
    Code:
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •