Resolved Allow local MySQL server check is gone after restart MySQL

[Dumitru]

If
Allow local MySQL server to accept external connections
is check

and
I restart MySQL form SSH
Service MySQL restart

The check is gone and no one can connect remote to the database

You need to check it again and save every time if you restart MySQL form SSH

 

[Bitpalast]

Could you please take a look at /etc/my.cnf and check whether the bind-address parameter is set to either 0.0.0.0 or :: like in

[mysqld]
bind-address = ::

If not, please add the line to the [mysqld] section, then restart the database server to have a persistent setting.

 

[Dumitru]

Now si
[mysqld]
bind-address = ::ffff:127.0.0.1
local-infile=0

 

[Bitpalast]

The parameter "bind-address" must be set to either 0.0.0.0 or ::
Example how it needs to look:

[mysqld]
bind-address = ::

Then restart the database server to have it persistently allow external connections.

 

[Dumitru]

Is working, tnx!