mysql

Hello to every In my server DEBIAN 10 after reboot the server crash the MariaDB 10.3 and i cant repair. when i try plesk repair db the console return DB query failed: SQLSTATE[HY000] [2002] No such file or directory exit status 1 in prints i see some error but cant repair. So...

Hi, after updating Plesk to the latest version and updating MariaDB to version 10.5, I am no longer able to enable remote access to the Database from the plesk interface. Practically when I check the appropriate check, plesk confirms the correct saving but if I return to the settings, I find the...

Hello I would like consult simple way to restore single database from .myd and .frm files. The situation is I have several webs and databases on Centos. I accidentally deleted the database for one site. I have centos disk backup some days old. So I recreate the mysql database and simple copied...

Hello guys, how are you? I woke up today and suddenly saw this on my plesk admin panel Type Plesk\Exception\Database Message DB query failed: SQLSTATE[HY000] [2002] Connection refused File Mysql.php Line 64 I ran the command echo "d /var/run/mariadb 0755 mysql mysql -" >>...

I went through all the threads with the same type of issue but could not solve my problem. When try to access Plesk I get : "Server Error 500 Zend_Db_Adapter_Exception SQLSTATE[HY000] [2002] No such file or directory Abstract.php line 144" Here are the different outputs: Job for...

Hi Everyone, I am trying to connect to the build in MySQL server of Plesk from a Docker container. But i get the following messages: I am able to login to the MySQL server with that user from other networks even external exept from within the docker container. The user also has '%' access...

Hi, I´m a little confuse with memory uses, my server have very high Memory use but have very low process, ¿is it a normal situation? Server config: Ubuntu ‪Ubuntu 18.04.5 LTS Maria 1:10.2.36+maria~bionic Php-fpm 7.3 2 cores 8 ram 1 site wordpress 1 site magento 2.3.6 My.cnf: # MariaDB...

I started to use Plesk panel on Linux vds and getting this error when I am trying to load data. Collect folder permission is 777. I don't know how can I solve it. LOAD DATA INFILE '/var/www/vhosts/folder/httpdocs/modules/admin/collect/collect_4588ov1qidu.csv' INTO TABLE messages FIELDS...

Hello, I would like to request your help regarding memory usage, could not find any relevant things about what i encounter. I recently did some performance tuning on MySQL in order to lower its memory usage Server specifications : OS : Debian 9.13 Plesk version : Plesk Obsidian Version...

Hello people, i am running Plesk Obsidian 18.0.30.1 and yesterday afternoon i have performed a dist-upgrade to Ubuntu 20.04 through SSH. During the upgrade a mysql-server-8.0 package has been installed and after having fixed some configuration issues given by the strict mode i have succesfully...

Hi guys, I manually intervened to update my database. I followed the necessary steps through Putty and first upgraded from 5.1 to 5.5. Then I increased from 5.5 to 5.6 and finally from 5.6 to 5.7. But currently plesk is not working on my server. Only .frm, .myi and myd files of my database...

Hi, I am using a webhost in order to keep track of some user information (just a test at this point) using MySQL and PHP. I have created a (actually several) user in order to connect to my database, and this entire process used to worked fine until a few weeks ago, but now I encounter PHP Error...

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