logo
Blog single photo

Cannot enter phpmyadmin as root


                        

#1698 - Access denied for user 'root'@'localhost'

Open Terminal

sudo mysql --user=root mysql

Run the following commands (replacing some_pass by the desired password):

CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'Md@pass!001';
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Top