Wednesday, July 25, 2018

SOLUTION: RESET MYSQL root password

PROBLEM:
-PHPMYADMIN SHOW "NO" FOR GRANT PRIVILEGES FOR ROOT USER
-CANNOT GRANT PRIVILEGES FOR USERS
-RASPBIAN / DEBIAN


SOLUTION:
  1. STOP MYSQL
    sudo service mysql stop     OR      sudo killall mysqld
  2. START MYSQL SKIPPING PRIVILEGES sudo mysqld_safe --skip-grant-tables &
  3. CHANGE PASSWORD FOR ROOT USER
    SET PASSWORD FOR 'root'@'localhost' = PASSWORD("newPassWD");
  4. FLUSH PRIVILEGES
    FLUSH PRIVILEGES;
  5. STOP AND RESTART MYSQLD
     sudo killall mysqld | sudo service mysQL start





No comments: