2 MYDBR with 2 MYSQL setup in the same linux box

(4 posts) (2 voices)

Tags:

No tags yet.

  1. chadwickhung, Member

    Hi all,
    I need help. I've 2 MYSQL instance running in the same linux box with port 3306 and 3307. I'm trying to install 2 copies of MYDBR too. However, even I've put 3307 in the DBR config file, it is still reading from the DB with port 3306.
    Any idea? Please help.

    Thanks
    Chadwick

  2. myDBR Team, Key Master

    Make sure you are connecting using TCP/IP instead of through a socket. When your connection is done using a socket, the TCP/IP port is ignored.

    By default in MySQL 'localhost' uses socket and a connection using 127.0.0.1 uses TCP/IP.

    --
    myDBR Team

  3. chadwickhung, Member

    Thanks a lot. It works!

    Unluckily, I hit another error at the last step of the setup:

    DB error (1267): Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
    SQL: call sp_MyDBR_GetOptions('',0);

    Any further advice for me please?

    Chadwick

  4. myDBR Team, Key Master

    You have a mismatch of the collations used in database vs the collations for your connections, i.e. your database configuration needs to be fixed. Make sure your use of collations is consistent. You can goole for "Illegal mix of collations" for more info.

    --
    myDBR Team


Reply

You must log in to post.