mysql - Plesk 安装 mysql 失败

Question

尝试在我的 ec2(当前正在运行 3 个站点)上安装 plesk。据我所知，plesk 只能在普通服务器上运行(希望情况并非如此)。

安装上线崩溃:

Synchronizing state of mysql.service with SysV init with /lib/systemd/systemd- 
sysv-install...
Executing /lib/systemd/systemd-sysv-install enable mysql

之后的错误是:

 Trying to establish test connection... mysql: [Warning] World-writable config                
 file '/root/.my.cnf' is ignored.
 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: 
 NO) failed
 One more attempt to connect

 ERROR while trying to establish test connection. If you are installing Plesk 
on an already configured MySQL server, you need to specify the administrator's 
credentials to succeed with the installation. To do this, you need to create a 
file - /root/.my.cnf with the 'client' section where you need to provide user 
and its password ("user = $admin_name" and "password = $admin_pass"). After 
installation is finished, the file /root/.my.cnf will be renamed to 
/root/.my.cnf.bak
Check the error reason(see log file: 
/var/log/plesk/install/plesk_17.8.11_installation.log), fix and try again

 *****  problem report *****
ERROR while trying to establish test connection. If you are installing Plesk on 
an already configured MySQL server, you need to specify the administrator's 
credentials to succeed with the installation. To do this, you need to create a 
file - /root/.my.cnf with the 'client' section where you need to provide user 
and its password ("user = $admin_name" and "password = $admin_pass"). After 
installation is finished, the file /root/.my.cnf will be renamed to 
/root/.my.cnf.bak
Check the error reason(see log file: 
/var/log/plesk/install/plesk_17.8.11_installation.log), fix and try again
sh: 1: /etc/init.d/psa: not found

我已经添加了文件/root/.my.cnf，如下所示:

Client
User: xyz
Password: xyzxyz

但它仍然无法拾取或使用它(一遍又一遍地更改权限)。

有人能够克服这个错误吗？

干杯

Answer 1

是的，可以在已安装 mysql 的服务器上安装 Plesk。需要创建一个具有 mysql root 访问权限的文件/root/.my.cnf:

# cat /root/.my.cnf
[client]
user = root
password = root_password

但不建议在已运行站点的服务器上安装 Plesk，因为 apache 和 nginx 配置文件可能会更改。