phpmyadmin 500 internal server error when accessed from users cpanel

[LAZer]

Hi, on my server phpmyadmin is working fine when I access it from whm with root user.
but when I access it from users host (on 2083) after redirection from cpanel to phpmyadmin it gives blank white page with 500 internal server error.
I tried these commands but they didn't fix it.

1. Repair cPanel's Internal RPMs.
   /scripts/check_cpanel_pkgs --fix
2. Restart the cPanel service daemon.
   /scripts/restartsrv_cpsrvd --hard

any other suggestions? or where is its logs to check more?

 

[cPRex]

Hey there! The first place I'd look would be the cPanel error logs at /usr/local/cpanel/logs/error_log to see if that provides more helpful information. Usually if there is an authentication issue or problem with the interface, it will show up in that log.

Can you check that log to see if there is anything helpful?

 

[LAZer]

Hey there! The first place I'd look would be the cPanel error logs at /usr/local/cpanel/logs/error_log to see if that provides more helpful information. Usually if there is an authentication issue or problem with the interface, it will show up in that log.

Can you check that log to see if there is anything helpful?

thanks for the answer . I checked that log. I found nothing including phpmyadmin in it when I searched the log.
E486: Pattern not found: phpmyadmin

anyway with a reset password of the user it seems it started working.
but it was a new host Its strange why it needed another reset password again.

I think this issue is happened after updating the server from mysql 5.7 to mysql8 for older hosts. but this host was created after mysql upgrade and it faced this error anyway.

cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)

mysql -v
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 906976
Server version: 8.0.33 MySQL Community Server - GPL


cPanel Version 110.0.2

 

[cPRex]

It sounds like the problem was the authentication, and the user's password got out of sync somehow. I'm glad you were able to get that working!

 

[ResellerWiz]

It sounds like the problem was the authentication, and the user's password got out of sync somehow.

I’ve seen this issue plenty of times and it was always a password sync issue and resetting the accounts password fixed it every time.