mysql

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

As i got a Nextcloud instance running and since Version 15 NC is given me the following Advice to suport emojis in chat and so: Enabling MySQL 4-byte support — Nextcloud 15 Administration Manual 15 documentation i wonder how can i make it work. i dont know much about mysql and mainly use my...

I took over maintenance on a server and not sure why, but db servers are screwed up. Plesk won't auto-update, I've tried doing the rpm update via: rpm -Uvh --nodeps...

Plesk 17.5.3 MySQL 3306 instance db server is no longer showing up in the UI... not under Tools and Settings > database servers. Nor under customer subscriptions for adding adding databases. If I try to add the db server, I get a message that it is already registered. When I look in psa under...

Currently my mySQL dumps have been taking up so much disk space on my server. How do I disable the backups or limit them to only a few days? Example 1.4G: /var/lib/psa/dumps/mysql.daily.dump.0.gz

A few days ago I've changed my Plesk and server root password. After this I've had problem connection to the database after server restart. So I used the Plesk MySQL reset password script. All works fine, I can login and the database is also still accessable from the frontend. But today I've got...

I'm working on a CakePHP project which requires the db connected to plesk remote mysql server. If I use below db configuration example 'port' => '3306', 'host' => 'xxx.xxx.xxx.xxx', 'username' => 'usernmae', 'password' => 'pass', 'database' => 'db', When I run the app getting mysql error...

Hi at all, Could someone please tell me what [email protected] is about and whether status disabled is an error or not? I was not able to find any information on Internet about this service with "@"-char. But I changed open_files_limit to infinity. That's why I came to this topic above. ~#...

Currently I have installed software in /opt directory. That application needs MySQL. I made a database with Plesk, and the software specifies it. I can not access the database if I specify "localhost:3306" in the setting with that software. I seem to be able to access the DB by designating it as...

How to enable remote access to MySQL service on Plesk server I applied this article. A very useful article. Plesk my database settings also: "Allow remote connections from any host" but can not connect. My operating system is Centos 7 and I have a firewall (firewall-cmd). What should I do to...

Happy Holidays. So, I wanted to use Chrismas to switch my community mysql to percona server. I googled and found: Does Plesk support Percona database server? and a couple of non PLESK specific tutorials stating "Just switch the binaries and it should run like before". Well, it didn't...

I'm working on a CakePHP project which requires the db connected to plesk remote mysql server. If I use below db configuration example 'port' => '3306', 'host' => 'xxx.xxx.xxx.xxx', 'username' => 'usernmae', 'password' => 'pass', 'database' => 'db', When I run the app...

How can I access my mysql server within plesk from within my docker container. I have an asp.net core website that I am trying to connect to a MYSQL database that is hosted outside the container. I try and connect within my container to localhost:3306 and get an error that there are no servers...

Hello guys, we need your help. We can not access plesk. Server Error 500 Zend_Db_Adapter_Exception SQLSTATE[HY000] [2002] No such file or directory Type Zend_Db_Adapter_Exception Message SQLSTATE[HY000] [2002] No such file or directory File Abstract.php Line 144 But plesk repair does not...

Hi all - simpleton question for you all today. I've got a customer that wants to run their Laravel framework based site on my Plesk Onyx install. I'm reasonably savvy, but lack the knowledge on how to implement or pre-configure some of their requests. Links to idiot-guides appreciated! They...

I have gotten this three days in a row. The only way to get my server back is to restart it. Any suggestions? Server Error 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/tmp/#sql_40a_0.MAI' (Errcode: 24 "Too many open...

This morning I went to my server to do some work and now I cannot load it or any of my websites. I just started to use Plesk again after a few years and bang, here we go again! Issues. I get Server Error 500 Zend_Db_Adapter_Exception anyone have any idea how I can get my server back up...

Hello, I'm making an application for Plesk. I have the APP-META.xml file configured and the files are copied and installed correctly. I need to create a mysql database automatically, but it does not work for me .. I have read in the documentation that I must do it from an xml with this format...