ERR_CONNECTION_REFUSED Error trying to import database sql on phpmyadmin

Support and Discussion General Discussion
,
1

I am trying to import the database in VPS cyber panel using phymyadmin but its giving me following error.

image
image717×466 9 KB

I cannot import the database.
How to solve this?

2

Hello @faheemkiani

Unfortunately, this has nothing to do with cyberpanel. There can be a number of issue causing this:

  1. Bad internet connection
  2. Faulty browser extensions like ad blockers etc
  3. Antivirus, Firewall blocks
  4. Using a VPN connection
  5. Using a proxy connection

You need to check your connection, flush your dns cache and disable the above

3

i removed ad blocker but still same issue.
phpmyadmin is using follwing php version

image
image630×725 40.9 KB

4

Follow this guide 4 - Change Upload Limit for phpMyAdmin see if it can help

5

size is already greater

image
image837×493 32.2 KB

6

I tried this method but still not working

7

Have you increased your timeout limit ?

8

How much should i increase the timeout limit?

9

I changed the timeout limit but still same

10

Did you check all of the above ERR_CONNECTION_REFUSED Error trying to import database sql on phpmyadmin - #2 by josephgodwinke

Is this still CentOS7?

11

Can you tell me how to give full privileges to a user of a database in VPS ?

12

I am getting this error now at terminal because i am trying to import the database using teriminal

“access denied for user ‘root’@‘localhost’ (using password yes)”

Can you guide me how to fix this?

13

You can check root mysql password here /usr/local/CyberCP/CyberCP/settings.py

DATABASES = {
...
    'rootdb': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'mysql',
        'USER': 'root',
        'PASSWORD': 'cyberpanel',
        'HOST': 'localhost',
        'PORT': '',
    }
}
14

but at terminal i did not put any password due to which i saw this error

15

Anyone here to help me.
I am still facing the follwoing issue while importing the database

image
image1556×709 12 KB

16

Can you tell me how to find this folder at backend of cyberpanel?

17

Use the Root File Manager addon or SSH or VNC to access the folder

18

how can i access via SSh or Terminal then reset the password?

19

Use bitvise ssh client. They have good documentation on how to get started.

20

i accessed the terminal.
can you tell me the command how to reset the mysql password?