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 &
- GRANT PRIVILEGES for root user
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root'; - FLUSH PRIVILEGES
FLUSH PRIVILEGES; - STOP AND RESTART MYSQLD
sudo killall mysqld | sudo service mysQL start
No comments:
Post a Comment