mysql

Hello, I intended to upgrade my Windows Onyx installation to Obsidian, but the the procedure stopped because the MySQL password is wrong (or does not match something?). I followed this procedure ERROR PleskMainDBException Access denied for user 'admin'@'localhost' (using password: YES) but I...

Hi there, I just received a new ubuntu 18.04 VPS to migrate to from my old ubuntu 16.04 VPS. I wanted to use the Plesk Migrator again, but received following issue in regards to databases and could not find any solution in this forum: Failed to copy content of database 'xxDB' Migration tools...

Hi, i am using Plesk Obsidian 18.0.20 on CentOS 7 and i recently updated my MariaDB from 5.x to 10.4 with SSH. And now i cant update my Plesk to 18.0.21. When i try it, i always get the "ERROR while trying to backup MySQL database" and the update stopps. Can someone help me please? best...

Hi, in a few words: Today I made the upgrade of MariaB from 10.3.19 (from 10.3.18). Two hours later I also made the libmariadb3 upgrade. During the upgrade the question came, if I want to replace the /etc/mysql/my.cnf. I hit D for showing the differences. After examination, I wanted to hit: Keep...

When using the Migration & Transfer Manager to transfer a Subscription, it is failing to transfer the database due to access being denied to the admin account. The error details are listed below (I am pretty certain the first 2 are not relevant but I have included them for completeness). I have...

Hi, i've plesk obsidian 18.0.19 installed on a centos 7 vps, today i've tried to browse a db with phpmyadmin but when i click on phpmyadmin i've that error : Messaggio di MySQL: Documentazione #1142 - SELECT command denied to user 'pma_9CCa0CBxiZwX'@'localhost' for table 'pma_column_info How...

Hello, please I would have a suggestion about a new next plesk installation, because I'm newbie. I explain my question. I've a server metal with 3 raid systems on it, 1 Raid-0 for the S.O. and 2 Raid-5 as storage. Is there a method to change the default MySQL path during the installation via...

Hello, First of all, many thanks for any reply. Im trying to connect with a desktop database software, so its a remote connection. I already configured in the dababase user the option "Allow remote connection from" and i put ther the domain whats resolve to the IP of pc client...

I'm full on my server and MariaDB crashes. I gave additional space and solved the capacity problem. However, MariaDB does not start. Why can't I start? Memory and space issues have been resolved. I used PleskRepair, but MariaDB does not respond. The following is the error content. ------- ●...

Hi everyone, I am running the latest Plesk on a Ubuntu server. I have a domain (domain.com) and a subdomain called api.domain.com I have installed a nodejs application for the api.domain.com via the interface and it is running and will return sample route return data as long as it is not...

Recently, I attempted to upgrade MySQL from version 5.5.55 to 5.6. In doing so, this has resulted in the Plesk Dashboard and Mail Server being inaccessible. Learning the hard way of doing updates in a Live Environment. Whilst I have manually backed up the Website's Web Files and MySQL...

Recently, I tried to upgrade MySQL from 5.5.55 to 5.6. Unfortunately, this failed. To the point that I cannot start MySQL back. I have included the MySQLd Log below, in case anyone is able to identify a solution for the problem. After posting questions on various Forums, no solutions have...

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