• 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. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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']...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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.
  16. 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)...
  17. 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...
  18. 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...
  19. 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
  20. N

    Issue Remote connection for mysql database impossible

    Hi, i try to remote my mysql database but connection is refused systematicly... I've add user with authorized remote from any host Same for mysql server... I've commented this line bind-address = ::ffff:127.0.0.1 and...
Back
Top