mysql

I woke up and this server had the my.cnf empty... I have replaced it from another one that I had... and fixed the problems that I had... Any suggestions? Thanks SO Debian 10.13 Producto Plesk Obsidian Versión 18.0.59 Actualización 2, última actualización el 13/Mar/2024 11:46 mysql -V mysql...

Hi, I have had a website created and I am deploying it on my plesk server. Everything is working fine except a data connection. I have been told that the database has to be mysql and on plesk it is using mariaDB which is not compatible with how my website is set up. I don't see an option to...

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

I have a forum which suddenly can no longer connect to mysql. The only thing done was an upgrade which finished succesfully with the database upgrade directly after that the connection was lost. But all the file permissions look right. File owner and group is correct. The mysql settings in the...

Hi, dear community! I've got 30 domains (Plesk Obsidian, version 18.0.57, Web Pro version) I have the following problem with 1 domain: This site and domain initiate problems in SQL queries and when domain operates all MySQL bases will be down on the server (error = "Too many SQL...

Hello, I have tons of registers with this user 'monitoring' trying to log onto the mysql... How can I check where this logging attempts come from? I mean obviously from localhost, as the register itself says, but from what program, cron or whaeteber process or web is doing this... And as far...

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

Hi, I'm attempting to enable MySQL secure connection on 18.0.52 but when I edit panel.ini with tls.enable to true Plesk gives the following fatal error "The localhost is not compatible with enabling a secure connection." This plesk instance is connected to a localhost instance and one remote...

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, My VPS is hosted to OVH. I can't access my VPS, even via ssh (I insist: even via SSH). I did a snapshot before a mysql update: unfortunately, I couldn't go through with it... When I came back, I couldn't connect anywhere. So I asked for the snapshot to be installed, but it didn't work...

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