mysql

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?

Hello, my System: Ubuntu 20.04.4 LTS Plesk Obsidian Version 18.0.41 After the Upgrade from Ubuntu 18 to Unbuntu 20 Plesk has as default sql engine: Server-Version: 10.3.32-MariaDB-0ubuntu0.20.04.1 - Ubuntu 20.04 I have to switch to Mysql 5 or Mysql 8. I saw, that Obsidian supports Mysql 8...

Hello all ! I upgrade to 18.0.41, all seems goods until yesterday, in plesk admin i clean some old database, but after a while il can't connect anymore : from admin panel DB query failed: SQLSTATE[HY000] [2002] No such file or directory if i do : plesk repair installation i got Warning...

Hello , I have a issue with mysql performance , mysql cpu time multiplied by x3 , this started suddenly. I didn't changed any config , didnt update server , it just started suddenly. My server with problem is 32 core . I have lot of free ram. For test purposes I added 1000 row to empty...

Last month my server crashed because I ran out of MySQL memory, I run a video streaming site that usually runs up to 7 SQL queries per watched-video, but in the last few weeks I have optimised my queries and used memcached to cache every video so that now only 2 queries are run per...

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

Hello Pleskians, I know that i can backup the whole website, including the webroot and DB and i can restore as well when i want. I can also export dumps on the server as well as on my local machine. What i want is that, when i export the DB dumps, It should also store to a remote location. Is...

running the command to restore ab DB backup brings me to this: zcat mysql.daily.dump.8.gz | plesk db ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 104 exit status 1

Hi everyone recently facing a big issue with the MySQL service, MySQL service use more than 11 cores. Anyone please how can I resolve the issue?

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

Failed to copy content of database 'move3afs_wp' Migration tools tried to perform operation in 1 attempts: Restoration of MySQL database failed. Most probable reason: Target MySQL server does not contain necessary character set. Most likely it is required to have at least MySQL 5.5 to restore...