1) I found the problem on march 25
“port” field don’t work to connect to external database
When click on “Connect” The QUERY is :
object(wpdb)#11954 (59) { [“show_errors”]=> bool(false) [“suppress_errors”]=> bool(false) [“last_error”]=> string(0) “” [“num_queries”]=> int(0) [“num_rows”]=> int(0) [“rows_affected”]=> int(0) [“insert_id”]=> int(0) [“last_query”]=> NULL [“last_result”]=> NULL [“result”:protected]=> NULL [“col_meta”:protected]=> array(0) { } [“table_charset”:protected]=> array(0) { } [“check_current_query”:protected]=> bool(true) [“checking_collation”:”wpdb”:private]=> bool(false) [“col_info”:protected]=> NULL [“queries”]=> NULL [“reconnect_retries”:protected]=> int(5) [“prefix”]=> string(0) “” [“base_prefix”]=> NULL [“ready”]=> bool(false) [“blogid”]=> int(0) [“siteid”]=> int(0) [“tables”]=> array(10) { [0]=> string(5) “posts” [1]=> string(8) “comments” [2]=> string(5) “links” [3]=> string(7) “options” [4]=> string(8) “postmeta” [5]=> string(5) “terms” [6]=> string(13) “term_taxonomy” [7]=> string(18) “term_relationships” [8]=> string(8) “termmeta” [9]=> string(11) “commentmeta” } [“old_tables”]=> array(3) { [0]=> string(10) “categories” [1]=> string(8) “post2cat” [2]=> string(8) “link2cat” } [“global_tables”]=> array(2) { [0]=> string(5) “users” [1]=> string(8) “usermeta” } [“ms_global_tables”]=> array(7) { [0]=> string(5) “blogs” [1]=> string(7) “signups” [2]=> string(4) “site” [3]=> string(8) “sitemeta” [4]=> string(14) “sitecategories” [5]=> string(16) “registration_log” [6]=> string(13) “blog_versions” } [“comments”]=> NULL [“commentmeta”]=> NULL [“links”]=> NULL [“options”]=> NULL [“postmeta”]=> NULL [“posts”]=> NULL [“terms”]=> NULL [“term_relationships”]=> NULL [“term_taxonomy”]=> NULL [“termmeta”]=> NULL [“usermeta”]=> NULL [“users”]=> NULL [“blogs”]=> NULL [“blog_versions”]=> NULL [“registration_log”]=> NULL [“signups”]=> NULL [“site”]=> NULL [“sitecategories”]=> NULL [“sitemeta”]=> NULL [“field_types”]=> array(0) { } [“charset”]=> NULL [“collate”]=> NULL [“dbuser”:protected]=> string(12) “XXXXXXXXXXXXXXXX” [“dbpassword”:protected]=> string(10) “XXXXXXXXXXXXXXXX” [“dbname”:protected]=> string(8) “XXXXXXXXXXXXXXXX” [“dbhost”:protected]=> string(26) “XXXXXXXXXXXXXXXX” [“dbh”:protected]=> NULL [“func_call”]=> NULL [“is_mysql”]=> bool(true) [“incompatible_modes”:protected]=> array(5) { [0]=> string(12) “NO_ZERO_DATE” [1]=> string(18) “ONLY_FULL_GROUP_BY” [2]=> string(19) “STRICT_TRANS_TABLES” [3]=> string(17) “STRICT_ALL_TABLES” [4]=> string(11) “TRADITIONAL” } [“use_mysqli”:”wpdb”:private]=> bool(true) [“has_connected”:”wpdb”:private]=> bool(false) [“error”]=> object(WP_Error)#11955 (2) { [“errors”]=> array(1) { [“db_connect_fail”]=> array(1) { [0]=> string(913) ”
Theren’t “port” parameter.
2) Today, I found the workaround
Add the port in “host” field
Like : HOSTNAME:NUMBERNAME
For example : database.hostserver.net:33999
