mysql

Hi, I am using Plesk Onyx v17.0.17 on CentOS 7 and I am quite new to command line but I need a few configurations done: 1) My MySQL is showing 5.5 and I would like to upgrade it to 5.6. I wasn't able to following the instructions here because I have no idea how to point "4. Add MariaDB...

I would like to know how to optimize the configuration in order to increase performance especially with regard to database requests. The server at my disposal is as follows: Server OVH Enterprise SP-32 Linux Plesk 12.5 (Cent OS 7) Intel(R) Xeon(R) CPU E3-1231 v3 @ 3.40GHz – Core: 8 32 GB RAM...

Hello, I've got a problem on my plesk panel. Actually, everything works well (all my websites are running) but I cannot manage my database server from plesk. Plesk tell me that it cannot connect to the server. In addition, when I try to create a new user on this database, i've got this message...

Hi, I'm trying to change the MariaDB data directory from /var/lib/mysql to /my_folder/mysql. Everything is good I can log into mysql in command line but plesk give me a hard time with Zend Errors. I've change my /etc/my.cnf and my /etc/psa/psa.conf to match with the new mysql location but...

I i'v tried every procedor found in google but i cannot restart mysql in centos. any suggestion. here is my tail -100 /var/log/mysql.log # tail -100 /var/log/mysqld.log the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB...

Hi I am having an update issue updating Plesk 12.5.30 from Version #42 to #59. The error log is the following: Running rpm_check_debug Fatal error during packages installation: [u'ERROR with rpm_check_debug vs depsolve:', 'rpmlib(FileDigests) is needed by...

Hello, I want to start automatic backups for the Plesk setup in Plesk Onyx 17.0.17 but I get the following error log: Error: Runtime error: The dump has wrong format! domains/example.com/backup_info_1702080331.xml: Line 1103 error: Element 'database', attribute 'type': [facet 'enumeration']...

Hi, Suddenly this error showed up: ERROR: PleskDBException: Unable to connect to database: mysql_connect(): Connection refused /var/lib/mysql/mysql.sock (Error code: 2002). Please check that database server is started and accessible. (Abstract.php:69) Since nothing changed on the server i...

i am using plesk 12.0.18 with centos 7, when i try to login plesk this error appeared ERROR: PleskDBException: Unable to connect to database: mysql_connect(): Access denied for user 'admin'@'localhost' (using password: YES) (Error code: 1045) (Abstract.php:69) using this help i was able to...

Hello I have two servers with Plesk Onyx One server for files , second for mysql (more the 1K request per /s) If I have online visitor more then 700 it give me some error PHP message: PHP Warning: mysqli::__construct(): (HY000/2002): Cannot assign requested address .. while reading response...

Hello! Is it possible to create an automatic backup of the MySQL database? Problem what I currently have: I can not use the normal backup function. It creates a Backup of the website-files and databases in one backup. The websites are big and are stored on a extra hard drive. The System-drive...

What is the best version of MySQL to use? How to upgrade? Thanks. God bless you.

Hi there, I am having an issue running the automated Application Installer for WordPress on my Plesk Onyx server, this is a VPS Server that is running: OS: CentOS 6.8 (Final)‬ Plesk: Version 17.0.17 Update #12, last updated on Jan 21, 2017 04:03 AM MySQL: 5.6.35 - MySQL Community Server (GPL)...

Hi, I'm using Plesk Onyx with MySQL 5.5.53 for hosting a news site based on wordpress with WP Super Cache on a dedicated server with 32GB RAM and 2x250GB SSD RAID1. Can you give some advice for my.cnf for best performance? I have this settings for now: join_buffer_size = 2M...

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

Could someone check my my.cnf please? What's wrong with it? Here is my default(original my.cnf that works) I'm trying to optimize DB for my VPS KVM OpenStack SLA 99.99 % 4 vCores 2,4 GHz 24 GB RAM 100 GB High Availability (Ceph) Thanks //IP:8443 returns

Hi, i try to remote my mysql database but connection is refused systematicly... I've add user with authorized remote from any host Same for mysql server... I've commented this line bind-address = ::ffff:127.0.0.1 and...

Hi, I Have this error in a new server: [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key Ubuntu: 16.04 Mysql: 5.7.16-0ubuntu0.16.04.1 Plesk 17.0.17 #5

Hello; I am trying to replace MYSQL 5.7 with MARIADB 10.1 on ubuntu 16.04. i tried with @Lloyd_mcse guide for ubuntu 14.04 which can be found here. The installation was successfully but am unable to access plesk admin area. i got the following error ERROR: Zend_Db_Adapter_Exception...

Hey there, I found a little Bug regarding DB creation. Tested on PPS12.5.30#47. Database Hosting Preferences: Add prefix and underscore to the beginning of database names - Username - Add username and underscore to the beginning of database user names. Create a new Subsc./Hosting with Username...