mysql

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

I just upgraded Plesk from 12.0.18 to 12.5. After which, I tried from the control panel to upgrade MySQL from 5.0 to 5.5. Now I can't login to Plesk control panel and am getting the following error: ERROR: PleskDBException: Unable to connect to database: mysql_connect(): No such file or...

I am trying to update my Plesk installation to the latest version, but it is tripping up on the PREP actions before actually proceeding to update. Here is the error that is repeated a few times: ERROR while trying to execute SQL query, the query was: ALTER TABLE `avstatistics` ADD KEY...

Hi, have that same stupid Error again and again. In the Morning (always at 6:30 am) Plesk / Mysql goes down with following Error: "ERROR: PleskDBException: Unable to connect to database: mysql_connect(): No such file or directory (Error code: 2002) (Abstract.php:69)" What can i do? And if i...

when i try to install a new app in plesk webfrontend of any(doesnt matter) user i got this error. i remember i had it before and misleadingly i remember after hours of searching not barely finding some infos about it i thought i solved this. somehow new updates broke this before going back deep...

Plesk version - 11.5.30 CentOS 5 115131216.11 Error while accessing Plesk - ERROR: PleskMainDBException: MySQL query failed: Table 'psa.misc' doesn't exist (db.php:102) # rpm -qa|grep mysql mysql-5.0.95-5.el5_9 php53-mysql-5.3.3-22.el5_10 mysql-server-5.0.95-5.el5_9...

Hi, i get a error when i open the Database list. --> https://localhost:8443/smb/database/list ERROR: Call to a member function getApplicationContext() on null (Databases.php:105) Search for related Knowledge Base articles Thanks, Daniel