Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Please add support for --protocol=TCP #474

Closed
rnav1234 opened this issue Jan 28, 2020 · 3 comments
Closed

Please add support for --protocol=TCP #474

rnav1234 opened this issue Jan 28, 2020 · 3 comments

Comments

@rnav1234
Copy link

Some MySQL installations do not have socket files available for those --protocol=TCP is required. There seems to be no way to coax mysqltuner.pl into connecting in that case.
Workaround: With suitable permissions adding a socket file and then specifying --socket=/path/to/sock seems to work nicely.

@SamuelB-ACA
Copy link

temporarily, you can edit mysqltuner.pl and replace this line (+/- l756) :
$remotestring = " -h $opt{host} -P $opt{port} ";
with
$remotestring = " -h $opt{host} -P $opt{port} --protocol=tcp";

I'll try to do a PR

@jmrenouard
Copy link
Collaborator

Done !

@gggeek
Copy link
Contributor

gggeek commented Sep 13, 2022

FWIW, using an IP address instead of hostname always worked for me to force the mysql client to use TCP instead of pipes...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants