delete remote mysql host 192.168.1.%

[tata13]

Hi

In cPanel -> database -> Remote MySql

Host 192.168.1.% always add automatically , even after i delete from cpanel and phpmyadmin in database mysql table host and db .

Is there any setting to disabled host 192.168.1.% added to remote mysql host automatically

Thanks

[peterr]

This should be logged as a bug, it is a PITA. Every time I remove the remote access via Cpanel, it re-appears again.

[cPanelGregK]

Greetings,

Per the MySQL documentation, there are safeguards built-in to ensure that remote hosts are unable to access MySQL with hostnames that start with a digit or dot.

MySQL :: MySQL 5.1 Reference Manual :: 5.4.3 Specifying Account Names

Because you can use IP wildcard values in host values (for example, '192.168.1.%' to match every host on a subnet), someone could try to exploit this capability by naming a host 192.168.1.somewhere.com. To foil such attempts, MySQL disallows matching on host names that start with digits and a dot. Thus, if you have a host named something like 1.2.example.com, its name never matches the host part of account names. An IP wildcard value can match only IP numbers, not host names.