MySQL Forums
Forum List  »  Newbie

Having trouble Connecting to multiple instances on remote server
Posted by: Chris Isaksen
Date: March 21, 2013 11:49AM

I'm very new to mysql.

I have successfully installed mysql 5.6.10 on SUSE 11.2 and configured it to run multiple instances using the mysqld_multi setup. (my.cnf in /etc)

I have configured 3 instances each with their own port and socket files. All start up normally and using the configured files from /etc/my.cnf.

The problem I'm having is connecting to the individual instances just using the port number. It keeps wanting the default socket file that I'm not using. In the case of SUSE -->(/var/lib/mysql/mysql.sock). It works if I specify the --socket option when on the local server but this doesn’t help when trying to connect to it remotely.

I'm not sure what I'm doing wrong. Any help would be greatly appreciated.

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Having trouble Connecting to multiple instances on remote server
March 21, 2013 11:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.