• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

mariadb

  1. G

    Resolved Crash after MariaDB 10.5.17 Update

    I have tried at my PLESK (Obsidian 18.0.46) to update my MariaDB-server version from 10.5.13 to 10.5.17 (via Plesk "System Updates" package upgrade) and during updating the connection to DB is lost and an PLESK Error page occurs with "Server Error: 500 Plesk\Exception\Database" with the message...
  2. Fester77NL

    Resolved PHPMyAdmin is not available

    Dear support, I have created a database in plesk. The database works well. Only I can't manage the database in phpmyadmin because it is not available. As you can see in the picture, there is no icon of phpmyadmin. I've already tried this, but it doesn't work: How to access phpMyAdmin shipped...
  3. Z

    Resolved Remote connection to database refused

    Hi, hope everyone is doing well I have a problem connecting remotely to a database on the server the connection is refused, so I guess I'm not using the correct info but I am not sure how is it possible since I got this info by going to Databases for that domain go to the needed database and...
  4. deantenea

    Issue Innodb Corruption

    Hello guys, I'm having an issue with a Plesk server. MySQL seems to be corrupted and won't restart, I cannot access the Plesk CP. Any help is very appreciated. Here is what i tried (but didn't work): [mysqld] innodb_force_recovery = 1 (tried from 1 to 6)...
  5. Z

    Resolved How to significantly upgrade MariaDB

    Hi, I'm currently running MariaDB 10.2.44 and I'm considering upgrading to 10.6.x. I would like to know how to upgrade. Can I upgrade from MariaDB 10.2 to 10.6 all at once? Or should I repeat the upgrade one by one like 10.2 to 10.3 and 10.3 to 10.4? Thanks,
  6. L. Hagen

    Question How to install MySQL 8 to replace MariaDB or as an additional local DB server

    Hi, unfortunatley my provider only offers Plesk with MariaSB. But I read in the documentation that Plesk is also able to run with MySQL 8. The question is now how? The only entries I can find is how to setup an a new DB Server in Plesk, but no documentation on HOW to install MySQL in parallel...
  7. wakabayashi

    Resolved MariaDB suddenly broken (CentOs7)

    Hello! Since yesterday our MariaDB is no more working on my Server. I haven't make any change at all. Plesk Login states: DB query failed: SQLSTATE[HY000] [2002] Connection refused When using the Repair Kit it states that MariaDB Service "stopped". Using "Restart Processes" button makes it to...
  8. VojinP

    Resolved Login as admin to mysql remotely

    I have dozens of databases on server and need to configure one by one in DataGrip to get access, and this works. Is there ANY way to configure remote access as admin and see all databases at once?
  9. P

    Question Removed default MariaDB Server

    Hi, this is my first few days with Plesk and love it. I have some quick questions about some things I have done. Plesk Obsidian Web Host Edition Version 18.0.41 Update #1 Microsoft Server 2022 VPS host is IONOS I removed the default MariaDB Server from the Database Servers list, with the...
  10. T

    Question Unable to update MariaDB-server

    Hello guys, since some weeks, my Plesk server said that there is an update about MariaDB-server 10.5.13-1.el7.centos. If I try to install it, the install seems to be OK but I still have that update to do. Is there anything I've to do more? I'm running Plesk Obsidian v18.0.39_build1800211014.23...
  11. W

    Resolved [SSH] Create Database User with SSH and deactivate remote access

    At the moment I am trying to create a database with SSH and an associated user. This user should only be available locally and not from outside. In the Plesk web panel under Database users, there is the setting "Only allow local connections". Is it possible to activate this via the command...
  12. B

    Resolved After update to 18.0.38 #2: DB query failed: SQLSTATE[HY000] [2002] Connection refused

    After the update to 18.0.38 #2: i can't login to Plesk and database connection on our sites is not possible. service mariadb restart Restarting mariadb (via systemctl): Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service"...
  13. B

    Question MariaDB 10.2 - Plesk Obsidian 18.0.37

    Will Plesk support MariaDB 10.2? And will there be an update in plesk ui, or even an automatic update or something like that? We use Plesk Obsidian 18.0.37 and still do just have Maria DB 10.1. With "PHP" Plesk has a great resolution, we can install different versions and each website can...
  14. Automata

    Question How to setup Ram Disk for MariaDB/MySQL Temp directory on Ubuntu 20.04.2 LTS with Plesk Obsidian v18.0.37 ?

    Hi, > SOFTWARE SPECIFICATION < Operating system: Ubuntu 20.04.2 LTS Plesk version: Plesk Obsidian v18.0.37_build1800210716.08 PHP version: 8.0.8 Web server type: NGINX only > HARDWARE SPECIFICATION < CPU: 1 x AMD Ryzen 7 3700X 8-Core Processor (16 thread) at 3600 MHz plus enabled auto...
  15. cloudbridge

    Resolved MariaDB setup on DOCKER via PLESK

    Hello, maybe someone had also problem when mariaDB is setup on Docker via PLESK that new generated user can't login to database? Tried to create fresh install of wordpress to test it but got error, so any help would be appreciated, thanks! Also I can access mariadb phpmyadmin with root...
  16. G

    Question How to swap MariaDB 5.7 for Percona 5.7/8.0 on Ubuntu 20.04

    I have a completely fresh VPS running Ubuntu 20.04 and Plesk Obsidian 18.0.33 that I am trying to replace the pre-installed MariaDB 57 with either Percona 5.7 or Percona 8.0. The documentation here says this is "supported", but all itshow is what looks to be an old how-to on replacing MySql 5.5...
  17. P

    Issue Connect to Azure MariaDB via SSL

    I'm new to Plesk but not web infrastructure. I'm trying to setup Azure Database for MariaDB as the default Database in Plesk Obsidian for Linux. For what I hope are obvious reason, I want to enforce SSL connections to the MariaDB DaaS. However when trying to connect from Plesk, I'm rebutted...
  18. H

    Issue Upgrade MariaDB

    Hi there. I have just taken out a new server running MariaDB 10.3.17 on Plesk Obsidian Version 18.0.30 Update #2 One of my new websites is going to use the new version of Magento that lists MariaDB 10.4 as a requirement so I have followed this guide to upgrade to MariaDB 10.4:  How to upgrade...
  19. M

    Issue Troubles with DB Mysql/MariaDB after Ubuntu upgrade

    Hello people, i am running Plesk Obsidian 18.0.30.1 and yesterday afternoon i have performed a dist-upgrade to Ubuntu 20.04 through SSH. During the upgrade a mysql-server-8.0 package has been installed and after having fixed some configuration issues given by the strict mode i have succesfully...
  20. yigitvp

    Resolved DB query failed: SQLSTATE[HY000] [2002] No such file or directory

    i got this error while updating the database I tried many things but could not solve Type Plesk\Exception\Database Message DB query failed: SQLSTATE[HY000] [2002] No such file or directory File Mysql.php Line 64
Back
Top