Connecting to an SSH Database

  • Jacob

    (@woodyj13)


    12 years, 2 months ago

    I am connecting to a database hosted on a school server. When connecting to the MYSQL database, there are two levels of authentication.

    For example, when connecting using MYSQL workbench, I need to use the TCP/IP over SSH option and supply my school username and password, as well as the database username and password.

    I am unable to establish a DB connection to WordPress. I’m assuming SSH is the problem. How can I configure wp-config.php with both levels of authentication?

    Thank you,

    Jake

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    12 years, 2 months ago

    It’s not something that can be or should be done within WordPress because you need the database to be working before WordPress does anything.

    Anything like run code to handle the SSH tunnel. 😉

    Give these a read about establishing TCP port forwarding via SSH to a Mysql server.

    http://www.whoopis.com/howtos/mysql_ssh_howto.html
    http://www.howtogeek.com/howto/ubuntu/access-your-mysql-server-remotely-over-ssh/

    It’s not really a good solution because the ssh tunnel is not survivable, meaning that if it goes down it won’t come back up again. Running your own localhost Mysql database would be easier to maintain.

    Thread Starter Jacob

    (@woodyj13)

    12 years, 2 months ago

    The database is up and running. I am able to connect using MYSQL workbench. I have configured the wp-config.php file to the best of my knowledge, however I am still unable to get wordpress to connect to the Database.

    When using MYSQL workbench to connect, I need to supply an SSH hostname, username and password as well as a MySQL hostname, server port, username, and password.

    Is it possible that these extra credentials due to SSH is preventing wordpress from connecting to my database?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Connecting to an SSH Database’ is closed to new replies.