• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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