Error establishing a database connection – using port 3309 for mysql

  • I am trying to set up WordPress using a mysql database on a different machine using a non-standard port (port 3309). Here is my connection information:

    // ** MySQL settings ** //
    define(‘DB_NAME’, ‘wordpress’);
    define(‘DB_USER’, ‘wordpress’);
    define(‘DB_PASSWORD’, ‘******’);
    define(‘DB_HOST’, ‘msidevsql:3309’);
    define(‘DB_CHARSET’, ‘utf8’);
    define(‘DB_COLLATE’, ”);

    I have used the same information to connect using SQLYog from the same machine wordpress is on.

    My error message is:
    ***************************************************
    Error establishing a database connection
    This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at msidevsql:3309. This could mean your host’s database server is down.

    Are you sure you have the correct username and password?
    Are you sure that you have typed the correct hostname?
    Are you sure that the database server is running?
    ***************************************************

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter jjolley

    (@jjolley)

    Got it! I had to use the OLD_PASSWORD Command

    SET PASSWORD FOR ‘wordpress’@’%’ = OLD_PASSWORD(‘****’);

    That took care of it.

    Thanks.

    THANKS!!
    I’ve got non-standard port for apache and I was getting the same error. I used OLD_PASSWORD trick and it works now.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Error establishing a database connection – using port 3309 for mysql’ is closed to new replies.