mysql

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

How to setup mysql my.cnf to accept both uppercase and lowercase tables. Environment: Os: Ubuntu 14.04 TLS Mysql Server: App Server: Weblogic Server 12.2.1 (Only uppercase tables are accepted) Plesk: 12.0.8 (Only lowercase tables are accepted) I try lower_case_table_names=2 #(default value...

(Plesk Onyx 17.8.11) I have a domain and a database connected to it. I have set the settings to 'Allow remote connections from any host' and created a user. When I try to connect to it from an external programm (datagrip) it gives this error: (database and host.com are the databasename and the...

Hello, starting 3 days ago the updates are failing with this error yum-errors - CentOS Wiki If above article doesn't help to resolve this issue please use My View - CentOS Bug Tracker. epel/x86_64/updateinfo | 938 kB 00:00 remi-safe/primary_db...

Using Plesk Version 17.8.11. Mysql has some nice real time encryption/decryption (aes_encrypt/aes_decrypt) possibilities that others like libsodium dont have at the moment. On earlier versions mysql was build with ECB mode as onliest option. Since version 5.6.17 its possible to use other modes...

I am following the guide here: How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.0/10.1/10.2 on Linux when I get to the step # yum update mysql I get this output: Loaded plugins: fastestmirror Setting up Update Process Loading mirror speeds from cached hostfile * base...

Hallo, I'm wondering how to change mysql version to version 5.7 in plesk 17.8.11. At "Tools & Settings > Applications & Databases > Database Servers" MySQL Version 10.1.29 is shown - I think this version cannot be correct; maybe it's the MariaDB version. In a software running on this server...

Hi all, I am attempting to update MySQL on my Plesk server from 5.5 to 5.6. I have followed the guide here and initially run into the problem outlined here. Unfortunately the latter does not seem to have resolved the issue, in trying to update to 5.6. Can anyone of you kind people please...

Hello Plesk! I accidently deleted plesk and its dependencies to reinstall mysql through grep on Debian 8 (jessie) Now, I see no fix to get it back working as apache is down apt-get update doesn't work. I tried changing sources.list but it doesn't work either. I tried ./plesk-installer and...

Hi, recently the health monitoring on our server has started larting us to high MySQL CPU and Memory usage (it;s beeing getting over 20%). Howveer when I check 'SHOW PROCESSLIST' there is almost always less than 10 process runnig and other than the admion 'Sleep' commands, ther eother have...