PDO<\/strong> to connect to MySQL.<\/li>\n<\/ul>How to fix it<\/h2>
You need to locate the file in your website’s code that handles the database connection. This is typically named “config.php”, “db.php”, “connect.php”, “database.php”, or similar.<\/p>
Option 1 – If your site uses mysqli<\/h3>
Find the line that looks like this:<\/p>
mysqli_connect(\"localhost\", $user, $pass, $db);<\/pre>Change “localhost” to “p:localhost”:<\/p>
mysqli_connect(\"p:<\/strong>localhost\", $user, $pass, $db);<\/pre>The “p:” prefix tells PHP to use a persistent connection, keeping it open across requests instead of creating a new one each time.<\/p>
Option 2 – If your site uses PDO<\/h3>
Find the line that looks like this:<\/p>
new PDO(\"mysql:host=localhost;dbname=$db\", $user, $pass);<\/pre>Add “[PDO::ATTR_PERSISTENT => true]” as a fourth argument:<\/p>
new PDO(\"mysql:host=localhost;dbname=$db\", $user, $pass, [PDO::ATTR_PERSISTENT => true]<\/strong>);<\/pre>Save the file and reload your website.<\/p>
Conclusion<\/h3>
After making this change, your website will reuse the existing MySQL connection instead of opening a new one on every request. This keeps your connection count within Hostinger’s rate limits and resolves the “Operation not permitted” error. Your database credentials and all other settings remain unchanged.<\/p>
<\/p>
\n
Notes:<\/strong><\/p>\n\n- This fix does not require any changes to your database credentials or database name.<\/li>\n
- If you are using a CMS such as WordPress, Joomla, or a framework with its own database abstraction layer, the connection file location may differ. Check your CMS documentation for how to enable persistent database connections.<\/li>\n
- If the error persists after applying the fix, contact Hostinger support for further assistance.<\/li>\n<\/ul>\n<\/div>
<\/p>\n","protected":false},"excerpt":{"rendered":"
If your website is showing a database connection error such as: PHP Fatal error: Uncaught mysqli_sql_exception: Operation not permitted Connection failed: Operation not permitted ERROR:…<\/p>\n","protected":false},"author":599,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[160],"tags":[],"class_list":["post-11068","post","type-post","status-publish","format-standard","hentry","category-mysql-databases"],"hreflangs":[],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/11068","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/users\/599"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/comments?post=11068"}],"version-history":[{"count":10,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/11068\/revisions"}],"predecessor-version":[{"id":11078,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/11068\/revisions\/11078"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=11068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=11068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=11068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}