Doubt with users

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,

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 (Medina) 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: Medina (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

Thaks a lot Sandic, but I’m still confusing

As you can see in the screenshot. I put in the External DB settings the user and the pass who have access to the external DB, in this case:

mobiespo_admin

But as say the error:

Warning: mysqli_connect(): (28000/1045): Access denied for user ‘Medina’@’localhost’ (using password: YES) in /home/lasombradetusomb/public_html/pruebas/paisajelimpio/wp-content/plugins/external-database-access-using-wp-user/ext_db_aaccess.php on line 180

The progran is trying to conect using my WP user, Medina

https://www.awesomescreenshot.com/image/660389/826fec675a9c637914c6357a3b555f98

Hi,

Simply, create a user in your external database with

1. Username: Medina (your WP admin username)
2. Password: ****** (your WP admin password)
3. Privileges: All

And then try to connect, it should work now.

There is note at the top of External Database Settings page “Make sure your WP admin account exists in the external db prior to saving these settings.” Didn’t you notice that?

There should be the user in your external database with your WP admin username and WP admin password.

I hope this may help now.

Regards
Sandip

Ok, I try it… but then why I have to fill the fields in the screenshot?

Thanks

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

Thanks Sandip, I re-install the plugin but I don′t see any change and still is the version 1.1

Thanks for your work

Hi,

I have reinstalled it on my WP site and it’s working fine at my end. Please try to delete existing plugin and reinstall the same directly from your WP admin panel.

Regards
Sandip

It’s true, now don’t use the user of WP but the one I put in the External DB settings…. but still I can’t conect:

This are the message I have:

Warning: mysqli_connect(): (HY000/2003): Can’t connect to MySQL server on ‘rdbms.strato.de’ (110) in /home/lasombradetusomb/public_html/pruebas/paisajelimpio/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 /home/lasombradetusomb/public_html/pruebas/paisajelimpio/wp-content/plugins/external-database-access-using-wp-user/ext_db_aaccess.php on line 180
Error

And in this screenshot you can see what I have in the settings:

https://www.awesomescreenshot.com/image/662996/8e1e0b598678eed0bccf208770a17088

(I really don’t know the name of the table, the screenshoot show ‘w1_users’ but I too try with ‘DB1565730′ and have the same result’

Hi,

Check with your database credentials.

Regards
Sandip

Thanks a lot Sandip, but the credentials are ok, I use the same use the other WP install in other server. I copy the datas from the wp-config.php

// ** Ajustes de MySQL. Solicita estos datos a tu proveedor de alojamiento web. ** //
/** El nombre de tu base de datos de WordPress */
define(‘DB_NAME’, ‘DB1565730’);

/** Tu nombre de usuario de MySQL */
define(‘DB_USER’, ‘U1565730’);

/** Tu contrase?a de MySQL */
define(‘DB_PASSWORD’, ”);

/** Host de MySQL (es muy probable que no necesites cambiarlo) */
define(‘DB_HOST’, ‘rdbms.strato.de’);

/** Codificación de caracteres para la base de datos. */
define(‘DB_CHARSET’, ‘utf8’);

/** Cotejamiento de la base de datos. No lo modifiques si tienes dudas. */
define(‘DB_COLLATE’, ”);

/**#@+

I delete the pass for safe