Nginx Server UpDraftPlus ve XCloner Yedekleme Problemleri

I – Xcloner Connect Failed: Access Denied For User

II – XCloner 502 Bad Gateway Error

III – UpDraftPlus Binary mysqldump- error (code 3)

IV – UpDraftPlus 14 Hours Backup Problem!

V – UpDraftPlus Debug Database “Internal Server Error” Problem

VI – Invalid query: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

.

I – Xcloner Connect Failed: Access Denied For User

1 - Xcloner connection failed access denied for user 1

1 - Xcloner connection failed access denied for user 21 - Xcloner connection failed access denied for user 3 .

II – XCloner 502 Bad Gateway Error

Updraftplus nginx bad gateway error (1)Updraftplus nginx bad gateway error (2)

.

III – UpDraftPlus Binary mysqldump- error (code 3)

Binary mysqldump- error (code 3) - 1

2 – Support Says Its Normal;

Binary mysqldump- error (code 3) - 2

3 – But DB Couldnt Backedup;

Binary mysqldump- error (code 3) - 3.

IV – UpDraftPlus 14 Hours Backup Problem With SQL Backup Failed!

Backup Takes More Than 14 Hours;

updraftplus 14 hour backup problem (1)

Also My 130 Mb Database Shatterd to Pieces as 100 MB;

updraftplus 14 hour backup problem (2)

Before Installing Nginx My UpDraftPlus Db Backup Files;

original updraftplus Db file size

.

V – UpDraftPlus Debug Database “Internal Server Error” Problem

Updraftplus debuggind error  (1)

A Few Minutes Later I Got This Error;

Updraftplus debuggind error  (2)

.

VI – Invalid query: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

I – Invalid query: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

Invalid query Access denied; you need

2 – Putty ile bağlanarak aşağıdaki komutları girin;

1. Through phpmyadmin

Go to PHPMYADMIN > privileges > Edit User > Under Administrator tab Click SUPER. > Go


2. Via console

# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1139
Server version: 5.0.51a-community MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>use databasename;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed

mysql>grant SUPER on *.* to 'user'@'localhost' identified by 'password';
Query OK, 0 rows affected (0.02 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

 

This will fix the issue

how to grant superuser

 

Bir Cevap Yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir

Şu HTML etiketlerini ve özelliklerini kullanabilirsiniz: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>