PROBLEM:
-PHPMYADMIN SHOW "NO" FOR GRANT PRIVILEGES FOR ROOT USER
-CANNOT GRANT PRIVILEGES FOR USERS
-RASPBIAN / DEBIAN
SOLUTION:
- STOP MYSQL
sudo service mysql stop OR sudo killall mysqld - START MYSQL SKIPPING PRIVILEGES sudo mysqld_safe --skip-grant-tables &
- CHANGE PASSWORD FOR ROOT USER
SET PASSWORD FOR 'root'@'localhost' = PASSWORD("newPassWD"); - FLUSH PRIVILEGES
FLUSH PRIVILEGES; - STOP AND RESTART MYSQLD
sudo killall mysqld | sudo service mysQL start
No comments:
Post a Comment