mysql

Hello guys, we just did a restart, after that we get error: "DB query failed: SQLSTATE[HY000] [2002] No such file or directory" We need your help very urgent. What can we do, we can not restart mariadb? No access to plesk an no access to the websites...

i have run my java services in plesk using SSh i have been trying to call it in my angular app (already deploy on plesk) but nor success i have used localhost to call the service but still not working

Hi, Where can I find daily DB dumps if the incremental backups are stored in a remote FTP server ? I can find it under /var/lib/psa/dumps/domains/website.com/databases/ when the incremental backups are stored locally. Once we switch to incremental + remote, I can no longer locate the DB...

Under certain circumstance I am having issues with the MySQL admin account and the problem is becoming more prevalent. The easiest way to produce the problem is by running plesk db at the command line – which gives the following ERROR 1045 (28000): Access denied for user 'admin'@'localhost'...

I've just updated Plesk Onyx to Plesk Obsidian, hoping it will update MySql version as well. Now I have MariaDB which shows as MySql 5.5.64 in https://domain.com:8443/plesk/server/db/ Here is the screenshot: https://tinyurl.com/u9hr4vo How can I update version to MariaDB 10.3, or at least...

Hello, I intended to upgrade my Windows Onyx installation to Obsidian, but the the procedure stopped because the MySQL password is wrong (or does not match something?). I followed this procedure ERROR PleskMainDBException Access denied for user 'admin'@'localhost' (using password: YES) but I...

Hi there, I just received a new ubuntu 18.04 VPS to migrate to from my old ubuntu 16.04 VPS. I wanted to use the Plesk Migrator again, but received following issue in regards to databases and could not find any solution in this forum: Failed to copy content of database 'xxDB' Migration tools...

Hi, i am using Plesk Obsidian 18.0.20 on CentOS 7 and i recently updated my MariaDB from 5.x to 10.4 with SSH. And now i cant update my Plesk to 18.0.21. When i try it, i always get the "ERROR while trying to backup MySQL database" and the update stopps. Can someone help me please? best...

Hi, in a few words: Today I made the upgrade of MariaB from 10.3.19 (from 10.3.18). Two hours later I also made the libmariadb3 upgrade. During the upgrade the question came, if I want to replace the /etc/mysql/my.cnf. I hit D for showing the differences. After examination, I wanted to hit: Keep...

When using the Migration & Transfer Manager to transfer a Subscription, it is failing to transfer the database due to access being denied to the admin account. The error details are listed below (I am pretty certain the first 2 are not relevant but I have included them for completeness). I have...

Hi, i've plesk obsidian 18.0.19 installed on a centos 7 vps, today i've tried to browse a db with phpmyadmin but when i click on phpmyadmin i've that error : Messaggio di MySQL: Documentazione #1142 - SELECT command denied to user 'pma_9CCa0CBxiZwX'@'localhost' for table 'pma_column_info How...

Hello, please I would have a suggestion about a new next plesk installation, because I'm newbie. I explain my question. I've a server metal with 3 raid systems on it, 1 Raid-0 for the S.O. and 2 Raid-5 as storage. Is there a method to change the default MySQL path during the installation via...

Hello, First of all, many thanks for any reply. Im trying to connect with a desktop database software, so its a remote connection. I already configured in the dababase user the option "Allow remote connection from" and i put ther the domain whats resolve to the IP of pc client...

I'm full on my server and MariaDB crashes. I gave additional space and solved the capacity problem. However, MariaDB does not start. Why can't I start? Memory and space issues have been resolved. I used PleskRepair, but MariaDB does not respond. The following is the error content. ------- ●...

Hi everyone, I am running the latest Plesk on a Ubuntu server. I have a domain (domain.com) and a subdomain called api.domain.com I have installed a nodejs application for the api.domain.com via the interface and it is running and will return sample route return data as long as it is not...

Recently, I attempted to upgrade MySQL from version 5.5.55 to 5.6. In doing so, this has resulted in the Plesk Dashboard and Mail Server being inaccessible. Learning the hard way of doing updates in a Live Environment. Whilst I have manually backed up the Website's Web Files and MySQL...

Recently, I tried to upgrade MySQL from 5.5.55 to 5.6. Unfortunately, this failed. To the point that I cannot start MySQL back. I have included the MySQLd Log below, in case anyone is able to identify a solution for the problem. After posting questions on various Forums, no solutions have...

Earlier, I attempting to upgrade my MySQL, from version 5.5.55 to 5.6, using the SSH Client 'PuTTY'. This being my first time, I decided to strictly follow this Plesk Article. I managed to reach step 10 within the 'Plesk on CentOS 6' drop down menu. As per the step, I then tried to start the...

I tried to restore a backup from remote storage (S3) then it filled up the server disk space and server crash. I removed plesk temporary files and restart the server. but the mysql database server refuse to start anymore. I can only start the mysql server using "innodb_force_recovery". May 27...

Hi all, I am trying to connect the MysqL server and the mail server through an ASP script, however it returns error. if I change the mysql.domain.com servers to localhost or address IP and mail.domain.com to localhost or address IP, it works perfect. Was there anything I could do to run the...