Question how to fix error 1045 while installing

[pvnda]

I encountered this during installation
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
so I never set admin@localhost before, I just set the password for the root
and what should I put in /root/.my.cnf

thanks a lot!

 

[IgorG]

This looks like a known problem. Have you checked KB - Plesk upgrade/installation fails: Access denied for user 'admin'@'localhost' ?

 

[pvnda]

Thanks for help, do I need to put admin and admin password into /root/.my.cnf or just any user I want, because I tried a test user and it didn't work.
I checked all the

/etc/my.cnf
/etc/mysql/my.cnf
SYSCONFDIR/my.cnf
$MYSQL_HOME/my.cnf
~/.my.cnf

This looks like a known problem. Have you checked KB - Plesk upgrade/installation fails: Access denied for user 'admin'@'localhost' ?

 

[IgorG]

You should use only root user.

 

[pvnda]

You should use only root user.

I dropped all users except root, and I put

[client]
user=root
password=xxxxx

into ~/.my.cnf
it's still not working,
what did i miss ?
by the way i don't have /etc/my.cnf
and where can I find
SYSCONFDIR/my.cnf
$MYSQL_HOME/my.cnf

 

[IgorG]

I meant using root account for all your actions in CLI. When you install Plesk, root acccess for mysql will be replaced by admin account. Therefore you mustn't have any .my.cnf especially with

user=root

records there.

 

[pvnda]

I removed .my.cnf file, I checked all other my.cnf files, there is no [client] section expect debian.cnf but when I run wget command in su, the error still there

I meant using root account for all your actions in CLI. When you install Plesk, root acccess for mysql will be replaced by admin account. Therefore you mustn't have any .my.cnf especially with

user=root

records there.

 

[IgorG]

I can only recommend to create a request to support team to do in-depth investigation to find the reason and to fix it. Please create a ticket to support at Help Center