Sandip S Salunke

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

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 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,

Thanks for writing us.

After plugin installation, you can find External DB settings in admin panel of your wordpress site. There you can set all the necessary details of your external database. The details are then used to connect to the database you mentioned in settings.

Menu: External DB settings

I hope it may help, please feel free to ask if you have any further doubts.

Regards
Sandip

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 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

Hi Salim,

Thanks for your interest, hope you are doing well.

“External DB Connect” is designed to connect to different type of databases to access their tables and perform crud on them. Basically this plugin is used to connect to remote database hosted on any server. In your case if the database is hosted on any of the server, then yes you are at the perfect place.

“External DB Connect” can help you to get the database records in your WordPress site. It provides widgets to display database table records and perform crud on it.

Don’t forget to read plugin document for installation process and dependencies.

Enjoy the power of WordPress plugins and “External DB Connect” as well…!!

Thanks & Regards
Sandip Salunke

Hi,

Thanks for using “External DB Connect”.

I don’t understand what problem exactly you are facing, it’ll be helpful if you share screen shots. Also please mention your WordPress version.

Suggestion: Try to use plugin with lower WP versions.

Thanks & Regards
Sandip S.

Hi,

Firstly, thanks for your visit to the plugin.

The link you provided is working fine. Please elaborate if you wanted to point an issue with plugin.

You can enjoy plugin by downloading it through below mentioned link.

External DB Connect