• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

MySQL databases with test_ prefix are world writable.

Tozz

Regular Pleskian
There is a security issue in the default MySQL configuration, which can cause leaking of MySQL data with certain databases names.

In MySQL's authentication tables there is a row which allows all users access to all databases that start with "_test". Thus, any user that creates eg. test_joomla or test_wordpress can be seen, read and written by any other user. If any other user logs in into MySQL they can see the test_ databases.

I feel this is a security issue, and Plesk should either remove the default entry in MySQL's 'db' table, or Plesk should prohibit creating databases that start with "test_".

This entry can be removed by running:
Code:
use mysql;
delete from db where Db = 'test\_%'; 
flush privileges;
 
Tozz,

Could you provide more details? MySQL version, OS, arch and etc. I can not reproduce your problem.
 
Back
Top