Error mysql when installing plesk on Centos Server 7

[hafedh]

Hello everyone,

I have a centos server 7 with phpmyadmin configured on it.
When i try to install plesk on it, i have the following error;


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_12.5.30_installation.log), fix and try again



I have created a file my.cnf under /root and paste the following contect:
[client]
user = root
password = root_password

But the problem is still present, any help please?

Best regards,
Hafedh

 

[IgorG]

I have created a file my.cnf under /root

File should be named .my.cnf instead of my.cnf

 

[hafedh]

Hello and thank you for your response,
I would like to share with you some tricks

I have renamed the file to .my.cnf and paste this contecnt

[client]
user = root
password = root_password


But the problem is still present.
So i have found this solution somewhere

[mysql]
user =
password = rootpassword

[mysqldump]
user =
password = rootpassword


when i tape root in user like this user = root
it's not working, so i leave this for blanc and it's works

Plesk is installed and worked


Thank you very much
(y)

 

[hafedh]

Just one question please,
I have an aothe rmachine,
I have installed plesk before installing any other application;
In the step where i have to install mariadb, i have this error
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

any ideo ?

Best reagrds
Hafedh

 

[IgorG]

Do you have /root/.my.cnf file there? Have you configured root access for this database server before Plesk installation? OS should be installed by default, without any custom settings, etc.

 

[hafedh]

Hello,

No i have installed at first plesk
then when i launch the installation on php, mysql, etc, i have found that all of thsese is installed (With plesk)
So i try to connect to mysql database
mysql -u root -p
password:*******


in this step i have the error mentionned before,
so i have create the file .my.cnf under /root/ and paste

[mysql]
user =
password = rootpassword

[mysqldump]
user = admin
password = rootpassword



but the problem is still present !!

thanks

 

[hafedh]

Hello,

So i have solved the problem with adding this line in the file /root/.my.cnf

socket=/var/lib/mysql/mysql.sock

now i can access to mysql server, but when i try top open plesk web interface i have the same problem but now for plesk

ERROR: PleskDBException: Unable to connect to database: mysql_connect(): Access denied for user 'admin'@'localhost' (using password: YES) (Error code: 1045) (Abstract.php:69)



Thanks

 

[hafedh]

My problem is solved

thank you IgorG