mysql

Hi guys, I'm struggling with an issue after updating Plesk and system packages. Before the update it was possible to remotely connect to the server for MySQL. I've checked all possible parameters for enabling remote MySQL connections, but I can't find the issue. My environment Plesk Obsidian...

HI, I did a migration (through Plesk tool) from an Ubuntu machine to a Debian machine. In the new environment I have a problem with special characters (è é ò, ...). At the database level the charsets of the tables are the same between the two servers and the data saved within the database are...

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 &...

My server is running MariaDB 5.5.68. I would like to upgrade to 10.5 or a higher version. Could someone please assist me in upgrading it?

Hi, Can anyone advise on the below error? [2023-06-08 17:18:00.922] 22273:64819cba84ccd ERR [panel] DB query failed: SQLSTATE[HY000] [2002] Connection refused: 0: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79 Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''') 1...

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...

Dear Community. I am trying to make a migration script and came to the part where i need to export/import the database. I can create a database and import the database content from the old mysql server without a problem. But now i need to create the database user. And i like to dont change the...

Hello, yesterday i did an update on packages and while everything was working ok tomorrow i was greeted with this: This is when i try to restart mariadb I've tried to use plesk repair mysql but i get this error => I have tried other relative topics in the forums but couldn't get it to...

After running plesk sbin statistics --calculate-one --domain-name=example.com I get WARN: WARNING during statistics_collector execution: statistics_collector[17429]: Failed to process database 'example' from domain 'example.com': MySQL error 1049: Unknown database 'example' executing query...

Dear support team, I use a server with AMD Ryzen™ 5 3600, 64 GB DDR4, NVMe SSD 512 GB and Plesk. Are there ideal settings to increase mysql performance and achieve better performance? If so, can you provide me with recommended settings for /etc/mysql/my.cnf The following is currently stored...

I lost painel access after change mysql directory, I did all mysql's socket configurations, but the issue persist

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, Ive stumbled on a problem that is quite urgent. I was working on grafana when plesk on my server went down (plesk panel unreachable due to database error). The last change i made was 2 days before that and all i did was change the bind adress in my.cnf to :: After some troubleshooting i...

Hello, We are developing an extension for Plesk in PHP and we have need of interacting with WordPress databases on Customer domains. On Linux, we have been using the pm_Bootstrap::getDbAdapter() to make all of our requests using PDO. On Windows, however, the adapter could not interact with the...

Hello, I would like to connect my plesk database to our Grafana panel as a data source to read out some data. Where do i find the database connection info of the main database of the Plesk server? Any help would be appriciated. Kind Regards, Quinten

I run a fully dedicated Ubunto 20.04 server and a forum with around 60-70 members on-line daily (*not* all at once, but still a fair amount of constant activity). I'm looking to optimize my PHP FPM settings. Here's my server: Intel(R) Xeon(R) CPU E3-1230 v3 @ 3.30GHz (8 core(s), 32GB RAM...

I can not login to Plesk with username: root and provided password. Below error is what I get. Type Plesk\Exception\Database Message DB query failed: SQLSTATE[HY000] [2002] No such file or directory File Mysql.php Line 79 plesk -v is giving me: root@sharp-johnson:~# plesk -v...

We have a problem on updating data in database. We try to use the same database and same code on localhost, it works fine but when we try to update using the server the data cannot update. Have anyone encounter this kind of problem? Usually if this kind of problem happen what should we check...

I have a server running CentOS 6.10 Plesk Obsidian Version 18.0.31 Update 3. I want to migrate all subscriptions to another Server running Ubuntu 20.04.5 Plesk Obsidian Version 18.0.46 Update 2. The problem is that when I give new migration, when trying to connect to the CentOS server, I get...