Tag Archives: admin

Reset Root Password in MySQL ^8.*

Views: 440 Add below code to the end of /etc/mysql/my.cnf file.[mysqld]skip-grant-tables Restart service:sudo systemctl restart mysql Login into mysql:sudo mysql -uroot Remove root password:UPDATE mysql.user SET authentication_string=null WHERE User=’root’; FLUSH PRIVILEGES; exit; Comment below code at the end of /etc/mysql/my.cnf file by add # in front of each line.# [mysqld]# skip-grant-tables Restart service:sudo systemctl restart

Read More