MySQL Bad Handshake to MySQL Cluster behind ProxyMySQL cluster questionWebserver: chrooted PHP gives mysql.sock error when attempting to reach mysqlMySQL Cluster ndb_mgmd errorconfiguring mysql cluster serverMySQL cluster for Drupal?Compare between MYSQL cluster and MYSQL serverMySQL replication or MySQL cluster?MySQL: Why would I have to repeatedly FLUSH HOSTS after a few minutes?HAProxy load balancing issuePHP 7.2.8 PDO Fails to Connect to MySQL 8.0.12 (GA) in AWS EC2 LEMP Stack
Overlapping String-Blocks
Getting UPS Power from One Room to Another
Russian word for a male zebra
Second (easy access) account in case my bank screws up
Wooden cooking layout
Writing an augmented sixth chord on the flattened supertonic
Interval of parallel 5ths in the resolution of a German 6th chord
What is the maximum number of net attacks that one can make in a round?
Can I use G instead of GG (short for days) if I am out of space?
Why am I getting a strange double quote (“) in Open Office instead of the ordinary one (")?
Who won a Game of Bar Dice?
How to hide rifle during medieval town entrance inspection?
Why can I traceroute to this IP address, but not ping?
Does the Long March-11 increase its thrust after clearing the launch tower?
English word for "product of tinkering"
How did old MS-DOS games utilize various graphic cards?
Live action TV show where High school Kids go into the virtual world and have to clear levels
What ways have you found to get edits from non-LaTeX users?
How come the nude protesters were not arrested?
Is it expected that a reader will skip parts of what you write?
Does Disney no longer produce hand-drawn cartoon films?
Why does Sin[b-a] simplify to -Sin[a-b]?
Are there any important biographies of nobodies?
What to do when surprise and a high initiative roll conflict with the narrative?
MySQL Bad Handshake to MySQL Cluster behind Proxy
MySQL cluster questionWebserver: chrooted PHP gives mysql.sock error when attempting to reach mysqlMySQL Cluster ndb_mgmd errorconfiguring mysql cluster serverMySQL cluster for Drupal?Compare between MYSQL cluster and MYSQL serverMySQL replication or MySQL cluster?MySQL: Why would I have to repeatedly FLUSH HOSTS after a few minutes?HAProxy load balancing issuePHP 7.2.8 PDO Fails to Connect to MySQL 8.0.12 (GA) in AWS EC2 LEMP Stack
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have just set up a MySQL cluster using five hyperV linux boxes (2x management nodes, 2 data nodes and 1 proxy) having followed (with a bit of tweaking) the instructions here. Everything works fine superficially, I can connect via the proxy to the data, from a MySQL command line on an Ubuntu box without issue, however when I try and connect to the proxy from windows (8.1) using SQLYog or Workbench I get an error no: 1043 - Bad Handshake. I can however, connect directly to the data nodes via workbench/SQLYog?
Is this a common problem, am i missing something obvious? the various OS/MySQL versions are shown below:
MySQLCluster: 7.4.5
MySQL Proxy: amd64/trusty 0.8.1-1.1build1
Ubuntu: 14.04.1 LTS (all boxes, including test from MySQL client)
linux mysql load-balancing connection mysql-cluster
add a comment |
I have just set up a MySQL cluster using five hyperV linux boxes (2x management nodes, 2 data nodes and 1 proxy) having followed (with a bit of tweaking) the instructions here. Everything works fine superficially, I can connect via the proxy to the data, from a MySQL command line on an Ubuntu box without issue, however when I try and connect to the proxy from windows (8.1) using SQLYog or Workbench I get an error no: 1043 - Bad Handshake. I can however, connect directly to the data nodes via workbench/SQLYog?
Is this a common problem, am i missing something obvious? the various OS/MySQL versions are shown below:
MySQLCluster: 7.4.5
MySQL Proxy: amd64/trusty 0.8.1-1.1build1
Ubuntu: 14.04.1 LTS (all boxes, including test from MySQL client)
linux mysql load-balancing connection mysql-cluster
add a comment |
I have just set up a MySQL cluster using five hyperV linux boxes (2x management nodes, 2 data nodes and 1 proxy) having followed (with a bit of tweaking) the instructions here. Everything works fine superficially, I can connect via the proxy to the data, from a MySQL command line on an Ubuntu box without issue, however when I try and connect to the proxy from windows (8.1) using SQLYog or Workbench I get an error no: 1043 - Bad Handshake. I can however, connect directly to the data nodes via workbench/SQLYog?
Is this a common problem, am i missing something obvious? the various OS/MySQL versions are shown below:
MySQLCluster: 7.4.5
MySQL Proxy: amd64/trusty 0.8.1-1.1build1
Ubuntu: 14.04.1 LTS (all boxes, including test from MySQL client)
linux mysql load-balancing connection mysql-cluster
I have just set up a MySQL cluster using five hyperV linux boxes (2x management nodes, 2 data nodes and 1 proxy) having followed (with a bit of tweaking) the instructions here. Everything works fine superficially, I can connect via the proxy to the data, from a MySQL command line on an Ubuntu box without issue, however when I try and connect to the proxy from windows (8.1) using SQLYog or Workbench I get an error no: 1043 - Bad Handshake. I can however, connect directly to the data nodes via workbench/SQLYog?
Is this a common problem, am i missing something obvious? the various OS/MySQL versions are shown below:
MySQLCluster: 7.4.5
MySQL Proxy: amd64/trusty 0.8.1-1.1build1
Ubuntu: 14.04.1 LTS (all boxes, including test from MySQL client)
linux mysql load-balancing connection mysql-cluster
linux mysql load-balancing connection mysql-cluster
asked Apr 9 '15 at 13:54
PaulPaul
11
11
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
It Looks like the aptitude version is several versions behind (A colleague pointed it out), Having downloaded and installed the tar from the MySQL site, all is working happily.
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f681559%2fmysql-bad-handshake-to-mysql-cluster-behind-proxy%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
It Looks like the aptitude version is several versions behind (A colleague pointed it out), Having downloaded and installed the tar from the MySQL site, all is working happily.
add a comment |
It Looks like the aptitude version is several versions behind (A colleague pointed it out), Having downloaded and installed the tar from the MySQL site, all is working happily.
add a comment |
It Looks like the aptitude version is several versions behind (A colleague pointed it out), Having downloaded and installed the tar from the MySQL site, all is working happily.
It Looks like the aptitude version is several versions behind (A colleague pointed it out), Having downloaded and installed the tar from the MySQL site, all is working happily.
answered Apr 9 '15 at 14:42
PaulPaul
11
11
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f681559%2fmysql-bad-handshake-to-mysql-cluster-behind-proxy%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown