ERR_CONNECTION_REFUSED Error trying to import database sql on phpmyadmin

[faheemkiani]

Do you know how to give full privileges to a user for the database in VPS?
I mean if there any way to Grant full access to user for a specific database in VPS

[josephgodwinke]

@faheemkiani

can you tell me the command how to reset the mysql password?

You do not need to reset your mysql password when you do not even know it

@josephgodwinke

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

Run in terminal nano /usr/local/CyberCP/CyberCP/settings.py check for

@josephgodwinke

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

[josephgodwinke]

@faheemkiani

Do you know how to give full privileges to a user for the database in VPS?
I mean if there any way to Grant full access to user for a specific database in VPS

Root mysql user has full access or rights to all databases created on your server

[faheemkiani]

can you see this screenshot and tell me what is wrong with this?

I am using the password which I created for user “atla_atlan413_wp664” while making the database “atla_atlan413_wp664”.

[faheemkiani]

[faheemkiani]

can you guide me what i am doing wrong here?

[josephgodwinke]

You need to reset the password for the wordpress database user in mysql console

> ALTER USER 'wpuser_wpuser'@'localhost' IDENTIFIED BY 'mynewpassword';

[faheemkiani]

I changed and now i am getting this error

How to fix this?

[faheemkiani]

Thanks for your support
I successfully imported the database to the PHPMyAdmin

Now my next concern is that i cannot see the litespeed webserver installed on my cyberpanel plan.

How to install litespeed server now?

[josephgodwinke]

@faheemkiani

How to install litespeed server now?

Go to https://SERVER_URL:8090/serverstatus/litespeedStatus and get the 15 days trial or add a key for cyberpanel litespeed bundle

WARNING: You cannot revert back to OpenLiteSpeed if you choose not to purchase a LiteSpeed Enterprise license after the 15 day trial period. We recommend you test the Enterprise trial on a separate server.

[faheemkiani]

@josephgodwinke

https://SERVER_URL:8090/serverstatus/litespeedStatus

Just got an answer back, it seems my cpanel already comes with litespeed webserver (doesn’t require license)

now how to configure it in my VPS Cpanel Plan now?

[josephgodwinke]

@faheemkiani

Just got an answer back, it seems my cpanel already comes with litespeed webserver (doesn’t require license)

now how to configure it in my VPS Cpanel Plan now?

CPanel and cyberpanel are two different products that do the same thing. This is the cyberpanel forum

[faheemkiani]

Yes…i purchsed cyberpanel…

if there is already available option of litespeed webserver than where to find it in Cyberpanel?

[josephgodwinke]

@faheemkiani

if there is already available option of litespeed webserver than where to find it in Cyberpanel?

Did you get a chance to install cyberpanel yourself or it came preinstalled on your server ?

[faheemkiani]

i am confused, i cannot check either litespeed is preinstalled or not.

i purchased this VPS plan and install this os " CentOS 7 64bit with CyberPanel".

Do you know either litespeed webserver is installed in it or not?

[josephgodwinke]

@faheemkiani

i purchased this VPS plan and install this os " CentOS 7 64bit with CyberPanel".

…

Do you know either litespeed webserver is installed in it or not?

You would need to contact hostinger support for this information

[faheemkiani]

can you see this?

[faheemkiani]

at cyberpanel this is showing for litespeed server

[josephgodwinke]

@faheemkiani

at cyberpanel this is showing for litespeed server

Run in terminal

/usr/local/lsws/bin/lshttpd -v

Post results or screenshot here

[faheemkiani]

@josephgodwinke

/usr/local/lsws/bin/lshttpd -v