I recently installed MySQL 5.7.23 and started mysql service later ran mysql_secure_installation but while changing the password ran into any issue where it says that i cannot change the password as mysql service is running with skip-grant-tables.
Tried couple of times by stopping and starting the services but still the mysql service is getting started with skip-grant-tables. Command used to start service is service mysqld start, i did not mention the skip-grant tables while starting the service nor kept it in my.cnf file.
I logged into mysql and executed flush privileges, set root password, again flush privileges and logged out at this point it is requesting to login with the root password, but if i do a restart or run the mysql_secure_installation it is still starting with skip-grant-tables.
Can anyone let me know how i can resolve this issue by not starting mysql automatically with skip-grant-tables.
Thanks in advance.