Connect DATABASE Error TYPE: 2002: Permission denied

by

I had the same issue after getting a new CentOS 7 box, running SELinux. I could connect to my remote MySQL DB server from the command line, but Drupal (and test PHP scripts) could not.

The issue turned out to be the SELinux security policies.

By default, the policy httpd_can_network_connect_db is disabled (meaning that your web server cannot contact a remote DB.)

Check this via:

getsebool -a | grep httpd

If httpd_can_network_connect_db is Off, enable it via:

setsebool -P httpd_can_network_connect_db 1

(The -P flag makes the change permanent, so the setting survives a reboot.)

More Related Contents:

  1. Im trying to create some temporary tables in mysql using php
  2. the update query just update the last row and affect other with it’s value
  3. How to insert images into a database using PHP [closed]
  4. How to apply bindValue method in LIMIT clause?
  5. How to change mysql to mysqli?
  6. Importing CSV data using PHP/MySQL
  7. Convert latin1 characters on a UTF8 table into UTF8
  8. mysql_fetch_array() expects parameter 1 to be resource problem [duplicate]
  9. PDO multiple queries
  10. Using strtotime for dates before 1970
  11. Get Element by ClassName with DOMdocument() Method
  12. Turn database result into array
  13. Update query with PDO and MySQL
  14. (mysql, php) How to get auto_increment field value before inserting data?
  15. Trying to get property of non-object – CodeIgniter
  16. return one value from database with mysql php pdo
  17. Trying to access array offset on value of type bool
  18. onbeforeprint() and onafterprint() equivalent for non IE browsers
  19. How to get a query error from prepare() in PDO PHP?
  20. How can I pass an array of PDO parameters yet still specify their types?
  21. Fatal error: Call to a member function query() on null
  22. MySQL & PHP Parameter 1 as Resource
  23. MySQL GROUP BY and Fill Empty Rows
  24. mysql injection damages?
  25. Using utf8mb4 with php and mysql
  26. how do I get month from date in mysql
  27. Strange problem with the length of the field gotten from database [duplicate]
  28. Can I detect and handle MySQL Warnings with PHP?
  29. How to write a stored procedure in phpMyAdmin?
  30. mysql count into PHP variable

Leave a Comment