Completely stuck not able to login to Admin after rest password

Dear Friends,

Some days before i upgraded my MariaDB from the moment I was not able to open Phpmyadmin it showing 404 Not Found. So search here and on post i saw rest the root password from the admin and everything will work . After reset root password now iam not able to login Admin panel. I DONT KNOW what to do so some body please help me. PLEASE

OS: AlmaLinux 9

I think MaraiDB/MySQL upgrade couldn't cause the error 404.

You get the error 404 because you use a wrong URL to access PHPMyAdmin or some config files of CWP are corrupted/removed.

What error do you get when you try to access the CWP admin panel (https://domain.com:2031/) ?

How did you perform MySQL/MariaDB upgrade ? Can you show the instructions used by you ?

Dear cyberspace,

I used an upgrade comment line for MariaDB which was found in a post and now i didn't have it. After upgrade

iam getting an notification like this on every login " MySQL bad configuration detected, check from the console by using mysql command !!! " but everything worked smoothly. what i noticed is process is showing hike in resource usage. and when you try

to open PHPMyAdmin getting this error page " 404 Not Found Please contact your hosting provider to correct issues causing this website to be offline. " . Now what is the situation iam facing is i changed the admin or root password, after that i can't login to

admin interface, i was able to login to FTPS and SSH using the new password but admin interface login is not working. So first of all all i need to know how i can gain access to admin login . The new password i set was not working in the login screen .

I think MaraiDB/MySQL upgrade couldn't cause the error 404.

You get the error 404 because you use a wrong URL to access PHPMyAdmin or some config files of CWP are corrupted/removed.

What error do you get when you try to access the CWP admin panel (https://domain.com:2031/) ?

How did you perform MySQL/MariaDB upgrade ? Can you show the instructions used by you ?

Why i changed the password is because in a post in this thread i saw some one say if you change admin password from the admin interface everything will work but it was a bad thing i ever done so please let me know in which file or where i can check the new password for admin login is stored if you can tell me the complete path that will be helpfull as iam a beginner.

i tried below command and getting this

[root@vp ~]# sh /scripts/cwp_update_admin
curl: (28) Failed to connect to centos-webpanel.com port 80: Connection timed out
cat: /usr/local/cwpsrv/htdocs/resources/admin/version.txt: No such file or directory

your root password is your ssh root password.  However, you cannot put html special charatters (&"'<>) in your password, or it will not allow login.

I changed the password again now using command : passwd my new password didn't have any special character but after that also the admin login still showing login failed

your root password is your ssh root password.  However, you cannot put html special charatters (&"'<>) in your password, or it will not allow login.

Check CWP log:

/usr/local/cwp/php71/var/log/php-fpm.log

and MySQL log to make sure there are no errors.

Below are the log, Please let me know how i can access to my admin dashboard using the root user name and password. In which file this password was stored, Now iam not able to login to admin dashboard after last password change.

PHP FPM
https://anotepad.com/notes/5ry2y8ca

MySQL log this file only have these entry only. If the MySQL log location is wrong please tell me where i can find it
Location or file path : /var/log / mysqld.err
https://anotepad.com/notes/k9r8c7hc

Seems like you changed your mysql password as well.  check /root/.my.cnf and see if you can log into mysql with mysql -p  using the password from the file

Dear Friends,

everyone is saying a solution but what i needed is i want to login to my admin dashboard. I don't know what to do now
since it was more than 7 days iam looking a solution to login to my admin dashboard. Please tell me where i can reset the
or manually enter the new root password. from the command line i reset the password and it was working fine in SSH and FTPS
but admin login is still not working. Tell me a solution to reset the password through command line or manually edit the file. below i tried to reset the password using this command but it was saying this.

Code: [Select]

mariadb -u root -p
mariadb: unknown variable 'sql_mode=NO_ENGINE_SUBSTITUTION'

mysql -u root -p
mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
mysql: unknown variable 'sql_mode=NO_ENGINE_SUBSTITUTION'



Would you like hands on assistance? PM me your server details if you need help getting un-stuck. (You can always change r00t login details afterward.)

Dear Please check your inbox I have send the details, please go though and help me

Would you like hands on assistance? PM me your server details if you need help getting un-stuck. (You can always change r00t login details afterward.)

I will be able to help later this evening -- 5-6 hours from now (I am in -0500). What is your timezone?

Iam from INDIA the current time is 2:34 AM (Asia/Kolkata), please let me know your country so I can add the country code to firewall allow list

I will be able to help later this evening -- 5-6 hours from now (I am in -0500). What is your timezone?