Restoring root in mysql?

Question

MySQL

Unknown MySQL root password
trying to recover by running MySQL without checking privileges
Here is the log

[email protected]***-**-**:~# /etc/init.d/mysql stop
[ ok ] Stopping mysql (via systemctl): mysql.service.
[email protected]***-**-**:~# mysqld_safe --skip-grant-tables &
[1] 5751
[email protected]***-**-**:~# 170922 22:33:02 mysqld_safe Logging to syslog.
170922 22:33:02 mysqld_safe A mysqld process already exists
[email protected]***-**-**:~# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[1]+  Exit 1                  mysqld_safe --skip-grant-tables
[email protected]***-**-**:~#

As I understand it, there is no root at all? How to be?

Answer 1

Log in as the server root, then type the following commands:

/etc/init.d/mysql stop

/etc/init.d/mysql start --skip-grant-tables

mysqladmin -u root password "newpassword"

/etc/init.d/mysql stop

/etc/init.d/mysql start

Valid for debian, other OS paths may be different