Just activated plugin -error

Hi soapdroid,

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.

– First of all enable your error reporting for wich will show you the errors, warnings and notices.
– Now try to access the same page again. You will get following warning message.
Warning: mysqli_connect(): (HY000/1045): Access denied for user 'YOUR_USER_NAME_HERE'@'localhost' (using password: YES) in C:\xampp\htdocs\wordpress\wp-content\plugins\external-database-access-using-wp-user\ext_db_aaccess.php on line 180
Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in C:\xampp\htdocs\wordpress\wp-content\plugins\external-database-access-using-wp-user\ext_db_aaccess.php on line 180
– 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

Hi ulises2010,

Please try to understand the plugin behaviour 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.

Regrds
Sandip S

Hi,

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

Regards
Sandip