mysql

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

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