Ideally this would be done via some css in your template styleshet, which leads me to the question - Are you wanting to apply the hover to all links, or just a particular one?

There are 2 ways to do this, although both will require you to add a css rule to your template stylesheet. The first would use a class for the css rule to target any link that has the class applied. So when you create or update the link, you add the Class in the Advanced tab of the link dialog. This would allow it to be used for any other link you create too. The css rule might look something like this:

a.link_hover:hover {
    color: red;
    text-decoration: underline;
}

When you create or update the link, you would then select the link_over Class in the Advanced tab. Alternatively, you can target this specific link with a css rule like this:

a[href="https://www.psychologytoday.com/intl/blog/what-mentally-strong-people-dont-do/201710/how-train-your-brain-think-differently"]:hover {
    color: red;
    text-decoration: underline;
}

You would not need to apply this to the link when you create it.