Article ID: 116916, created on Dec 13, 2013, last review on May 11, 2014

  • Applies to:
  • Plesk for Linux/Unix
  • Plesk 12.5 for Windows

问题

可访问 Plesk 控制面板和 Plesk 数据库,但是可能会出现以下错误信息:

  1. 当尝试在 Panel 或数据库中直接执行任何更改时

    ERROR 1045 (28000):Access denied for user 'admin'@'localhost' (using password:YES)
    
  2. 当执行 Plesk 升级时:

    MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.9.5.4-11.0.9.20130807.dump.gz.ERROR 1045 (28000):Access denied for user 'admin'@'localhost' (using password:YES)
    

解决方案

  1. 请确保 admin 有所有权限:

    # mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql
    mysql> SHOW GRANTS FOR 'admin'@'localhost'\G
    Grants for admin@localhost:GRANT ALL PRIVILEGES ON *.*TO 'admin'@'localhost' IDENTIFIED BY PASSWORD '*18ED90460331B8E9FC796D9FF923A720D3EF8592' WITH GRANT OPTION
    1 row in set (0.19 sec)
    
  2. 给以 admin 所有权限:

    GRANT GRANT OPTION  ON *.*TO 'admin'@'localhost' WITH GRANT OPTION;
    FLUSH PRIVILEGES;
    
  3. 如果这也无法帮助解决问题或之前的命令失败出现错误,请查看 /var/log/mysqld.log.

  4. 如果您看到如下信息 ...

    [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
    

    ... 可能表示 MySQL 已重新安装或未完全升级。运行以下命令更新 MySQL:

    mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow` 
    

原因

重新安装损坏的 MySQL 服务器。

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 29d1e90fd304f01e6420fbe60f66f838 8b661cab116c79dbe6c4ac5bbdf1c8cb 85a92ca67f2200d36506862eaa6ed6b8 a766cea0c28e23e978fa78ef81918ab8

Email subscription for changes to this article