Cannot connect to external DB when working in localhost

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Sandip S Salunke

    (@sandysalunke)

    8 years, 8 months ago

    Hi hamergil,

    I believe you are doing well.

    I have gone through the problem you are facing, please check with below details which will help you to resolve the same.

    – Note that when new user is being created in WP site the plugin create the user in your external database with his/her credential.
    – For existing users (user created before installation of plugin) it creates the user in your external database with his/her existing credential. To access the external database you need to edit user profile so that plugin can create the user in external database with his/her details.
    – Here the term “user” is database user like we have “root” in our MySQL.
    – I can see that you are trying to connect to your external database using user “admin” and admin has no access to that database. There are few possibilities like the user is not created for your external database OR the user has insufficient permissions.
    – Please try to check if the user is exist in your external database, and if it is exist then check for its permissions and change the same accordingly.
    – If the provided details does not help you much then feel free to contact me.

    Thanks for using plugin and reporting an issue.

    Regards
    Sandip S

    Plugin Author Sandip S Salunke

    (@sandysalunke)

    8 years, 6 months ago

    Hi hamergil,

    I believe you are doing well.

    I have gone through the problem you are facing, please check with below details which will help you to resolve the same.

    It seems that you are trying to connect to your external database with the user (admin) which is not exist in your external database OR it may do not have sufficient permissions to perform actions on your external database. Please make sure that you should have user in your external database with below details.

    Username: admin (Your WP admin username)

    Password: ********** (Your WP admin password)

    privileges: All privileges

    Note: Please enter the same username and password in plugin settings page in your WP admin panel.

    Additional Information: Please try to understand the plugin behavior through below steps.

    1. When you install “External DB Connect” plugin, you can see the settings page in your WP admin panel.
    2. You should have access to the external database you are trying to connect, say you have “root” user with all privileges, which will be used by the plugin to perform operations.
    3. Enter all the required details on settings page. Note here you have to enter user=”root” and password=”PASSWORD_FOR_USER_root” along with other details like host name, privileges to be given to end users to access data from database.
    4. Whenever a new user (End User) is created OR existing user is edited in WP, plugin will create a fresh user in your “External Database” with WP Username and Password with given privileges (permissions).
    5. That’s it, now the user is ready to access the data from your “External Database”.

    Note: Here you need a user which will be used by plugin to deal with your “External Database”. And plugin will handle rest of the things. Also make sure, if you are installing “External DB Connect” on existing WP site having active users, then you have to edit all the users explicitly. No worries for upcoming (new) users.

    I hope this may help. Please feel free to ask if you have any queries.

    Thanks for using plugin and reporting an issue.

    Regards
    Sandip S

    Plugin Author Sandip S Salunke

    (@sandysalunke)

    8 years, 6 months ago

    Hi,

    I have made few changes to the plugin source code to resolve this issue. Please reinstall the “External DB Connect” and enjoy your plugin..!!

    Regards
    Sandip

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Cannot connect to external DB when working in localhost’ is closed to new replies.