• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

mysql

  1. G

    Issue DB query failed - Deadlock

    Hi All (new here, though been using plesk for last 10 years), I am experiencing this issue on all 6 of our Plesk servers, that I have never seen before. ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try...
  2. weareimpulse

    Question Allow remote connections from any host, not working

    I've just created a new database on a new server and then created a new user with it access control set to Allow remote connections from any host. I can connect to the database fine with the credentials on a website hosted in the server. (using the IP address not localhost). However when i try...
  3. M

    Issue Database Connection Refused 10 mins after Deploy

    Hello, I recently purchased a VPS server from GoDaddy that is running Plesk. I have a .NET 9 with React application running on the VPS. Currently in my local environment, I am able to smoothly run the application and connect to the database that is hosted on the VPS. When I deploy the...
    • mdberry
    • Thread
    • .net core 9 access denied access denied error error 500 firewall mysql mysqlconnector windows server 2022
    • Replies: 1
    • Forum: Plesk Obsidian for Windows
  4. P

    Resolved Backup Task error

    Hello. When i try backup my plesk i got error with mysql. Unable to make database dump. Error: Failed to exec mysqldump: Exit code: 2: mysqldump: Got error: 2002: "Can't connect to server on 'localhost' (99)" when trying to connect
  5. S

    Resolved MySQL memory usage limit exceeded

    How i can change or configurate the memory for MYSQL ?? i have installed MariaDB 10.3.39 and via Docker mysql 5.7.34 Docker show : Ressourcen Memory : 1.7 GB from 31.4 GB
  6. T

    Question How to change from MySQL to MariaDB (Plesk 18.0.65)

    Hi all, I was reading a lot, but still not getting it. Under DB Server I have MySQL 8, and no choice to build new DB as MariaDB...??? In "update" I get only MySQL to install as component. No MariaDB to choice. How can I change to MariaDB, because I want to upgrade Ubuntu18 to 20 with...
  7. S

    Issue cannot connect to remote mysql form specific docker container

    I have created a docker container, which runs in my local network at home. One runs on synology, the other on a raspberry pi. I have a database and username which allow remote connections on a database. When i use the container in my synology or my windows computer, i can connect to the database...
  8. T

    Issue Sudden High mariadb / mysql memory usage

    We are suddenly seeing the mariadb usage hit 41% and mysql memory usage spike and stay consistently high at around 60gb out of our 128gb server. Typically this value should be around 30gb day to day but something is causing the memory useage to spike. We havent made any particular changes. If...
  9. meymigrou

    Issue Unable to backup WordPress site in Plesk "Backup created with minor issues occurred"

    I have a WordPress website running on a dedicated server (Plesk Obsidian v18.0.64 and CentOS 7) which I am unable to backup from Plesk (or any other plugin whatsoever). Each time I try to backup the database I get this error: The backup Nov 11, 2024 05:55 PM was created and can be restored...
  10. S

    Issue no installation of components possible anymore

    The error occurred when I wanted to migrate something via Plesk migrator, an error occurred, then I uninstalled the Plesk migrator.A new installation is no longer possible but for all uninstalled components It is possible that the performance booster has changed something in the database.I...
  11. Talistech

    Resolved Backups failing since a couple days: Unable to run the backup agent

    Hi fellow Pleskians, My backups recently started failing a couple days ago. This is the error I am getting: Upon checking the journalctl logs while trying to take a backup, I see that it restarts every couple minutes because it crashes itself. You cna find the log trace on the bottom. As far...
  12. Nicola

    Question mysql_native_password to caching_sha2_password for database user

    Hello, in the database logs I find this warning. In fact when I create users from the plesk interface I can't choose the password saving method and the passwords are stored with "mysql_native_password". I would like the "caching_sha2_password" plugin to be used by default but I can't do this...
  13. S

    Issue Access to a database from another plesk server

    Hello everybody, I need to access to a plesk database of one domain hosted in one server from another domain in another server with plesk. In the destination server (the server where I need to access to de database) I went to Tools & Settings > Database Servers > Settings > and click on the...
  14. AdrianC

    Issue MariaDB High "created tmp disk tables"

    I am trying to optimize my ~large dbs (around 150 GB MySQL) to write less to SSD and more to memory, and I am comparing the variables on a Alma Linux 8.10 with Plesk 18.0.38 with MariaDB 10.3.28 vs a Rocky Linux machine with MySQL 8.x without any panel. On Plesk the MySQL status variables...
  15. S

    Issue Too many connections (Several plesk servers same problem in the last week)

    Hello, Last week I had different 5 plesk servers with the same problem. I see the error "too many connections" in the websites or control panel. All the servers are with Debian 12 and Plesk 18.0.61 #5 Restart mysql does not work. If I execute: I have to wait nearly 30 minutes and after that...
  16. K

    Issue Plesk Migrator fails on mysql connection

    Running Plesk migrator shows: Failed to fetch information from target servers Cause: Command execution failed on the local server with non-zero exit code. command: MYSQL_PWD="$(cat /etc/psa/.psa.shadow)" mysql --silent --skip-column-names -u admin psa -e 'SHOW VARIABLES LIKE '"'"'socket'"'"''...
  17. K

    Question Multiple mysql servers

    I have 2 mysql servers (5.7 and 8.3). 5.7 is the default one and 8.3 is the newly setup one. When customer login, he only sees the 5.7 server. There is no 8.3 in the drop-down list. How can I configure so that the customer can see both servers in the drop-down.
  18. I

    Issue my.cnf empty

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

    Resolved difference between mariadb and mysql causing issues. How to use 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...
  20. D

    Question database user host restrictions

    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...
    • David_VB
    • Thread
    • database permissions database users host host restrictions mariadb mysql
    • Replies: 0
    • Forum: Open Topics
Back
Top