mysql

Morning guys, CentOS 7.4 - Plesk Onyx 17.5.3 After trying to fix an issue last night I ended up restoring a snapshot on the server which has led to a new issue. I've SSH'd and done df -h. Disk is showing 106GB used. This is correct so I know the disk contents is still there but...Plesk login...

Hi, what are you using on yours servers, MariaDB or MySQL and why?

Hi I have a dedicated mysql server to host the clients' databases. I have the need to turn off this dedicated server. In order to do this, I need to migrate the databases that are on this dedicated server to the server where plesk is installed. How should I proceed? Thank you

Hey Guys, i want to ask how i can connect to the server's database with my .net Application. I used the MYSQL data.dll but it keeps showing me timeouts

When Plesk Migrator has to rename a MySQL user during migration due to a conflict, showing this warning message in the log: MySQL database user with the name 'wordpress_0' already exists on target server. Database user 'wordpress_0' from the source server will be renamed to 'wordpress_02' on...

As the thread title says really but we can't We suspect this MAY be linked back to the MySql / Maria DB setup... We want to ensure that if/when on the rare occasions that Roundcube is used, it's via https only. Post_#6 in that previous thread clearly explains how to do this. However, in our...

Hi, i've this version plesk 17.5.3 patch #26 installed on a centos 7.4.1708 and this morning i've realized that mariadb service is down because of this : Oct 24 11:01:50 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:50 139851548907648 [Note] InnoDB: Starting shutdown... Oct 24 11:01:51...

Hi, this is my first post on this forum. I have searched related info on How to upgrade client MySQL from 5.1 to 5.6 on Windows It says I can use "plesk installer" to finish this upgrade. Now I have three mysql databases(version 5.1) linked with three websites. I want to know the following...

So I have this error: [unixODBC][Driver Manager]Can't open lib '/usr/lib64/libmyodbc5.so' : file not found and I am aware of the suggestions / solutions provided here: Unable to access Application Vault: Can't open lib '/usr/lib64/libmyodbc5.so' : file not found but still I am not getting it...

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