Error connecting to database…..yay

  • thefarmer1995

    (@thefarmer1995)


    5 years, 5 months ago

    I am really hoping this is a simple “Oh I know what you did wrong” type of thing but here is what I did. My website was working just fine, I updated my ubuntu version from 16 to 18 and from 18 to 20, website broke at the first update and I knew it would happen because It happened a long time ago as well. The error is the error connecting to database issue and it is saying

    Warning: mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password] in /var/www/html/wp-includes/wp-db.php on line 1531

    So I checked everything and theres no issues with passwords or anything but obviously I am missing somthing because I cannot get the site working. Whatever information you need just ask or if this is somthing you know exactly whats wrong than yay! Thanks for any help 🙂

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Liew Cheon-Fong

    (@lcf)

    5 years, 5 months ago

    What database and version?

    Dion

    (@diondesigns)

    5 years, 5 months ago

    Updating PHP to the 7.4 branch will solve the problem. If you prefer to use an older version of PHP (I personally will be using PHP 7.3 until the 8.0 branch is stable), add the following line to the [mysqld] section of your my.cnf file, then restart MySQL:

    default_authentication_plugin=mysql_native_password

    That will also solve the problem.

    Thread Starter thefarmer1995

    (@thefarmer1995)

    5 years, 5 months ago

    So that worked, I ended up updating PHP because……. I could not find the my.cnf file…well actually I found like 14 of them so yea.. but thanks it works now the only issue I have is that the new version gave me a bunch of errors like this

    “””Deprecated: Function get_magic_quotes_gpc() is deprecated in /var/www/html/wp-includes/formatting.php on line 4382″””

    All over the site, maybe just need to update wordpress but were online again so it’s progress 🙂

    Dion

    (@diondesigns)

    5 years, 5 months ago

    You’ll need to update WordPress to at least 5.2 to be compatible with PHP 7.4.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Error connecting to database…..yay’ is closed to new replies.