mysql

Hi, anyone know how to solve this? I'm missing a few MySQL users after using the Plesk Migration tool to migrate from an old server to a new server. Both using Plesk. I see all the databases migrated to new server, but not all the users. Thanks!

Trying to open port 3306 for MYSQL remote access. Similar to this: Resolved - Cannot connect to database remote but on our server the firewall is not running. Centos 7 systemctl status firewalld ? firewalld.service - firewalld - dynamic firewall daemon Loaded: loaded...

Hello, I want to run a Magento site. Magento needs a later MYSQL than what is installed on my AWS Ubuntu 14.04 server. I tried the answer here: Question - MySQL Upgrade 5.1 to 5.6 or 5.7? but it removes plesk, and all such programs :O. I need to upgrade MYSQL-core. Tutorials say to do a dump...

Hello, good day, sorry but I'm a bit newbie here, after trying to update mysql (on ubuntu 14.04.5 LTS) using as reference the documentation of you on this page Cómo actualizar MySQL 5.5 a 5.6/5.7 en Linux I get some issues related to broken dependencies, the terminal showed that tried to...

Hello Developers and Community, I can unfortunately the forum tool CBACK from Germany not with MariaDB 5.5 operate. Therefore I wanted to upgrade to MariaDB 10.x. MariaDB 10.x I have now installed by command line, but it can not upgrade to Plesk. How can I get all MySQL databases on MariaDB...

In Plesk Onyx is it possible to edit php.ini and Mysql through the admin interface?

I want to set a Cron job to optimise all my databases, so i tried running this command from a Scheduled Task: mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` --auto-repair --optimize --verbose --all-databases But it always throws an error: Task "mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow`...

Hi I'm new to this forum. Just turned from cPanel to Plesk and I'm loving it. Anyway, I managed to Install Onyx on CentOS7 with no problem and the forum really helped. I was trying to secure my installation so I did not know Plesk changed root to admin so I updated admin user's password and my...

OS: Ubuntu 14.04.5 LTS Product: Plesk Onyx 17.5.3 Update #14 , last updated at July 23, 2017 08:33 PM I managed to get Health Monitoring installed on Plesk. Noticed MySQL memory usage is very high. How can I determine what is causing this? I limited memory usage on each domain but still see the...

Plesk version: Plesk Onyx 17.0.17 Update #29 Is it possible to limit and monitor resources for individual domains? Noticed some domains are using more resources than other domains and causes my server resources to be depleted. I want to limit each individual domain if possible? Does Plesk have...

Hello Community and Pleskians! I have an upgrade problem from Plesk Onyx to the new version 17.5.3. It is on the psa-php5-configruator and related to php-mysql. When upgrading from Plesk I have these lines that are displayed. Installation started in background Loaded plugins: fastestmirror...

Hi, I want to add a custom action to all jails, this action calls a script that writes the ban info to mysql. When i run my script directly from the console, it works fine. But it does not get called with the actionban... First some info: Plesk 17.5.3 CentOS 7 Fail2Ban v0.9.6 MariaDB 5.5.52...

Hi guys, by connecting plesk i got this error, where should I start my search? ERROR: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Connection refused' in /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0...

Hi all, I tried to run "mysql_secure_installation" command on my server where Onyx is running but I always get login error because the Onyx default db user is admin and not root: I also tried to run: "mysql_secure_installation -uadmin" but with no success. Can anyone help me on this and tell...

Hello, I was creating users in MySQL server, as i dont know the "admin" password i tried update the password. Onces I updated i got this error message: I was performing some of the KB solutions but could not be able to fix it, i create a ticket because maybe you have faced this situation...

Hi, I can't find here on forum similar question. I need to have open port 3306 for all IPs. Is it possible somehow to protect mysql authentification with Fail2Ban? I found that enabling general log can slow server, but also I saw that is possible to enable only "log_warnings = 2", Is someone...

Hi, two days ago I made a terrible mistake by removing some packages with dependencies to Plesk. So I had to restore from a backup. But unfortunately this fails and MySql wont start. So Plesk isn't staring as well. My service is hosted by STRATO and the guys told me that when I'm using their...

Hi, I am using Plesk Onyx v17.0.17 on CentOS 7 and I am quite new to command line but I need a few configurations done: 1) My MySQL is showing 5.5 and I would like to upgrade it to 5.6. I wasn't able to following the instructions here because I have no idea how to point "4. Add MariaDB...

I would like to know how to optimize the configuration in order to increase performance especially with regard to database requests. The server at my disposal is as follows: Server OVH Enterprise SP-32 Linux Plesk 12.5 (Cent OS 7) Intel(R) Xeon(R) CPU E3-1231 v3 @ 3.40GHz – Core: 8 32 GB RAM...

Hello, I've got a problem on my plesk panel. Actually, everything works well (all my websites are running) but I cannot manage my database server from plesk. Plesk tell me that it cannot connect to the server. In addition, when I try to create a new user on this database, i've got this message...