DirectAdmin Upgrade from MySQL 5.7 to MySQL 8.0 breaks Installatron

by | Nov 29, 2022 | Technical Help, Web Hosting, WordPress

Installatron logoInstallatron is a great server product. We have been using it since May of 2016 on a number of our website servers. Installatron is very cost effective and interfaces directly with DirectAdmin. It allows CharlesWorks staff to quickly set up websites on our servers for our clients.

Installatron provides for setting up many different types of sites. This includes WordPress, which happens to be our favorite. In fact, WordPress appears to be most people’s favorite. Nearly 40% of all websites are built using WordPress at the time of this writing.

Today, we went to set up a WordPress website as usual. However, we were presented with this error instead:

Error
mysql database connection failed:
host = localhost
database = ****************
username = ****************
password = **HIDDEN**
prefix = *********

errstr = Could not connect to `localhost` using the username `****************`
and password **HIDDEN** (mysqli) -- [2054] The server requested authentication method unknown to the client

Since the error was happening in Installatron, we contacted Installatron support for assistance with this. We have a number of servers, and found that Installatron was working on all our others. So, something must have been different with this server.

The Database Connection Problem

I had upgraded this particular server using DirectAdmin’s CustomBuild from MySQL 5.x to MySQL 8.x within a couple days earlier. Believing the update caused an issue, I contacted DirectAdmin support and their support team looked into it. They indicated they believed the issue was an Installatron issue.

Hindsight is always 20/20. What I should have tried prior to contacting DirectAdmin was setting up a WordPress site manually. When I set up a WordPress site manually, it worked fine first time out. Plus, this is a production server. All sites already on the server were operating just fine with no database issues.

Installatron support explained that the DirectAdmin Upgrade from MySQL 5.x to MySQL 8.x left an old-style MySQL user password on MySQL 8. This made no issue for existing site or for new sites manually set up. But it caused an issue with Installatron. After some back and forth with Installatron support, they referred my ticket to their development staff.

The Database Connection Solution

Installatron development confirmed that the issue was from the upgrade from MySQL 5.7 to 8.0.

They found another ticket under which someone reported the same issue and they fixed the issue by adding the below line to the server’s /etc/my.cnf file under the [mysqld] section and restarting MySQL. At the command line, logged in as the root user, and I did this:

cd /etc
nano my.cnf

Nano is my favorite command line text editor. Once in there, I noticed the configuration file is a very short one. I found the [mysqld] section and added this line under it:

default-authentication-plugin=mysql_native_password

Then I did the CTRL O to save it and CTRL X to exit nano.

Since I had the server’s administrative DirectAdmin panel open already, I navigated to Admin Tools > Service Monitor > mysqld and had it Restart. I could have also done this while at the command prompt of my Debian system using:

/etc/init.d/mysqld restart

Then I did a test to set up a WordPress website and Installatron worked just fine again.

I suspect this situation would occur only on an upgrade from MySQL 5.7 to MySQL 8.0 because the master passwords are not totally compatible.

CLICK HERE to find your domain name!   CLICK HERE to transfer your domain name!

Archives

Tags

24 hour (1) Accessibility (2) Accounting (1) Advertising (9) AdWare (1) Alex Johnson (2) Alignment (1) Android (2) Anti-Virus (1) Antivirus (1) Antrim Computer Repair and Service (3) APC Back-UPS (1) Appearance (2) Apple Mail (4) Apple Mobile Mail (2) Attachments (1) Audit (1) Authorized (1) Autoresponder (5) Availability (1) Backups (1) Badges (3) Bank Account (1) Bank Statement (1) Battery Backup (2) Bob Hill (1) Bookkeeper (1) Branding (5) Budget (2) Business (21) Business Management (1) Catalog (1) Charles Oropallo (1) CharlesWorks (39) Cherryl Jensen (1) Chrome (1) Cloud (1) Code (2) Communicating (1) Competition (1) Computer (2) Computer Cache (1) Computer Security (2) Constant Contact (1) Consultation (1) Contact Information (2) Content (1) Content Management (23) Content Management System (1) Copiers (1) Copy Machine (1) Coronavirus (2) Courteous (1) COVID-19 (2) Credibility (6) Credit Card (1) Credit Card Processing (1) CSS (8) Customer Service (2) Design (39) Design Expertise (1) Desktop (1) Dialup (1) DirectAdmin (3) Directions (1) DIVI (4) DNS (1) Do-it-Yourself (1) Documentation (1) Domains (17) Domain Transfers (5) E-Commerce (1) Email (63) Email Lists (4) Email Management (2) Email marketing (3) Etiquette (3) Eudora 6 (1) Exchange (1) Expanding (1) Facebook (1) Financial (1) Finish (1) Firefox (1) Fonts (1) Forms (2) Forms Protection (1) Fraud (2) Galaxy S4 (1) General Info (1) Gmail (1) GoDaddy (1) Google (1) Google Adwords Certified Partner (1) Google Chrome (2) Groups (1) Happy Holidays (1) Hardware Help (1) Hill Specialty Networks (1) Hosting (1) Images (1) IMAP (1) include (1) Infected (1) Information (23) insert pages (1) install (1) Internet Browsing Errors (1) Internet Consultant (1) Internet Explorer (1) Joomla! (1) Keywords (2) Laptop (1) Legibility (1) Linux (8) Logging on (1) Macintosh (1) Mail 6.0 (1) Mail 2011 (2) Make-Over (1) Malicious (1) Malware (1) Marketing (6) Matt Burke (3) MDaemon (3) MelbourneIT (2) menu (1) Merchant (1) meta (1) Microsoft (1) Microsoft Edge (1) Microsoft Hosted Exchange (5) Microsoft Live (2) Mobile Email Setup (1) Monadnock Region (1) Mozilla Firefox (2) MySQL (1) Nathan Wesley (1) Netscape (1) Netscape Messenger (1) Office Copiers (1) OfficeLive (1) Online (1) Outlook (9) Outlook 2010 (2) Outlook Express (1) PayPal (1) Pay Per Click (2) PC (1) Personal (1) Peter Harris (1) Peter Harris Creative (1) Phishing (2) PHP (2) pixel (1) plugins (1) Pop Email (1) Popularity (1) Portfolio (1) Power Grid Failure (1) PPC (1) Prevent Fraud (1) Privacy (1) Private (1) Product (6) Professional (4) Projects (2) Protect (1) Protection (1) Quality (2) QuickBooks (1) Reconciliation (1) Reduce Risk (1) Register (1) Reliability (2) Renew (1) Reseller (2) Resolution (1) Restrict User Access (1) Results (1) Review (2) Risk (1) Robin Snow (1) Roundcube (1) Safe (1) Samsung (2) Scam (11) Scammer (11) Search (1) Search and Replace (1) Search Engine Optimization (7) Search Engines (9) Security (17) Security Risk (1) Selling (1) SEO (2) Servers (2) Service (8) Shopping Cart (1) Site (1) SmarterMail (9) Social Engineering (1) Social Networking (1) Software (1) Solutions for Today (1) Spam (1) Spam Filtering (15) Spammer (1) Spyware (2) SquirrelMail (1) SSL (8) Statistics (2) Stats (2) Stone Pond Technology (1) Storage (1) Support (1) Tablet (1) Target Market (1) Technical Help (1) Testimonials (1) The CW Corner (1) Thom Little (1) Thom Little Associates (1) Thunderbird (3) Thunderbird 10 (2) TLD (1) Topic (1) Top Level Domains (3) Transaction (2) Transfer Data (1) Transfer Funds (1) Typography (1) Update (2) Uploading (1) UPS System (2) Up to Date (1) Virus (2) Viruses (1) Vista (1) Web (1) Web-Over (1) Web Development (83) Web Hoster (1) Web Hosting (2) Web Hosting Company (1) Web Mail (1) Webmail (8) Webmaster (10) Web Presence (23) Website (99) Website Development (1) Web Stats (1) Web terms (1) Web Writing (1) Windows 7 (2) Windows Mail (5) Windows XP (1) WooCommerce (3) WordPress (73) WordPress Updates (1) Working Remote (2) Writing (1) youtube (1)
Skip to content