Действия

ISPManager 5 - db ERROR Failed to connect to mysql server. MySQL error: Access denied for user 'root'@'localhost' (using password: YES)

Материал из Wiki - Iphoster - 'the best ever support'

Самые выгодные сервера‎ в рунете


ISPManager 5 - db ERROR Failed to connect to mysql server. MySQL error: Access denied for user 'root'@'localhost' (using password: YES)

Ошибка:

Dec 30 09:43:01 [880:638] db ERROR Failed to connect to mysql server. MySQL error: Access denied for user 'root'@'localhost' (using password: YES)
Dec 30 09:43:01 [880:638] backtrace EXTINFO mgr_db::Fail::Fail(std::string const&, std::string const&, std::string const&) (lib/libmysql.so.5.43.0 + 0x53) [*0x7f0431fec179]
Dec 30 09:43:01 [880:638] backtrace EXTINFO ??? (lib/libmysql.so.5.43.0 + 0x0) [*0x7f044a3fda26]

Также - не создаются новые базы в ISPManager 5


Решаем - сбрасываем root пароль для mysql:

#  /etc/init.d/mysqld stop
Stopping mysqld:                                           [  OK  ]
#  mysqld_safe --skip-grant-tables &
[1] 3458
# 151230 09:29:05 mysqld_safe Logging to '/var/log/mysqld.log'.
151230 09:29:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 
# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.73 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> update user set password=PASSWORD("sdfy666666") where User='root'; Query OK, 3 rows affected (0.00 sec) Rows matched: 3 Changed: 3 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec) mysql> \q Bye
# /etc/init.d/mysqld stop 151230 09:29:56 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended Stopping mysqld: [ OK ] [1]+ Done mysqld_safe --skip-grant-tables # /etc/init.d/mysqld start # mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.1.73 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> Ctrl-C -- exit! Aborted


Последний шаг в ISPManager 5 -- Database servers --> MYSQL --> Edit --> Вводим новый пароль и отмечаем чекбокс: New Password --> OK