PhD researcher @ The University Of Sheffield
Having to set up a new desktop today, I was following the usual procedure for phpmyadmin:
– Put the phpmyadmin folder in /Library/WebServer/Documents/phpmyadmin
– Added the config folder with permissions: chmod o+w /Library/WebServer/Documents/phpmyadmin/config
– Generated config.inc.php with phpmyadmin setup (localhost/phpmyadmin/setup)
– Moved config.inc.php in the phpmyadmin home folder
Still, when trying to log in the UI with the root username and password I was getting this error: “Cannot log in to the MySQL server”.
After resetting the password for mysql 3 times and re-installing entirely phpmyadmin, I stumbled upon a StackOverflow question where Sepp suggested to change localhost to 127.0.0.1 in the config.inc.php file.
Sometimes solutions are that simple.
My two cents for whoever might have the same issue.Back to all posts
My name is Alvin and I am an Italian born learner.
I am interested in a broad variety of topics.
I am currently working on a multi-perspective topic called Neuroeconomics. It involves studying human behaviour in uncertain situations from different points of view. Psychological, Economic and Neuroscientific.
I cannot live without music. It is impossible to give a comprehensive list of genres therefore I will point you to my last.fm tagcloud.
I read a lot, mostly scientific papers, but I don’t dislike a good novel once in a while.
I love movies. I have a discrete collection (~140 titles), but I am always looking for new – or old – pearls to add.
I enjoy football, a lot. The company, the competition, learning tricks, using tricks, the passion, the commitment, the hits taken, the hits given, the victories, the defeats.
I had many teachers in my life. Some were in school, in university. Others were somewhere else, along my path. Some are still there and some are not anymore. Some are yet to be met. To all of them I say thank you.