Enable remote connection with DB

[gdennye]

[gdennye]

I would like connect with remote DB.

[BMDan]

And, having tried to do so, does it work? Notwithstanding the fact that the script will make some incorrect assumptions (e.g. the amount of total RAM available to the DB), there's nothing in the script to stop you from using it against a remote host.

[martinm82]

I looked into the script and out of the box it does not support remote connections to a database. In my case I would like to run the script against an AWS RDS instance on which one does not have access via for example SSH. So running it locally is not an option.

[mickaelstrg]

Just as a note, while not pretty, you can also use socat to make this work (and then override the default socket path when running the script): socat UNIX-LISTEN:/tmp/mysql.sock,fork TCP:X.X.X.X:3306

Then execute the script:

> ./tuning-primer.sh

Using login values from ~/.my.cnf
- INITIAL LOGIN ATTEMPT FAILED -
Testing for stored webmin passwords:
 None Found
Could not auto detect login info!
Found potential sockets: /tmp/mysql.sock
  Will use client's default socket (this is normally correct).
Would you like to override my socket choice?: [y/N] y
Socket: /tmp/mysql.sock
Do you have your login handy ? [y/N] : y
[...]

This just works. Maybe worth adding to the README?