mysql 5.7

I have a Windows-Server that uses Plesk-Obsidian/Mail-Enable and MySQL 5.7. I realize Plesk does not yet fully support MySQL 8.0 on Windows. (and may never?!) But I wish to upgrade anyway. The server is 2016 Server. I need to know the gotchas to watch-out for... and the things that I need to...

Hi guys, I manually intervened to update my database. I followed the necessary steps through Putty and first upgraded from 5.1 to 5.5. Then I increased from 5.5 to 5.6 and finally from 5.6 to 5.7. But currently plesk is not working on my server. Only .frm, .myi and myd files of my database...

I own a Plesk (reseller) license as part of major web company's hosting services, so the Plesk support system doesn't allow me to file tickets. I'm hoping to get an official response and resolution on this issue. Upgrade history: I previously upgraded MySQL from 5.0 to 5.5 using Plesk 12.5's...

This post provides the following login string: # mysql -uadmin -p'cat /etc/psa/.psa.shadow.' Entering this gives: Access denied for user 'admin'@'localhost' (using password: YES) With MySQL -u root -p I get a password prompt but the same Access denied message. What am I doing wrong? Thanks.

When you run the MySQL Installation Wizard, you can choose between different configuration types; - Developer (for limited resource usage) - Server (optimized) - Dedicated (uses all available resources) How does Plesk install MySQL? Is it possible to change the configuration type afterwards?

Hi, I have a problem for a couple of days with mysql (5.7) and innodb tables, I try to explain: I have a main database (dbDeveloping) and a series of databases in production (db1Production, db2Production, ...), when I modify the structure of some tables in "db1Developing", through a php script...

hello my server have 32 core and 256 gig ram but dont use more than 10-gig of ram and also load in often under 5 but site have delay on loading... some time the delay is up to 10-15 seconds is there a way to find best config for mysql and apache(nginx) memory and connection for a better...

I have: Ubuntu 16.04.5 LTS‬ Produkt Plesk Onyx Version 17.8.11 Update #17 MySQl 5.7.23 In the /var/log/plesk/modules/wdcollect.log I found the error: Failed to connect to database server: SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES) This error occures...

Hello, I'm trying to update Plesk Onyx 17.0.17 to Update #53 is available. or "Upgrade to Plesk Onyx 17.8.11 is available." But am having some problems. All Packages are up to date, websites etc are running fine, but I think something with the mySQL configuration is breaking the update. "...

Hi at all, I want to optimize my MySQL database for example InnoDB Buffer Pool Size. Therefor I performed this test: mysql> SELECT CONCAT(ROUND(KBS/POWER(1024, -> IF(PowerOf1024<0,0,IF(PowerOf1024>3,0,PowerOf1024)))+0.49999), FROM (SELECT SUM(data_length+index_length) KBS FROM...

Wondering what the best my.cnf config would be for my database. Currently running woocommerce, not a huge amount of products less than 100 but some products have almost 1000 variations. I'm currently using wp-import to import products but it is becoming pretty slow. I currently have around 25k...

We are using Plesk 17.5x version for our Ubuntu Server. There are 2 Database Servers installed on the server. The first one must remain with version 5.5.57. The second one however must be upgraded to 5.7. Is it possible to maintain the two version running on the Server at the same time? Yes...

Hello! I have big problem. If this is wrong place in forum, please tell me, I will delete thread and copy content to somewhere else, think it is also related general to plesk onyx. To this year a friend with database experience was optimising my mysql database for many years. Now he is ill and...

Hi @ all , Since a few weeks I use Plesk panel editor, in panel I made only 1. change (4096 for ssl) which has nothing to do with database usage at all. This good support thread by @UFHH01 is the right one but it's more necessary if a password is already set before. In my case I think the root...

For the reason that my providers offers now Ubuntu Server 16.04 LTS with Plesk Onyx (64 Bit) as an default-image option. What is recommended by You or Plesk for this environment? Upgrading MySQL 5.5 to only 5.6 or better upgrading to MySQL 5.7? Greets

For all users of MYSQL Community server 5.7+ on ubuntu (14,16): If your installation fails due to invalid datetime migrations go to /opt/psa/bootstrapper/pp17.5.3-bootstrapper/migrations/17.5.0/ and void the encrypted contents of the file [DATE]_48_change_dates_default_value.php. Afterwards...

Hi Folks, For a long time im struggling now to upgrade MySQL on my Plesk Server. It runs on CentOS 6.8 and Plesk 17.0.17. For now MySQL 5.1 is installed, and i would like to upgrade to 5.6 or 5.7. Without any loses and close all of the danger out. Im a total noob in upgrading databases and...

Hi, I'm considering upgrading mysql as some of my software / websites would run better. Currently I have Plesk Onyx 17.0.17 and MySQL 5.5.52 on ‪CentOS Linux 7.3. I've seen that 5.7 is not in the repository so it don't update automatically. Are there any good reason not to upgrade from...

Hi Guys, I have Plesk Onyx on my server with 2 mysql instances (on port 3306 & 6645), but when i am trying to add 6645 DB server, It's not connecting to this new server on new port, instead it's connecting to default 3306 port & saying "access denied" due to wrong password. Is there any way to...

How do I upgrade to MySQL 5.7 if my Plesk Onyx Package Manager for Windows Server 2012 R2 does not include v5.7? It only includes v5.6.