mysql

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

Hello, I upgraded to 12.5 from 12.0. All work well but in the new databases manager I can't see my databases. I can read "Here you can create new or manage existing databases." and under "add database" but it s empty. When I use phpMyAdmin I can see all my databases. I tried to use "plesk...