cannot start mysqld with --skip-grant-table option
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
Subject
Written By
Posted
cannot start mysqld with --skip-grant-table option
September 21, 2016 12:15PM
September 21, 2016 12:43PM
September 21, 2016 12:47PM
September 21, 2016 01:11PM
September 21, 2016 03:28PM
September 21, 2016 04:00PM
September 21, 2016 04:19PM
September 22, 2016 03:55PM
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.