Connecting to remote MySQL server using PHP

by
  • firewall of the server must be set-up to enable incomming connections on port 3306
  • you must have a user in MySQL who is allowed to connect from % (any host) (see manual for details)

The current problem is the first one, but right after you resolve it you will likely get the second one.

More Related Contents:

  1. Undefined function mysql_connect()
  2. mysql_connect VS mysql_pconnect [closed]
  3. If number have inside number string [closed]
  4. recurring system my sql query [closed]
  5. Php date() Date and time is stuck [closed]
  6. Cannot modify header information [duplicate]
  7. inserting information and image in php and mysql
  8. CodeIgniter – foreach loop
  9. Project Links do not work on Wamp Server
  10. PHP/MySQL insert row then get ‘id’
  11. Using Jquery Ajax to retrieve data from Mysql
  12. Laravel migration: unique key is too long, even if specified
  13. Laravel Eloquent select all rows with max created_at
  14. MySQL – count total number of rows in php
  15. Advantages Of MySQLi over MySQL [closed]
  16. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  17. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  18. What does a successful MySQL DELETE return? How to check if DELETE was successful?
  19. check if the query results empty row mysqli [duplicate]
  20. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  21. double results in my array ( mysql_fetch_array )
  22. How best to get someone’s ‘rank’ from a scores table with php and mysql without looping
  23. php:Store image into Mysql blob, Good or bad?
  24. How to get rid of MySQL error ‘Prepared statement needs to be re-prepared’
  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