How to start mysql without --skip-grant-tables?

Question

MySQL

When I run a command to configure MySQL
mysql_secure_installation
Prompts me to change my password? but when you enter it, it says that it cannot because the database works in the --skip-grant-tables mode

Failed! Error: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement.

I tried to remove / install the database does not help,

I would be grateful for any advice!

Answer 1

Restarting the VPS from the hosting control panel helped

Answer 2

Is there a skip-grant-tables line in /etc/my.ini?
If it's not there, it might be in /etc/mysql.d/*.
In general, look in /etc/ and comment it out.