Control Web Panel
WebPanel => MySQL => Topic started 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
-
I have exactly the same problem and still cant solve.
From PRO support even no replyes :(
-
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)
/* 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!
-
in next updates it will be solved.
-
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.
-
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?
-
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