• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • Our UX team believes in the in the power of direct feedback and would like to invite you to participate in interviews, tests, and surveys.
    To stay in the loop and never miss an opportunity to share your thoughts, please subscribe to our UX research program. If you were previously part of the Plesk UX research program, please re-subscribe to continue receiving our invitations.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

mysql

  1. D

    Question Does AES_Encrypt use cbc mode as default ?

    Using Plesk Version 17.8.11. Mysql has some nice real time encryption/decryption (aes_encrypt/aes_decrypt) possibilities that others like libsodium dont have at the moment. On earlier versions mysql was build with ECB mode as onliest option. Since version 5.6.17 its possible to use other modes...
  2. D

    Issue Upgrading from MySql 5.5 to 5.6 on CentOS 6

    I am following the guide here: How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.0/10.1/10.2 on Linux when I get to the step # yum update mysql I get this output: Loaded plugins: fastestmirror Setting up Update Process Loading mirror speeds from cached hostfile * base...
  3. itoop

    Question change mysql version (to 5.7)

    Hallo, I'm wondering how to change mysql version to version 5.7 in plesk 17.8.11. At "Tools & Settings > Applications & Databases > Database Servers" MySQL Version 10.1.29 is shown - I think this version cannot be correct; maybe it's the MariaDB version. In a software running on this server...
  4. E

    Issue Upgrade from MySQL 5.5 to 5.6 (CentOS 6.10)

    Hi all, I am attempting to update MySQL on my Plesk server from 5.5 to 5.6. I have followed the guide here and initially run into the problem outlined here. Unfortunately the latter does not seem to have resolved the issue, in trying to update to 5.6. Can anyone of you kind people please...
  5. T

    Issue Accidently deleted plesk and its dependencies on Debian

    Hello Plesk! I accidently deleted plesk and its dependencies to reinstall mysql through grep on Debian 8 (jessie) Now, I see no fix to get it back working as apache is down apt-get update doesn't work. I tried changing sources.list but it doesn't work either. I tried ./plesk-installer and...
  6. Dru

    Resolved MySQL CPU usage

    Hi, recently the health monitoring on our server has started larting us to high MySQL CPU and Memory usage (it;s beeing getting over 20%). Howveer when I check 'SHOW PROCESSLIST' there is almost always less than 10 process runnig and other than the admion 'Sleep' commands, ther eother have...
  7. N

    Issue plesk database remote access

    how to configure plesk database remote access settings? can anyone tell me step by step guide because i'm noob to this field
  8. Fx17

    Resolved Server Error 500 Zend_Db_Adapter_Exception SQLSTATE[HY000] [2002] No such file or directory

    Hello, Following an update from Plesk 17.5.3 to version 17.8.11 update#6; I can not access Plesk's control panel anymore. I get a 500 error with the following message: Server Error 500 Zend_Db_Adapter_Exception SQLSTATE[HY000] [2002] No such file or directory Type Zend_Db_Adapter_Exception...
    • Fx17
    • Thread
    • abstract.php mysql repair kit server error 500 sqlstate[hy000] [2002] no such file or directory zend_db_adapter_exception
    • Replies: 4
    • Forum: Plesk Onyx for Linux
  9. A

    Question Manual Database rescue

    Ok. I ran into a small problem with my Plesk Server. I accidentally typed "rm -rf /etc", instead of "rm -rf etc", on the production server... On a positive note, we don't host customer sites, just our own. On the down side, there are about a dozen web sites down now. I had been bugging the boss...
  10. Servus

    Question MySQL - Active transactions and operations?

    Hi at all, I want to optimize my MySQL database for example InnoDB Buffer Pool Size. Therefor I performed this test: mysql> SELECT CONCAT(ROUND(KBS/POWER(1024, -> IF(PowerOf1024<0,0,IF(PowerOf1024>3,0,PowerOf1024)))+0.49999), FROM (SELECT SUM(data_length+index_length) KBS FROM...
  11. si47ash

    Issue Dropbox backup restore failed after server upgrade

    Hi, I have a Wordpress site on Plesk using DropBox to do the backup daily. The host firm upgraded the server and for some unknown reasons now my database is gone! When I tried to restore the backup this happened: Failed to Execute: \'/usr/local/psa/bin/pleskrestore\' --restore...
  12. stas styler

    Question increasing innodb_buffer_pool_size & memory bottleneck

    Dear pleskers! Love your forum and platform. Plesk is my main server manager and I totally love it. Unfortunately there are some things that are different when considering plesk installed. I got a new server with couple of websites on it (im providing hosting). It hosts big woo commerce...
  13. H

    Question Migration Unable to copy content of database Too many open files

    I am trying to migrate a huge website from cpanel to plesk. This website is a WordPress multisite that allows users to create their own blog. Wordpress multisite create new tables for each new user and blog, this is how it works. I have set open-files-limit to 65535 on both servers but I am...
  14. R

    Issue Can't Extract file download from /var/lib/psa/dumps

    Hello, I Have a major issue, for database backup copy one file from /var/lib/psa/dumps one daily backup. but how i can extract it. and how i use this backup database ?
  15. Q

    Question How to remove MariaDB and install Percona and/or MySQL ?

    Hi , since nowadays centos7 comes out with MariaDB 5.5 so any plesk I installed on centos7 , it is already binded with mariadb how can I switch to Percona or Mysql ? because all I googled out is about change from mysql to mariadb, no vice versa.
  16. M

    Issue "tac: write error: Broken pipe" during daily plesk upgrade

    Hi everyone, We are using Plesk since mid 2016 to manage 10 websites on our VPS Cloud (OVH as hosting) It works really good, thank you for providing such product However, we are experiencing an issue since a few weeks Everyday we have an alert on a red background which says "Failed to update...
  17. S

    Resolved Safe way to change MySQL 5.7 to MariaDB 10.1 Ubuntu

    Hi, I am used to use MariaDB for all my server setups, but im not sure how to install MariaDB 10.1 in a safe way for Plesk. All my optimization configs are based on MariaDB, and i would like to stay on that version. I found the guide How to install MariaDB in Ubuntu 16.04 Thats fine and all...
  18. akira9000

    Issue No Plesk login page after snapshot restore - MySQL server missing?

    Morning guys, CentOS 7.4 - Plesk Onyx 17.5.3 After trying to fix an issue last night I ended up restoring a snapshot on the server which has led to a new issue. I've SSH'd and done df -h. Disk is showing 106GB used. This is correct so I know the disk contents is still there but...Plesk login...
  19. T

    Question [Poll] MariaDB vs MySQL

    Hi, what are you using on yours servers, MariaDB or MySQL and why?
  20. F

    Question Migrate database from external mysql server to localhost

    Hi I have a dedicated mysql server to host the clients' databases. I have the need to turn off this dedicated server. In order to do this, I need to migrate the databases that are on this dedicated server to the server where plesk is installed. How should I proceed? Thank you
Back
Top