Cpanel - не работает автовход в phpmyadmin: различия между версиями

Материал из Wiki - Iphoster - the best ever hosting and support. 2005 - 2023
Перейти к:навигация, поиск
Строка 6: Строка 6:
 
  # passwd user1
 
  # passwd user1
  
2) Если возникает ошибка вида "ER_PASSWORD_NO_MATCH":
+
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)
 
   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.
 
  at /usr/local/cpanel/Cpanel/DBI.pm line 200.

Версия 13:40, 16 октября 2021

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

1) Сперва сбросить пароль от всех аккаунтов через 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
и после этого перезагрузить mysql:

# systemctl restart mysql
Далее заново поменять пароль через
# passwd user1

Пароли хранятся в базе mysql - таблице user:

 > select * from user where `user`='your_user1';