Просмотр кода страницы Cpanel - не работает автовход в phpmyadmin

=== Cpanel - не работает автовход в phpmyadmin ===



1) Сперва сбросить пароль от всех аккаунтов (FTP/mysql/Cpanel) через ssh
 # passwd user1

2) Если возникает ошибка вида '''"ER_PASSWORD_NO_MATCH"''':
  warn [cpmysqladmin] The system could not perform “GRANT” statements for the user “user1” due to an error: Cpanel::Exception::Database::Error/(XID 9vjyh2) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)
 at /usr/local/cpanel/Cpanel/DBI.pm line 200.
        Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0x144f9e0), "DBD::mysql::db do failed: Can't find any matching row in the "..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 188
        Cpanel::DBI::_error_handler("DBD::mysql::db do failed: Can't find any matching row in the "..., Cpanel::DBI::Mysql::db=HASH(0x144f9e0), undef) called at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 348
        Cpanel::Mysql::Basic::_sendmysql_untrapped(Cpanel::Mysql=HASH(0x141d4b0), "SET PASSWORD FOR 'user1'\@'server1.iphoster.net' = PASSWORD("...) called at /usr/local/cpanel/Cpanel/Mysql/Create.pm line 235
        Cpanel::Mysql::Create::__ANON__() called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/Try/Tiny.pm line 100
        eval {...} called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/Try/Tiny.pm line 91
        Try::Tiny::try(CODE(0x1663ce8), Try::Tiny::Catch=REF(0x166a4e8)) called at /usr/local/cpanel/Cpanel/Mysql/Create.pm line 239
        Cpanel::Mysql::Create::_dbowner_to_all_without_ownership_checks(Cpanel::Mysql=HASH(0x141d4b0), "method", "GRANT", "users", HASH(0x14181e8), "database", "") called at /usr/local/cpanel/Cpanel/Mysql/Create.pm line 113
        Cpanel::Mysql::Create::_dbowner_to_all_with_ownership_checks(Cpanel::Mysql=HASH(0x141d4b0), "method", "GRANT", "users", HASH(0x14181e8), "database", "") called at /usr/local/cpanel/Cpanel/Mysql/Create.pm line 63
        Cpanel::Mysql::Create::add_dbowner_to_all(Cpanel::Mysql=HASH(0x141d4b0), "user1", "pass", 0, undef, 1) called at /usr/local/cpanel/Cpanel/Mysql/Create.pm line 300
        Cpanel::Mysql::Create::create_dbowner(Cpanel::Mysql=HASH(0x141d4b0), "user1", 1) called at bin/admin/Cpanel/cpmysql.pl line 167


то нужно в конфиге '''/etc/my.cnf''' удалить строку '''skip-name-resolve'''<br>
и после этого перезагрузить mysql:
 # systemctl restart mysql
 Далее заново поменять пароль через
 # passwd user1

Пароли хранятся в базе mysql - таблице user:
  > select * from user where `user`='your_user1';