phpMyAdmin Blank Page | stopped working

Support and Discussion
1

Today phpMyAdmin stopped working. No errors from CyPanel, just a blank page.
I’ve seen the posts below, nothing worked. I rebooted the VPS, same problem.
My website is working.

I got MySql root psw as below:

cat /etc/cyberpanel/mysqlPassword

Then, on phpMyAdmin login page I used that psw: Access Denied.
mysqli::real_connect(): (HY000/1045): Access denied for user ‘root’@‘localhost’ (using password: YES)

As suggested [1], I commented out few lines in config.inc.php | same problem

systemctl status mariadb
Active: running
…
[Warning] Access denied for user ‘root’@‘localhost’ (using password: YES)

Ubuntu 22.04
Php 8.1
CyPanel 2.3

Can anyone help? Many thanks

[1] unable to get access to phpmyadmin

2

OK, by mistake I changed root credentials while I was logged in.
I set root psw: null and I lost access to phpMyAdmin.

Here is how I fixed, enjoy:

  1. get MySQL root psw: > cat /etc/cyberpanel/mysqlPassword | eg. 1234
  2. open /usr/local/CyberCP/public/phpmyadmin/config.inc.php
    and comment out 5 lines after: /* Authentication type */
  3. add: $cfg[‘Servers’][$i][‘password’] = ‘1234’; save and close the file.

  4. mysql -u root -p // this will login to MySQL via SSH

  5. SET PASSWORD FOR root@localhost = PASSWORD(‘1234’);

  6. Now if you access phpMyAdmin you’d be able to login with: root, psw: 1234
    https://my-cyberpanel/phpmyadmin
  7. Finally I’d suggest to re-enable SSO, by un-commenting the lines at #2 above
3

This topic was automatically closed 3 hours after the last reply. New replies are no longer allowed.