mysql root password

If you forget the MySQL root password on MySQL 8.0 server, you can follow the instruction here to reset the root user password. First, stop the MySQL server if it is already running systemctl stop mysql Create folder mkdir /var/run/mysqld/ chown mysql:mysql /var/run/mysqld/ Now start MySQL with –skip-grant-tables option mysqld –skip-grant-tables –user=mysql Take a new … Read more