• Resolved gary4gar

    (@gary4gar)


    Hello everyone,
    I am trying to connect to a remote mysql database which is tunneled on my machine(localhost). I use the following parameters to connect to it

    $ mysql --protocol=TCP -P 10000 -h localhost -u username -p'password' db_name
    
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 93438893
    Server version: 5.5.8-log Source distribution
    
    Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> show databases;
    +-----------------------------------+
    | Database                          |
    +-----------------------------------+
    | information_schema                |
    | db_name                           |
    +-----------------------------------+
    2 rows in set (1.38 sec)

    as you notice the above connection works just like normal connection except it take the following extra parameters:

    Port = 10000
    Protocol = TCP
    Host = localhost

    I was wondering how do i set the the above in wp-config.php, so wordpress can connect to the remote database just like mysql CLI client was able to.

    Let me know, if anyone has any ideas. Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘WordPress database connection issue, force TCP over localhost’ is closed to new replies.