The error you're encountering, Database error 2059: Database Connection Error, specifically indicates that MySQL (or MariaDB) is unable to load the https plugin. Here's a breakdown of what's happening and how to address it:

---

Root Cause

• The error message:

   Copy
  SQLSTATE[HY000] Plugin https could not be loaded: /usr/lib64/mysql/plugin/https.so: cannot open shared object file: No such file or directory

  means that MySQL/MariaDB is configured to use the https plugin (likely for secure connections), but the required shared library (https.so) is missing or not found at the specified path.

---

Possible Reasons

1. Missing Plugin File: The https.so file is not installed or not located at /usr/lib64/mysql/plugin/.
2. Incorrect Configuration: The MySQL/MariaDB configuration file (e.g., my.cnf or my.ini) might be set to load the https plugin, but the plugin is not available.
3. Plugin Not Installed: The https plugin might not be installed as part of your MySQL/MariaDB installation.

---

How to Fix It

1. Check if the Plugin Exists

Run the following command to check if the file exists:

bash
 Copy
ls /usr/lib64/mysql/plugin/https.so

If it doesn't exist, you may need to install it.

2. Disable the Plugin (if not needed)

If you are not using HTTPS connections for MySQL, you can disable the plugin:

• Edit your MySQL/MariaDB configuration file (e.g., /etc/my.cnf or /etc/mysql/my.cnf).
• Look for a line like:

   Copy
  plugin-load=https=https.so

  and comment it out or remove it.
• Restart MySQL/MariaDB:

  bash
   Copy
  sudo systemctl restart mysql
  # or
  sudo systemctl restart mariadb

3. Install the Plugin (if needed)

If you need the https plugin, install it:

• For MariaDB:

  bash
   Copy
  sudo yum install MariaDB-shared
  # or
  sudo apt-get install mariadb-plugin-connect

• For MySQL: The plugin might be included in the mysql-server package or a related package. Check your distribution's documentation.

4. Verify Plugin Installation

After installing, check if the plugin is available:

sql
 Copy
SHOW PLUGINS;

Look for https in the list.

5. Check File Permissions

Ensure the plugin file has the correct permissions and is accessible by the MySQL user.

---

Additional Notes

• If you are using a managed hosting service, contact your provider for assistance.
• If you recently upgraded MySQL/MariaDB, the plugin might have been removed or moved.

---