Control Web Panel

WebPanel => MySQL => Topic started by: anandmys on July 11, 2021, 06:35:53 AM

Title: Unable to login to phpmyadmin from cwp admin
Post by: anandmys on July 11, 2021, 06:35:53 AM

I havent done any manual changes to code anywhere.

All of a sudden, I cant login to phpmyadmin from admin (root) login.

I have applied all updates whatever was available in Yum

Title: Re: Unable to login to phpmyadmin from cwp admin
Post by: diegoigr on July 20, 2021, 10:29:48 PM

I have exactly the same problem and still cant solve.
From PRO support even no replyes  :(

Title: Re: Unable to login to phpmyadmin from cwp admin
Post by: diegoigr on July 20, 2021, 11:07:15 PM

I can fix it checking the phpMyAdmin config file at "/usr/local/cwpsrv/var/services/pma/config.inc.php" (In my case the root password is empty)

Code: [Select]

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'TypeHereYourMysqlRootPassword';
If you dont know your mysql root password you can get it at "/root/.my.cnf" or "/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php"

Good luck!

Title: Re: Unable to login to phpmyadmin from cwp admin
Post by: Sandeep on July 21, 2021, 01:01:39 AM

in next updates it will be solved.

Title: Re: Unable to login to phpmyadmin from cwp admin
Post by: Shafire on July 04, 2022, 01:11:40 AM

Also if this helps login shows :2087/pma/ in the URL for PHPMyAdmin login from end-user login from 2083 non-admin login end user.

Title: Re: Unable to login to phpmyadmin from cwp admin
Post by: Shafire on July 04, 2022, 01:27:14 AM

Quote from: Sandeep on July 21, 2021, 01:01:39 AM

in next updates it will be solved.

Tried but did not work for me, restarted all services, and ran commands:

sh /scripts/mysql_phpmyadmin_update

sh /scripts/update_cwp

my config file: /usr/local/cwpsrv/var/services/pma/config.inc.php

$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;

/**
 * phpMyAdmin configuration storage settings.
 */

/* User used to manipulate with storage */
// $cfg['Servers'][$i]['controlhost'] = '';
// $cfg['Servers'][$i]['controlport'] = '';
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';


i noticed pma in that section should this be edited?
URL shows: :2087/pma/ and i see some stuff about pma above?

Title: Re: Unable to login to phpmyadmin from cwp admin
Post by: josemnunez on July 04, 2022, 12:48:02 PM

many times this error is caused by changing the root password for mysql, please use the script indicated for it in /scripts/ to change the password