Author Topic: Unable to login to phpmyadmin from cwp admin  (Read 7535 times)

0 Members and 1 Guest are viewing this topic.

Offline
**
Unable to login to phpmyadmin from cwp admin
« 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


Offline
*
Re: Unable to login to phpmyadmin from cwp admin
« Reply #1 on: July 20, 2021, 10:29:48 PM »
I have exactly the same problem and still cant solve.
From PRO support even no replyes  :(

Offline
*
Re: Unable to login to phpmyadmin from cwp admin
« Reply #2 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!

Offline
*****
Re: Unable to login to phpmyadmin from cwp admin
« Reply #3 on: July 21, 2021, 01:01:39 AM »
in next updates it will be solved.

Offline
*
Re: Unable to login to phpmyadmin from cwp admin
« Reply #4 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.
SEOtraining1.com -SecureHosting.xyz

Offline
*
Re: Unable to login to phpmyadmin from cwp admin
« Reply #5 on: July 04, 2022, 01:27:14 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?

SEOtraining1.com -SecureHosting.xyz

Offline
*****
Re: Unable to login to phpmyadmin from cwp admin
« Reply #6 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