Title: Doubt with users Last modified: August 30, 2016 --- # Doubt with users * Resolved [ulises2010](https://wordpress.org/support/users/ulises2010/) * (@ulises2010) * [10 years, 6 months ago](https://wordpress.org/support/topic/doubt-with-users/) * Hello and thanks for your work. * I’m trying to conect with a external DB with your plugin but I can’t 🙁 * I recibe in the ‘External DB data’ link this message: * > 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 * I see you say: * > 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. * In this case I’m trying to connect to the external database using user “Medina” and Medina has no access to that database. But ‘Medina’ is the name os the administrator of the WP where I install the plugin, but no the user I put in the ‘External DB setting’ really the user ‘Medina’ don’t exits in the external DB, the user that exist is the is the user I put in the ‘External DB setting’. What I’m doing wrong? * Thkas for your effort * [https://wordpress.org/plugins/external-database-access-using-wp-user/](https://wordpress.org/plugins/external-database-access-using-wp-user/) Viewing 11 replies - 1 through 11 (of 11 total) * Plugin Author [Sandip S Salunke](https://wordpress.org/support/users/sandysalunke/) * (@sandysalunke) * [10 years, 6 months ago](https://wordpress.org/support/topic/doubt-with-users/#post-6635088) * 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 * Plugin Author [Sandip S Salunke](https://wordpress.org/support/users/sandysalunke/) * (@sandysalunke) * [10 years, 6 months ago](https://wordpress.org/support/topic/doubt-with-users/#post-6635089) * 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 * Thread Starter [ulises2010](https://wordpress.org/support/users/ulises2010/) * (@ulises2010) * [10 years, 6 months ago](https://wordpress.org/support/topic/doubt-with-users/#post-6635090) * 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 * [http://www.awesomescreenshot.com/image/660389/826fec675a9c637914c6357a3b555f98](http://www.awesomescreenshot.com/image/660389/826fec675a9c637914c6357a3b555f98) * Plugin Author [Sandip S Salunke](https://wordpress.org/support/users/sandysalunke/) * (@sandysalunke) * [10 years, 6 months ago](https://wordpress.org/support/topic/doubt-with-users/#post-6635091) * 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 * Thread Starter [ulises2010](https://wordpress.org/support/users/ulises2010/) * (@ulises2010) * [10 years, 6 months ago](https://wordpress.org/support/topic/doubt-with-users/#post-6635093) * Ok, I try it… but then why I have to fill the fields in the screenshot? * Thanks * Plugin Author [Sandip S Salunke](https://wordpress.org/support/users/sandysalunke/) * (@sandysalunke) * [10 years, 6 months ago](https://wordpress.org/support/topic/doubt-with-users/#post-6635095) * 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 * Thread Starter [ulises2010](https://wordpress.org/support/users/ulises2010/) * (@ulises2010) * [10 years, 6 months ago](https://wordpress.org/support/topic/doubt-with-users/#post-6635096) * 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 * Plugin Author [Sandip S Salunke](https://wordpress.org/support/users/sandysalunke/) * (@sandysalunke) * [10 years, 6 months ago](https://wordpress.org/support/topic/doubt-with-users/#post-6635097) * 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 * Thread Starter [ulises2010](https://wordpress.org/support/users/ulises2010/) * (@ulises2010) * [10 years, 6 months ago](https://wordpress.org/support/topic/doubt-with-users/#post-6635104) * 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: * [http://www.awesomescreenshot.com/image/662996/8e1e0b598678eed0bccf208770a17088](http://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’ * Plugin Author [Sandip S Salunke](https://wordpress.org/support/users/sandysalunke/) * (@sandysalunke) * [10 years, 6 months ago](https://wordpress.org/support/topic/doubt-with-users/#post-6635106) * Hi, * Check with your database credentials. * Regards Sandip * Thread Starter [ulises2010](https://wordpress.org/support/users/ulises2010/) * (@ulises2010) * [10 years, 6 months ago](https://wordpress.org/support/topic/doubt-with-users/#post-6635107) * 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 Viewing 11 replies - 1 through 11 (of 11 total) The topic ‘Doubt with users’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/external-database-access-using-wp- user.svg) * [External DB Connect.](https://wordpress.org/plugins/external-database-access-using-wp-user/) * [Support Threads](https://wordpress.org/support/plugin/external-database-access-using-wp-user/) * [Active Topics](https://wordpress.org/support/plugin/external-database-access-using-wp-user/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/external-database-access-using-wp-user/unresolved/) * [Reviews](https://wordpress.org/support/plugin/external-database-access-using-wp-user/reviews/) * 11 replies * 2 participants * Last reply from: [ulises2010](https://wordpress.org/support/users/ulises2010/) * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/doubt-with-users/#post-6635107) * Status: resolved