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

    Resolved How to run mysql_secure_installation?

    Hi all, I tried to run "mysql_secure_installation" command on my server where Onyx is running but I always get login error because the Onyx default db user is admin and not root: I also tried to run: "mysql_secure_installation -uadmin" but with no success. Can anyone help me on this and tell...
  2. Pedro Reinoso

    Resolved Plesk is not operational MySQL password changed

    Hello, I was creating users in MySQL server, as i dont know the "admin" password i tried update the password. Onces I updated i got this error message: I was performing some of the KB solutions but could not be able to fix it, i create a ticket because maybe you have faced this situation...
  3. K

    Question Fail2ban for MySQL

    Hi, I can't find here on forum similar question. I need to have open port 3306 for all IPs. Is it possible somehow to protect mysql authentification with Fail2Ban? I found that enabling general log can slow server, but also I saw that is possible to enable only "log_warnings = 2", Is someone...
  4. L. Hagen

    Question MySQL wont start after restore

    Hi, two days ago I made a terrible mistake by removing some packages with dependencies to Plesk. So I had to restore from a backup. But unfortunately this fails and MySql wont start. So Plesk isn't staring as well. My service is hosted by STRATO and the guys told me that when I'm using their...
  5. BNB

    Question Upgrade MySQL + Install Elasticsearch + PHP libraries

    Hi, I am using Plesk Onyx v17.0.17 on CentOS 7 and I am quite new to command line but I need a few configurations done: 1) My MySQL is showing 5.5 and I would like to upgrade it to 5.6. I wasn't able to following the instructions here because I have no idea how to point "4. Add MariaDB...
  6. Loris Modena

    Question Server Plesk configuration for eCommerce in PrestaShop

    I would like to know how to optimize the configuration in order to increase performance especially with regard to database requests. The server at my disposal is as follows: Server OVH Enterprise SP-32 Linux Plesk 12.5 (Cent OS 7) Intel(R) Xeon(R) CPU E3-1231 v3 @ 3.40GHz – Core: 8 32 GB RAM...
  7. T

    Resolved Unable to manage DB server from plesk but mysql is reachable from ssh

    Hello, I've got a problem on my plesk panel. Actually, everything works well (all my websites are running) but I cannot manage my database server from plesk. Plesk tell me that it cannot connect to the server. In addition, when I try to create a new user on this database, i've got this message...
  8. B

    Question MariaDB change data directory location

    Hi, I'm trying to change the MariaDB data directory from /var/lib/mysql to /my_folder/mysql. Everything is good I can log into mysql in command line but plesk give me a hard time with Zend Errors. I've change my /etc/my.cnf and my /etc/psa/psa.conf to match with the new mysql location but...
  9. tonyo

    Resolved error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'

    I i'v tried every procedor found in google but i cannot restart mysql in centos. any suggestion. here is my tail -100 /var/log/mysql.log # tail -100 /var/log/mysqld.log the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB...
  10. H

    Resolved rpm_check_debug vs depsolve mysql update Error

    Hi I am having an update issue updating Plesk 12.5.30 from Version #42 to #59. The error log is the following: Running rpm_check_debug Fatal error during packages installation: [u'ERROR with rpm_check_debug vs depsolve:', 'rpmlib(FileDigests) is needed by...
  11. R

    Resolved Backup: The dump has wrong format!

    Hello, I want to start automatic backups for the Plesk setup in Plesk Onyx 17.0.17 but I get the following error log: Error: Runtime error: The dump has wrong format! domains/example.com/backup_info_1702080331.xml: Line 1103 error: Element 'database', attribute 'type': [facet 'enumeration']...
  12. M

    Issue What caused this error?

    Hi, Suddenly this error showed up: ERROR: PleskDBException: Unable to connect to database: mysql_connect(): Connection refused /var/lib/mysql/mysql.sock (Error code: 2002). Please check that database server is started and accessible. (Abstract.php:69) Since nothing changed on the server i...
  13. I

    Issue ERROR: PleskDBException: Unable to connect to database: mysql_connect():

    i am using plesk 12.0.18 with centos 7, when i try to login plesk this error appeared ERROR: PleskDBException: Unable to connect to database: mysql_connect(): Access denied for user 'admin'@'localhost' (using password: YES) (Error code: 1045) (Abstract.php:69) using this help i was able to...
  14. Dumitru

    Resolved mysqli - Cannot assign requested address between two server

    Hello I have two servers with Plesk Onyx One server for files , second for mysql (more the 1K request per /s) If I have online visitor more then 700 it give me some error PHP message: PHP Warning: mysqli::__construct(): (HY000/2002): Cannot assign requested address .. while reading response...
  15. Hoerli

    Question SQL-BackUp

    Hello! Is it possible to create an automatic backup of the MySQL database? Problem what I currently have: I can not use the normal backup function. It creates a Backup of the website-files and databases in one backup. The websites are big and are stored on a extra hard drive. The System-drive...
  16. J

    Resolved MySQL 5.1 work in Plesk 12.5?

    What is the best version of MySQL to use? How to upgrade? Thanks. God bless you.
  17. Stan Ferguson-Smith

    Issue Error Installing WordPress - libmyodbc5.so not found

    Hi there, I am having an issue running the automated Application Installer for WordPress on my Plesk Onyx server, this is a VPS Server that is running: OS: CentOS 6.8 (Final)‬ Plesk: Version 17.0.17 Update #12, last updated on Jan 21, 2017 04:03 AM MySQL: 5.6.35 - MySQL Community Server (GPL)...
  18. K

    Question MySQL 5.5 configuration

    Hi, I'm using Plesk Onyx with MySQL 5.5.53 for hosting a news site based on wordpress with WP Super Cache on a dedicated server with 32GB RAM and 2x250GB SSD RAID1. Can you give some advice for my.cnf for best performance? I have this settings for now: join_buffer_size = 2M...
  19. S

    Issue Plesk won't let me add another mysql server on same server

    Hi Guys, I have Plesk Onyx on my server with 2 mysql instances (on port 3306 & 6645), but when i am trying to add 6645 DB server, It's not connecting to this new server on new port, instead it's connecting to default 3306 port & saying "access denied" due to wrong password. Is there any way to...
  20. B

    Question MariaDB my.cnf SQLSTATE[HY000] [2002]

    Could someone check my my.cnf please? What's wrong with it? Here is my default(original my.cnf that works) I'm trying to optimize DB for my VPS KVM OpenStack SLA 99.99 % 4 vCores 2,4 GHz 24 GB RAM 100 GB High Availability (Ceph) Thanks //IP:8443 returns
Back
Top