MySQL Host IP Address

  • EllACee

    (@ellacee)


    9 years, 1 month ago

    Can you please tell me from which file Watu gets the MySQL database host name?

    I am getting an error message.

    The error message is:

    WordPress database error: [ALTER command denied to user ‘name’@xxxx.xxxx.com’ for table ‘wp_watu_master’]

    My hosting company says this is not a permissions error and the user name is correct. Instead, the error is because the ‘xxxx.xxxx.com’ after the ‘@’ in the above error message is the wrong database host ip address.

    My wordpress config file has the right DB host ip address. Where can I change the database host address so Watu will look in the right place for the tables?

    TIA

    Ell

    https://wordpress.org/plugins/watu/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Bob

    (@prasunsen)

    9 years, 1 month ago

    Like all plugins the DB details are obtained from your wp-config.php file.

    The problem is that your DB user has no ALTER TABLE privileges.

    Thread Starter EllACee

    (@ellacee)

    9 years, 1 month ago

    Thank you for the reply.

    The problem is that the DB host ip address in the error message is incorrect. The database is not at that address where Watu is looking, so there can be no user with that name at that address to have any privileges.

    The database does not exist where Watu is looking. But the database config file has the correct address.

    Thread Starter EllACee

    (@ellacee)

    9 years, 1 month ago

    As an update, my host support team says this:

    –I have confirmed that the Database host IP is mentioned correctly in the config file. Please check with the plugin support team regarding how it is accessing the database server IP address, as I am not able to identify any related file in the plugin settings, where the IP is mentioned.–

    Also, I have disabled the plugin and re-enabled it. No change.

    Perhaps I need to uninstall it entirely, reload it and re-do all my quizzes. Unless you have another suggestion.

    Plugin Author Bob

    (@prasunsen)

    9 years, 1 month ago

    Sorry but Watu does not do ANYTHING to connect directly to the DB. It uses your WP DB connection.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘MySQL Host IP Address’ is closed to new replies.