Change the root user plugin from auth_socket to mysql_native_password alter user 'root'@'localhost' identified with mysql_native_password by 'root' Flush the privileges flush privileges Ctrl + z to exit from mysql restart your mysql service sudo service mysql restart check your phpmyadmin page and try to log in. I can't access localhost/phpmyadmin/ before i can access localhost/phpmyadmin/ but today when i'm trying to access this page i got weird page also i can access localhost/xampp/ without. By mistake, i have created a duplicate database in the phpmyadmin page of cpanel I want to delete this database, but i am not able to find any delete button in the ui
How to delete a database in I keep getting the following errors with mysql connection through xampp and i don't know what to do That's the code in the config.inc.php <?php /* * this is needed for cookie based authentica. If you are not able to access localhost/phpmyadmin First of all, add phpmyadmin folder to your working directory Add the folder to your working directory and change the name to phpmyadmin
You will see a login page of phpmyadmin application. Root access to phpmyadmin was working, so i logged in as root to phpmyadmin and used the query set password for 'phpmyadmin'@'localhost' = password([copy and paste the password here]) and it worked! Phpmyadmin is giving me a message saying that the user (root) does not have a password So, how can i create one? It set it up alright and made a phpmyadmin database, but i can't seem to find the url to get t. Still, accessing localhost is very, very slow, and sometimes it doesn't even load at all
I even removed it and replaced it with xampp, but i still got the same result.
OPEN
