mysql_query(): Access denied for user

  • I updated to WordPress 4.9.2 today and an old plugin that I have been using to execute PHP within posts is now giving the following error.

    Warning: mysql_query(): Access denied for user ‘myname’@’localhost’ (using password: NO) in…

    I know I shouldn’t be using PHP Execution which hasn’t been updated in 8 years and maybe I shouldn’t even be using PHP in my posts. However, I’m hoping there is at least a workaround until I figure something else out. And yes I’m open to suggestions, but I have hundreds of posts that are executing PHP right now. Unfortunately, I only know enough to be dangerous when it comes to PHP and WordPress.

    Did the latest WP update do something that would have caused this issue?

    Things I have tried:
    – disabled all plugins except PHP Execution
    – cleared all caches and tried multiple browsers and an iPhone
    – tried other plugins that allow PHP to be executed
    – reinstalled WordPress 4.9.2
    – previewed site with Theme Twenty Sixteen

    Any help would be greatly appreciated.

Viewing 11 replies - 1 through 11 (of 11 total)
  • Moderator t-p

    (@t-p)

    I know I shouldn’t be using PHP Execution which hasn’t been updated in 8 years

    You shouldn’t use it — security risk for one.

    anonymized-15380454

    (@anonymized-15380454)

    an old plugin that I have been using to execute PHP within posts

    Have you tried disabling that plugin?

    Is the plugin still available on www.ads-software.com?

    And if all else fails, then it’s probably time to look for an alternative to that plugin. Example: PHP Everywhere.

    Thread Starter caddyx

    (@caddyx)

    I can disable it, but then part of my PHP code shows.

    The plugin is still available on www.ads-software.com.

    I did try a couple of other plugins, including PHP Everywhere and still got the same error.

    Thanks.

    Moderator t-p

    (@t-p)

    The plugin is still available on www.ads-software.com

    What’s the exact, full name of this plugin?

    Thread Starter caddyx

    (@caddyx)

    PHP Execution – https://www.ads-software.com/plugins/php-execution-plugin/

    However, when I disable it and use PHP Everywhere, I get the same error.

    Thanks.

    Moderator t-p

    (@t-p)

    First off, I recommend not to use this outdated plugin. It’s a security risk to use it, for it’s not being maintained for many years.

    However, when I disable it and use PHP Everywhere,

    To find any conflict between PHP Everywhere plugin and other installed plugins or theme:
    – Try manually resetting your plugins (no Dashboard access required). If that resolves the issue, reactivate each one individually until you find the cause.
    – If that does not resolve the issue, access your server via SFTP or FTP, or a file manager in your hosting account’s control panel, navigate to /wp-content/themes/ and rename the directory of your currently active theme. This will force the default theme to activate and hopefully rule-out a theme-specific issue (theme functions can interfere like plugins).

    If the issue persists, report it to the author of PHP Everywhere plugin at
    https://www.ads-software.com/support/plugin/php-everywhere so the plugin’s developers and support community can help you with this.

    anonymized-15380454

    (@anonymized-15380454)

    – tried other plugins that allow PHP to be executed

    Sorry, I didn’t really notice that.

    Maybe the error is caused by the code that you actually used within your post?

    And where did you first see the MySQL error? Is it on the homepage, a contact page, the blog, etc.? Or is it everywhere on the front-end?

    Is the error printed on the page, or did you see it in the error_log file, or maybe wp-content/debug.log?

    Try to enable WP_DEBUG and WP_DEBUG_DISPLAY (i.e. set both to TRUE in wp-config.php).

    • This reply was modified 7 years, 1 month ago by anonymized-15380454. Reason: Corrected file name
    Thread Starter caddyx

    (@caddyx)

    Thanks t-p and Sally. I will go through all of the troubleshooting steps and let you know.

    Thread Starter caddyx

    (@caddyx)

    No luck so far. I don’t exactly where eWP_DEBUG and WP_DEBUG_DISPLAY.

    The error is on most pages on the site. The code worked fine for years and then yesterday it stopped working when I did the update.

    I’m ready to hire someone to fix this. Any suggestions?

    Moderator t-p

    (@t-p)

    I’m ready to hire someone to fix this.

    If you want to follow that option and hire someone for this, then please try https://jobs.wordpress.net/ (FYI, it’s not a good idea to respond to work offers from random forum users who have read about your issues.) – This topic has now been closed as per the https://make.www.ads-software.com/support/handbook/forum-welcome/#do-not-offer-to-pay-for-help
    Asking for contact info: https://make.www.ads-software.com/support/handbook/forum-welcome/#the-bad-stuff

    Moderator Samuel Wood (Otto)

    (@otto42)

    www.ads-software.com Admin

    Hi. I’m the resident person around here who knows about PHP execution plugins and why you shouldn’t use them. Please email me about your problem, with specific details, and I will do my best to show you the right way to stop using these types of plugins without losing anything.

    My email is otto at WordPress dot org.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘mysql_query(): Access denied for user’ is closed to new replies.

Tags