mariadb

Dear Plesk forum members, Since Plesk by default doesn't seem to restrict database users to a host / hosts. I know how to set this for new users, and I also know how to alter this setting from the Plesk panel for existing users, but since I have to deal with a lot of existing unrestricted users...

hi i just wanna know if the mariadb upgrade tool from plesk UI now is stable with the Plesk Obsidian 18.0.59 or still a beta version regards.

I have a problem with the server and a web page. Since several hours ago, Monitoring360 is detecting that mariadb is using a lot of CPU, being constantly my CPU at 80% according to Monitoring360 (I have an open alert that does not end up closing). But from Plesk, if I go to Process List, the...

Hi, i'm trying to add to plesk an external mariadb database, my plesk version is Plesk Obsidian 18.0.57 my OS is CentOS Linux release 7.9.2009 i insert the ip, username and password but i got this message Database server was updated with error: The test connection to the database server has...

Hello, we have recently tried to connect our MariaDB databases to Papertrail but we cannot seem to make it work. We followed documentation from SolarWinds (Database monitoring system requirements) tried some options from Performance Schema Overview but after adding this [mysqld]...

Hello, we tried to use the tutorial https://support.plesk.com/hc/en-us/articles/12388091703703--How-to-upgrade-MySQL-5-5-to-5-6-5-7-or-MariaDB-5-5-to-10-x-on-Linux- to upgrade from MariaDB 10.3 to 10.6. But it does not work. In step 3: "curl -LsS...

Hello, I need to change the location of the directory /var/lib/mysql, but I can't seem to find out how to do it in Linux. I remember that it used to be possible in the past, and it's even mentioned in Plesk's Knowledge Base, but for Windows. Is there a way to do it in Linux? Thank you very...

Hey, i want to install Password Pusher (GitHub - pglombardo/PasswordPusher: An application to securely communicate passwords over the web. Passwords automatically expire after a certain number of views and/or time has passed. Track who, what and when.) (MySQL) via docker hub, that works...

Hello, I just want to report that we had problems with updating MariaDB 10.3 to MariaDB 10.5 on CloudLinux 8. The server was perfectly working for 2 years on MariaDB 10.3 but due WordPress requirements we needed to update it. The following commands were executed as root: MYSQL_PWD=`cat...

The Database Export option within Plesk shows this error. Exporting from phpMyAdmin works fine. Tools and settings > Database Servers shows the MariaDB version correctly as 10.5.22. It was manually updated from the default build version 5 which might well have been 5.05.22 - as per the error...

I guess I did something really stupid, but any help or advice will be welcome. Long story short: My server was full, so I couldn't login into Plesk and all my sites were down. I tried to fix it with the repair tool kit, but I could not login, my credentials were rejected (I tried to use root &...

1.) When trying to Export Dump from the Plesk Database dashboard I get following error: Unable to export a dump of wp_c2: mysqldump: Warning: Charset id '33' csname 'utf8' trying to replace existing csname 'utf8mb3' mysqldump: Warning: Charset id '83' csname 'utf8' trying to replace existing...

I followed this guide https://support.plesk.com/hc/en-us/articles/12388091703703--How-to-upgrade-MySQL-5-5-to-5-6-5-7-or-MariaDB-5-5-to-10-x-on-Linux- When I start step 6 I get: When I check the status it says the following: # systemctl status mariadb.service ● mariadb.service - MariaDB...

Looking at the Process List in Plesk, I see: Full command /usr/sbin/mariadbd RAM usage 25.6 % (RAM virt 1.53 GiB/ RAM res 203.36 MiB) CPU usage: 0.2% State: Sleeping Disk I/O (read) 0 KiB/s Disk I/O (write) 0 KiB/s I have a total of 2GB of RAM. Is it normal for mariadbd to be using this much...

Unable to start mariadb service. when i tried to repair the result did not change. The first cause of the problem was that mariadb could not be started because the server disk capacity was full. After deleting the logs, disk space was freed, but mysqld.sock continued to give an error because...

As the latest Version of Plesk Obsidian supports MariaDB 10.11, I would like to upgrade now from my current version 10.6. What is the best procedure for doing this? Is this the right basis: https://support.plesk.com/hc/en-us/articles/12388091703703

Did an upgrade of our server from Ubuntu 20.x to 22.x Afterwards, all site work fine when connecting to the mariadb database except one. In fact two seperate sites use the same database. One can connects to the the database using the same credentials and works as it did before. However the...

Hello, Since a week ago there seems to be an issue with my backups on one of my servers The backup is incomplete with a bunch of these same message. I looked up the error and found some topics on ehre but none of the solutions seem to work for me. I attached my 50-server.cnf and the my.cnf are...

Hi, after upgrading plesk to 18.0.50, it looks like the database support isn't working anymore or there is a gui problem. Product version: Plesk Obsidian 18.0.50.0 OS version: AlmaLinux 9.1 x86_64 Database version: 10.5.16-2.e19_0 plesk repair mysql Checking MySQL database servers...

Hello there, I have updated my Server from Ubuntu 16.04 LTS to 20.04 LTS and Plesk from 18.0.35 to 18.0.46. So far I could solve all problems using google and this Forum. Now I get an error after daily Backups. The error msg is as follows: I must admit, I can't remember if MariaDB was...