mysql

I lost painel access after change mysql directory, I did all mysql's socket configurations, but the issue persist

Hello, Since a week ago there seems to be an issue with my backups on one of my servers The backup is incomplete with a bunch of these same message. I looked up the error and found some topics on ehre but none of the solutions seem to work for me. I attached my 50-server.cnf and the my.cnf are...

Hi, after upgrading plesk to 18.0.50, it looks like the database support isn't working anymore or there is a gui problem. Product version: Plesk Obsidian 18.0.50.0 OS version: AlmaLinux 9.1 x86_64 Database version: 10.5.16-2.e19_0 plesk repair mysql Checking MySQL database servers...

Hello, Ive stumbled on a problem that is quite urgent. I was working on grafana when plesk on my server went down (plesk panel unreachable due to database error). The last change i made was 2 days before that and all i did was change the bind adress in my.cnf to :: After some troubleshooting i...

Hello, We are developing an extension for Plesk in PHP and we have need of interacting with WordPress databases on Customer domains. On Linux, we have been using the pm_Bootstrap::getDbAdapter() to make all of our requests using PDO. On Windows, however, the adapter could not interact with the...

Hello, I would like to connect my plesk database to our Grafana panel as a data source to read out some data. Where do i find the database connection info of the main database of the Plesk server? Any help would be appriciated. Kind Regards, Quinten

I run a fully dedicated Ubunto 20.04 server and a forum with around 60-70 members on-line daily (*not* all at once, but still a fair amount of constant activity). I'm looking to optimize my PHP FPM settings. Here's my server: Intel(R) Xeon(R) CPU E3-1230 v3 @ 3.30GHz (8 core(s), 32GB RAM...

I can not login to Plesk with username: root and provided password. Below error is what I get. Type Plesk\Exception\Database Message DB query failed: SQLSTATE[HY000] [2002] No such file or directory File Mysql.php Line 79 plesk -v is giving me: root@sharp-johnson:~# plesk -v...

We have a problem on updating data in database. We try to use the same database and same code on localhost, it works fine but when we try to update using the server the data cannot update. Have anyone encounter this kind of problem? Usually if this kind of problem happen what should we check...

I have a server running CentOS 6.10 Plesk Obsidian Version 18.0.31 Update 3. I want to migrate all subscriptions to another Server running Ubuntu 20.04.5 Plesk Obsidian Version 18.0.46 Update 2. The problem is that when I give new migration, when trying to connect to the CentOS server, I get...

I am sure I saw the ability to restart MySQL/MariaDB in the Services Management before but I looked today when I need to restart MySQL and could not find it. I check some other plesk servers we have and found that it is the same on all of them. I am not sure if maybe I missed it somewhere or...

Hello, my experience is that most of the problems with inaccessible webs on a Plesk system are related to the MySQL server. Especially on VPS or cloud servers that can be scaled, the MySQL server does not adapt to the requirements. It could use much more RAM, but it doesn't. I had to manually...

Hi, on one of our servers the option "Allow local MYSQL server to accept external connections" is missing from the plesk menu (Tools&Settings->Database Servers). See screenshot attached. (It is present on all other installations). I already ran "plesk repair all -y" but no errors were detected...

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

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

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

Hello all, I am trying to create a database server. But I get a server error. SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES) The database can then be seen in the overview. When I try to add a database I get this message: Error: No database servers are...

Hello, Ubuntu 20.04.4 LTS Plesk Obsidian Version 18.0.41 1, I installed Docker with mysql5.7 on Port 3308 I gave a password for MYSQL_ROOT_PASSWORD 2, I added Database-Server 3, I added a Database, select the Database-Server on Port 3308 (mysql5.7) Create a new Database user with...

Hello, All updates succeeded except these 6 in the attached pic. Been several months now. Can somebody who encountered same issues, Please tell us what to do here? Meaning The detailed Steps to get it solved? We're not Plesk users, but trying to get used to it. We've reached support, but was...

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?