Should I disallow root login remotely? (Setting up mySQL )

1

I was following this guide :

And during the set up process I need to choose: do I allow remote log in using root,
should I choose no?

If I do choose no, how do I log in to SQL server remotely?>

Using SSL?

2

you should definitely not allow remote root login

I believe you can create another user with remote login and that can use ‘su’ to get root access

info about sudo/su
https://www.beyondtrust.com/blog/unix-linux-privileged-management-should-you-sudo-heres-what-it-does-and-why-its-not-enough/

2 Likes
3

thanks for the heads up!
1st time doing this kind of thing.