mysql

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

I am using Windows Server 2012 R2 and Plesk Onyx 17.8.11 How can I access to plesk database (not other user databases) I know that it works on port 8306. What is the username and password?

Does "mysqld.service" exist in Plesk (17.8.11)? At least it currently does not exist on my server. When asking a certain person, I was told that MariaDB should also have mysqld.service. mysqld.service does not exist because I am using Plesk? I installed a database search program from rpm. Then...