• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

mysql

  1. F

    Resolved [SSH] Create Database User with SSH and deactivate remote access

    At the moment I am trying to create a database with SSH and an associated user. This user should only be available locally and not from outside. In the Plesk web panel under Database users, there is the setting "Only allow local connections". Is it possible to activate this via the command...
  2. H

    Question Export DB Dumps on remote server

    Hello Pleskians, I know that i can backup the whole website, including the webroot and DB and i can restore as well when i want. I can also export dumps on the server as well as on my local machine. What i want is that, when i export the DB dumps, It should also store to a remote location. Is...
  3. B

    Issue ERROR 2013(HY000) Lost connection to MySQL server when trying to load a db backup

    running the command to restore ab DB backup brings me to this: zcat mysql.daily.dump.8.gz | plesk db ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 104 exit status 1
  4. R

    Issue mysql High CPU usage

    Hi everyone recently facing a big issue with the MySQL service, MySQL service use more than 11 cores. Anyone please how can I resolve the issue?
  5. Automata

    Question How to setup Ram Disk for MariaDB/MySQL Temp directory on Ubuntu 20.04.2 LTS with Plesk Obsidian v18.0.37 ?

    Hi, > SOFTWARE SPECIFICATION < Operating system: Ubuntu 20.04.2 LTS Plesk version: Plesk Obsidian v18.0.37_build1800210716.08 PHP version: 8.0.8 Web server type: NGINX only > HARDWARE SPECIFICATION < CPU: 1 x AMD Ryzen 7 3700X 8-Core Processor (16 thread) at 3600 MHz plus enabled auto...
    • Automata
    • Thread
    • mariadb mysql nvme optimization plesk obsidian 18.0.37 ram disk speed tmp tmpfs ubuntu 20.04.2
    • Replies: 6
    • Forum: Plesk Obsidian for Linux
  6. E

    Issue ERROR 1273 (HY000) utf8mb4_unicode_520_ci

    Failed to copy content of database 'move3afs_wp' Migration tools tried to perform operation in 1 attempts: Restoration of MySQL database failed. Most probable reason: Target MySQL server does not contain necessary character set. Most likely it is required to have at least MySQL 5.5 to restore...
  7. BrinsleyP

    Issue Broken after reboot

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

    Issue External database access problem

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

    Resolved How restore database from frm and myd files

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

    Resolved 500 Plesk\Exception\Database

    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 -" >>...
  11. Mike23

    Resolved Server Error 500 Zend_Db_Adapter_Exception SQLSTATE[HY000] [2002] No such file or directory

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

    Issue Access Mysql from Docker

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

    Issue Very high Memory high use and very low process

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

    Issue LOAD DATA INFILE Can't get stat of (Errcode: 13)

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

    Question Memory usage after backup

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

    Issue Troubles with DB Mysql/MariaDB after Ubuntu upgrade

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

    Issue Mysql server update (5.5 to 5.7)

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

    Question PHP throws error when connecting to MySQL: access denied

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

    Issue URGENT: DB query failed: SQLSTATE[HY000] [2002] No such file or directory

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

    Question how to deploy my angular app with java services?

    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
Back
Top