Error while installing WordPress on a MySQL Server using custom port number

  • AnassL

    (@anassl)


    10 years, 8 months ago

    I am using MySQL Workbench to manage MySQL server, and currently I am able to connect to the databases using the root username and password on a custom port number, (the unique thing I’ve changed recently is the port number).
    Let’s say the new port number is 3366 (instead of 3306), the server is ‘localhost’, and the username is ‘root’, after a service restart, the server is still working and I could get to the connections successfuly.
    Now, using the Web Platform Installer (Windows), I wanted to install a new WordPress website, but when arrived to the step of providing the root password, the wizard returns an error: “The specified password for the user account ‘root’ is not valid, or failed to connect to the database server”
    The provided password is the same used by Workbench to connect successfuly to MySQL.
    any thoughts, please ?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Digico Paris

    (@digico-paris)

    10 years, 7 months ago

    Hello,

    Might be you didn’t changed each “wp-config.php” file for each setup. Each database should also run with the right settings for “base url” and port (different for each WP setup).

    On Windows, and if you use IIS, please make sure IIS accept that range of ports (your 2 ports then, for example 3206 for wp1 and 3207 for wp2).

    It’s not a problem to have same password for MYSQL, even accessing same database from 2 WP setups.

    But same port for 2 setups will bug, I think.

    I hope it helps,

    Jackiezhan

    (@jackiezhan)

    10 years, 7 months ago

    Remove “wp-config.php” file then install mysql

    Digico Paris

    (@digico-paris)

    10 years, 7 months ago

    I would add if you use a custom port, make sure Apache or Nginx server are on the same (from http.conf file or nginx same, and later as well in wp-config.php file).

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

The topic ‘Error while installing WordPress on a MySQL Server using custom port number’ is closed to new replies.