MySql security recommendations

Recently, the company's Mysql database is often attacked. For some special reasons, it is impossible to take Mysql database into full Intranet environment and only provide some protection measures for Mysql. I have studied some common Mysql attack methods and proposed the following methods to provide Mysql security. This post will serve as a reference for you.

• Do not use the default mysql Port
• Use a complex password
• Disable remote connection of Root users
• Create permissions granted to users

So let's see how we do it.

Create a database user. For example, a Reson is created.

Grant related Permissions