• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

mysql

  1. 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)...
  2. 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...
  3. 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...
  4. 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
  5. 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...
  6. A

    Resolved Mysql Failed to set up SSL

    Hi, I Have this error in a new server: [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key Ubuntu: 16.04 Mysql: 5.7.16-0ubuntu0.16.04.1 Plesk 17.0.17 #5
  7. Kingsley

    Resolved Mariadb 10.1 on ubuntu 16.04

    Hello; I am trying to replace MYSQL 5.7 with MARIADB 10.1 on ubuntu 16.04. i tried with @Lloyd_mcse guide for ubuntu 14.04 which can be found here. The installation was successfully but am unable to access plesk admin area. i got the following error ERROR: Zend_Db_Adapter_Exception...
  8. futureweb

    Issue BUG: Special Chars in Username + Database creation = Failure

    Hey there, I found a little Bug regarding DB creation. Tested on PPS12.5.30#47. Database Hosting Preferences: Add prefix and underscore to the beginning of database names - Username - Add username and underscore to the beginning of database user names. Create a new Subsc./Hosting with Username...
  9. R

    Issue Update or not an Update

    Well, my system seems to be very confused... On one hand he says I'm on Version: 12.5.30 Update Nr. 27, which he calls up to date... While on the other Hand, there is a big red attention box on top of my dashboard which says that "the update" failed, including links to the 2 last attempts, who...
  10. Enverex

    Issue Why is Plesk messing with the server's valid MySQL configuration?

    As of a week or two ago, we have noticed that Plesk is now adding lines to the MySQL configuration on setup which breaks MySQL. The line specifically is "bind-address = ::" which is added to /etc/my.cnf. If the "[mysqld]" section doesn't exist in this file already then Plesk creates it...
  11. T

    Issue Plesk and WordPress table names

    Hi I've recently started using Plesk to create WordPress websites and I have come across 2 problems with the table name prefixes 1. Plesk ignores the value I put in and creates a random string of letters 2. The random string of letters is mixed upper & lower case. MySQL recommends that table...
  12. R

    Issue [PPPM-4734] wrong DB selected in phpMyAdmin side panel

    When I open phpMyAdmin from Plesk, the side panel in phpMyAdmin (showing the tables as a tree structure) does not show the correct database. Clicking the "Open" button for database named "adler" gives me this window in phpMyAdmin. Notice the wrong database in the side panel. The same...
  13. N

    Resolved MariaDB 10.1

    Hello, I am trying to install MariaDB 10.1 using Plesk's Instructions and MariaDB repos however it just keeps failing for me, Install logs: root@host:~# env DEBIAN_FRONTEND=noninteractive apt-get -o OrderList::Score::Immediate=1000 install mariadb-server mysql-common libmariadbclient18 Reading...
  14. Lechiguero

    MySQL and PostgreSQL

    Hi folks, recently install Plesk on my server. It works pretty well :) I ran into this problem when trying to use PostgreSQL as it appears in section as installed updates, but in the creation of databases does not appear. As seen only you can select MySQL. I have to reinstall PostgreSQL...
  15. M

    No Plesk/Databases/MySQL51/ folder , which mysql.exe should be used to query databases

    i bought a windows server from godaddy, and it comes preinstalled with plesk 12.5, i want to use MySQL CLI, checked google and searched forums , found that /Plesk/Databases/MySQL51/bin/mysql.exe should be used, but in my case, in /Plesk/Databases/ there is no MySQL51 folder, instead only...
  16. A

    Error: Connection to the database server failed: Operation CREATE USER failed for

    I'm experiencing this issue when creating a mysql database and user together, or when adding a user to a database: Error: Connection to the database server failed: Operation CREATE USER failed for 'db-user-name'@'localhost' Probably related, if I try; plesk repair mysql from ssh, I get errors...
  17. J

    There are limits of Plesk or MySQL that my website can be reached?

    I have a site of questions and answers with over 800,000 posts. A few months ago, my site was unavailable for having reached the limit of using PHP. I discovered that this was the problem and changed the limit. The site was work. But I wonder if there are other limits that possibly my website...
  18. websavers

    Additional MySQL User Permissions for Magento compatibility

    Magento 2.0 now requires MySQL 5.6 or higher and a bunch of MySQL User capabilities that Plesk currently does not assign to MySQL users. I know that Plesk simply uses the system installed MySQL server, so upgrades to that are beyond Plesk's purview. As a result of this we set up two dedicated...
  19. B

    Resolved ERROR: Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 23 Out of resources when open...

    Hello, I have a big problem. My plesk don't stop to crash. Completely random . Usually, once per day. When I try to connected me to my plesk, this error : ERROR: Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/tmp/....' (Errcode: 24 "Too many...
  20. S

    Updating PHP and MySQL in CentOS 6.5 and Plesk 12.5.30

    Hi, I have a server with CentOS 6.5 and Plesk 12.5.30 installed. I found out that the PHP version of the server is 5.3.3 and the MySQL version is 5.1.73. Both versions are very old and I would like to update to newer ones, but I'm not sure how to do it correctly. I don't want to break anything...
Back
Top