Using the MySQL client "Workbench" to connect to Xserver's MySQL and make things easier. I did exactly the same thing over a year ago, but for some reason I didn't take any notes, so I had to research everything from scratch before I could finally do it.
I'll only write down the minimum things that you wouldn't know without researching. For those who don't understand the basics, please refer to the references at the end.
First
Change Connection Method from Standard (TCP/IP) to Standard TCP/IP over SSH.
There's no way you'd know this without researching...
Specifying SSH Port
Xserver's port is not 22 but 10022, so you need to specify the port, but I didn't know how to specify it... If you read the English carefully, it was simple - you just need to add `:YOUR_PORT_NUM` to the hostname.
SSH Hostname: `[domain name].xsrv.jp:10022 e.g. mysql2007.xserver.jp:10022`
Other than that, it should be understandable if you're familiar with SSH or can log into MySQL.
References
[https://worktoolsmith.com/28452/](https://worktoolsmith.com/28452/)