./categories/server
MySQL ERROR 1044 Access denied
증상
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'some_db'
확인
SELECT USER();
SELECT CURRENT_USER();
SELECT host, user, password, Grant_priv, Super_priv FROM mysql.user;
해결 (Grant_priv=N)
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
FLUSH PRIVILEGES;
GRANT ALL ON *.* TO 'root'@'localhost';
./comments