lost root mysql

nano /etc/my.cnf

add skip-grant-table

[mysqld]
skip-grant-tables
port=3306
datadir=/var/lib/mysql


restsrat mysql

service mysqld restart

mysql -u root 
UPDATE mysql.user SET authentication_string = PASSWORD ('MYPASSWORD') WHERE User = 'root' AND Host = 'localhost';
FLUSH PRIVILEGES;




CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'your_password';
CREATE USER 'new_user'@'%' IDENTIFIED BY 'your_password';

GRANT ALL PRIVILEGES ON *.* TO 'new_user'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
quit;


service mysqld restart