You should use a namespace prefix for your query parameter. If the component isn’t part of a managed package you should use c__ as prefix. So the button url would be /lightning/n/Cops_Rate_Profile_Tab?c__MDMID={!Account.Master_Customer_ID__c} and in the controller you should get c__MDMID. Please refer to the documentation about query parameters.

Only top voted, non community-wiki answers of a minimum length are eligible