Access denied for user

Happens when exporting data, btw

Hi, can you clarify the following question?

This is funny as I can hop on the phpMyAdmin, with the username listed in the code, and no password. Any ideas?

Hi,
sorry, written a bit unclearly.
I am trying to export data from tables to csv. A sheet is downloaded but it contains only the error codes listed in the first message.

I tried switching all plugins off and trying again. If I do so, no sheet is downloaded anymore, but the error code is given in the plugin screen itself. Slightly different (see below).

Again it seems to say the problem is the plugin cannot get access to the tables. That is funny because I can do this manually. I can go into cpanel, open MyPphManager, and view and export the tables myself. The username is the one included in the error code, and I do not need a password to login to MyPhpManager.
Is that more clear?

Warning: mysql_query(): Access denied for user ‘chinaene’@’localhost’ (using password: NO) in /home/chinaene/public_html/wp-content/plugins/wp-csv-to-database/main.php on line 96

Warning: mysql_query(): A link to the server could not be established in /home/chinaene/public_html/wp-content/plugins/wp-csv-to-database/main.php on line 96

Warning: mysql_num_fields() expects parameter 1 to be resource, boolean given in /home/chinaene/public_html/wp-content/plugins/wp-csv-to-database/main.php on line 98

Warning: Cannot modify header information – headers already sent by (output started at /home/chinaene/public_html/wp-admin/includes/template.php:1947) in /home/chinaene/public_html/wp-content/plugins/wp-csv-to-database/main.php on line 123

I think the issue is the fact that you don’t have to use a password to see your database. The plugin cannot link to your server, that is the other issue.

Well, i need to login to cpanel, but from there, not once more to get into MyphpAdmin. I believe that is entirely normal.
And yes, I also believe the plugin says it cannot access the database.

The question is: what could i try to fix it?

Hi, what you might like to try is enabling debug mode. Then carry out a test again and see if any valid information shows.

You could also check the server log files.

I’ve googled a bit more and seems there are more plugins that had the same issue. Explained as being caused by a change in the way WP accesses the database. See e.g., here
https://www.ads-software.com/support/topic/access-denied-for-user-localhost-using-password-no?replies=14

With this plugin not updated for 7 months, that may be the issue.
Could anyone report if the plugin works for them on wp 4.4.2?

Thank you for the information. The plugin developers will investigate further your issue.

Regards

Ok, thanks. Would be appreciated. Plenty of plugins that allow you to export tables, but haven’t found others that offer the same functionality. Most just allow core tables (or just the users table even) and/or export to sql format.
Best,
jorrit

I have tested this plugin with the latest version of WordPress and CSV to DB import works fine for sure.

The issue you are seeing has to be some kind of site specific issue. I unfortunately don’t have any clue as to why your site is having an access denial issue.

Just to be sure; you can export without problems as well?

@jorritgo have you tested the latest version?

There was an error with the export which I fixed. If you upgrade to the latest version, you won’t see any issue with the export database function (I tested that with latest WordPress version).

Still not working for me. Updated, now getting a slightly different error now. Opens in a blank screen rather than at the top of the plugin page.

Warning: mysql_query(): Access denied for user ‘chinaene’@’localhost’ (using password: NO) in /home/chinaene/public_html/wp-content/plugins/wp-csv-to-database/main.php on line 111

Warning: mysql_query(): A link to the server could not be established in /home/chinaene/public_html/wp-content/plugins/wp-csv-to-database/main.php on line 111

Warning: mysql_num_fields() expects parameter 1 to be resource, boolean given in /home/chinaene/public_html/wp-content/plugins/wp-csv-to-database/main.php on line 113

Warning: Cannot modify header information – headers already sent by (output started at /home/chinaene/public_html/wp-content/plugins/wp-csv-to-database/main.php:111) in /home/chinaene/public_html/wp-content/plugins/wp-csv-to-database/main.php on line 138

@jorritgo thank you for the latest report. The plugin developers will investigate further those warnings messages.

Regards