mysql

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

I recently uninstalled and reinstalled Roundcube on my Plesk 12.0.18 VPS, after screwing something up. But it doesn’t quite work yet. Instead of the Roundcube login screen, I get this error message: /var/log/plesk-roundcube/errors has, among other things, the error message "Table...

My hosts are trying to upgrade my managed server from Plesk 11.5 to Plesk 12.5, but they tell me it is failing with the following error messages, which they say is due to me "upgrading MySQL using the atomic repository". I have no idea what that means, I wouldn't know how to do it, but is there...