MySQL Forums
Forum List  »  Newbie

cannot start mysqld with --skip-grant-table option
Posted by: Scott Classen
Date: September 21, 2016 12:15PM

I need to reset the root password on a mysql database. I have stopped the mysqld process and attempted to start it with the --skip-grant-tables option, but I am receiving the following error and am not sure what section of the Security section to read.

systemctl stop mysqld

/usr/sbin/mysqld --pid-file=/var/run/mysqld/mysqld.pid --skip-grant-tables --skip-networking
2016-09-21T18:07:44.596045Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.15) starting as process 6920 ...
2016-09-21T18:07:44.597734Z 0 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2016-09-21T18:07:44.597776Z 0 [ERROR] Aborting

2016-09-21T18:07:44.597797Z 0 [Note] Binlog end
2016-09-21T18:07:44.597849Z 0 [Note] /usr/sbin/mysqld: Shutdown complete


any advice would be greatly appreciated

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.