How do I allow remote MySQL connections on the root user?

Question

I want to allow remote MySQL connections so that any IP can log in as the root user. How would I go about doing this?

Because you want to expose your database to any IP address as root. There should be only set of allowed IPs. — Jsowa, Jun 24 '20 at 04:50
But if there's a strong password they won't be able to connect anyway — Obi-Wan-Kenobi, Jun 24 '20 at 04:52
Okay but they can just steal the password for the other user too — Obi-Wan-Kenobi, Jun 24 '20 at 06:29
That's why cyber security doesn't rely only on the passwords. Explain in answer more about your problem and you will get better answer. — Jsowa, Jun 24 '20 at 06:37
Please visit this quesions https://stackoverflow.com/questions/42862058/how-to-set-mysql-grant-to-allow-external-connection-to-mysql — Stathis Alexopoulos, Jun 24 '20 at 06:48

score 0 · Answer 1 · answered Jun 24 '20 at 04:41

0

Try it:

use mysql;

update user set host='%' where host='localhost'

answered Jun 24 '20 at 04:41

4

While this code may resolve the OP's issue, it is best to include an explanation as to how your code addresses the OP's issue. In this way, future visitors can learn from your post, and apply it to their own code. SO is not a coding service, but a resource for knowledge. Also, high quality, complete answers are more likely to be upvoted. These features, along with the requirement that all posts are self-contained, are some of the strengths of SO as a platform, that differentiates it from forums. You can edit to add additional info &/or to supplement your explanations with source documentation. – ysf Jun 24 '20 at 08:25

1 Answers1