I'm trying to set a local dev environment on a Debian VirtualBox and am now stuck for days with the following situation.
After setting up apache, php, mysql, pma and got eveything running, I open the mysql console with root user. I create the empty database, "use" it then "source" the file I want to load. When finished, I eventually exit from the client. I can connect again, exit as many times as I want... I also can access to phpmyadmin with the same root user, and confirm that the database was properly loaded.
Everything's fine, till I reboot debian. From now on, I stick to :
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
I've tried to access with different users, nothing changes. Same thing for phpmyadmin.
As I work with Vbox snapshots,I've determined that the issue seems related to the database. Rebooting after creating the empty database is fine, I'm still able to connect.
I've crawled many related topics accross the web, and couldn't come up with that particular situation, and all the approaching topics solutions start with connecting with root user - which I can't do.
What am I missing ?
Thanks for your help !