unable to change admin pw in webinterface

[Julz2k]

Hello,

I've got my dedicated Linux root today.
Plesk was preinstalled on the root.
I tried to connect but I just got SQL errors on th.e webinterface
After I initialized MySQL and set the Administrator password which was given by my ISP.
Finally I could login, but I had to change my Administrator password in the form, which is not possible.
I get the error

Error: Unable to change administrator's password: MySQL query failed: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

Thanks for the help!

 

[Faris Raouf]

You'll need to modify /etc/my.conf and comment out the skip-grant-tables line.

However, you might want to contact your host as this may be something they have done deliberately for some reason.

When you say "initialized mysql" and set the administrator password, what do you mean exactly? You should not change the mysql password manually under normal circumstances.

Basically, if the Plesk installation you were provided with didn't work/didn't let you login, I'd be worried that you either have the wrong password for it, or that it was incirrectly installed.

 

[Julz2k]

Thanks for the answer!

I mean when I said "initialized mysql" that I reset the password (old admin pw) and also started mysql properly.
I've edited the my.conf file (config was not there, I had to create it. I put the default settings without the "skip-grant-tables line" in it)
Finally I could login but seems like my provider forgot to activate the Plesk License.
I've contacted him about this issue.

Thank you again!