Results 1 to 4 of 4

Thread: How to change MySQL ip address to make it reachable from LAN

  1. #1
    alex.voicu is offline Starter Member
    Join Date
    May 2014
    Posts
    2
    Rep Power
    1

    Default How to change MySQL ip address to make it reachable from LAN

    Hi all,
    I have a question: how can i change MySQL address to make it reachable from internal LAN so i can use it for other databases without install another instance.
    In my.cnf i have this line:
    bind-address = 127.0.0.1 which put MySQL to run only the localhost.
    If i changed the line to something like that:
    bind-address = 0.0.0.0
    MySQL start but i can't send and receive any mails.
    I want to have on the internal LAN interface so i can connect with MySQL connector or with MySQL Workbench and administer.

    Thanks a lot for your suport.
    Alex.

  2. #2
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,506
    Rep Power
    57

    Default

    Quote Originally Posted by alex.voicu View Post
    I have a question: how can i change MySQL address to make it reachable from internal LAN so i can use it for other databases without install another instance.
    You do not use the Zimbra MySQL instance for any other function, you may break you Zimbra server or impact it's performance.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    alex.voicu is offline Starter Member
    Join Date
    May 2014
    Posts
    2
    Rep Power
    1

    Default

    Quote Originally Posted by phoenix View Post
    You do not use the Zimbra MySQL instance for any other function, you may break you Zimbra server or impact it's performance.
    Hi and thanks for your response.
    I already used the MySQL from Zimbra server to host my website database and i do not see any degradation of Zimbra server performance.
    I've added a dedicated user for every databases and of course i'm not modified anything regarding Zimbra server databases.
    My only problem is how to connect from LAN to MySQL server, since i've changed the default ip address i cannot send and receive emails. As i said before i changed the 127.0.0.1 ip addres with 0.0.0.0 to bind the servers to all network addresses, but without a positive results since i broken the email functionality.
    After i revert the address to default everything works normally again.

    Best regards,
    Alex

  4. #4
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,506
    Rep Power
    57

    Default

    Quote Originally Posted by alex.voicu View Post
    I already used the MySQL from Zimbra server to host my website database and i do not see any degradation of Zimbra server performance.
    That doesn't alter the fact that you shouldn't be doing it and you may also lose any non-Zimbra information in the database during an upgrade - again, I'd suggest you don't do it.
    Last edited by phoenix; 05-06-2014 at 12:40 PM.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to make class of service change take effect
    By davidkillingsworth in forum Administrators
    Replies: 1
    Last Post: 02-14-2012, 09:50 AM
  2. How to make entries in the global address book?
    By jannik.sueltz in forum Administrators
    Replies: 48
    Last Post: 11-05-2009, 05:57 PM
  3. how to make zimlet change into effictive quickly?
    By jason719 in forum Developers
    Replies: 5
    Last Post: 08-28-2009, 04:28 AM
  4. [SOLVED] How to make ZCS connect other mysql server?
    By king3382 in forum Installation
    Replies: 4
    Last Post: 01-18-2009, 05:57 PM
  5. Replies: 7
    Last Post: 10-09-2008, 08:06 AM

Posting Permissions

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