Search code examples
mysqlwordpresslocalhostadminmamp

WordPress with local MySQL server: Cannot select created database as root


Even though I am root and I can log into my local mysql server as root, the WordPress Setup Configuration prevents me from selecting a database I created:

enter image description here

But I select one of the ones that I did not create like sys, then it seems to connect just fine. What is happening? What am I doing wrong?

edit: Here is what I am inputting into the WP (censoring my password), and this setup configuration generates a wp-config.php file. Again this only seems to work for databases like sys. enter image description here


Solution

  • I managed to figure out the solution. I follow these instructions (without sudo) in order to completely purge my mysql installation: https://gist.github.com/vitorbritto/0555879fe4414d18569d. By reinstalling my mysql, everything was fixed.