Title: jbones's Replies | WordPress.org --- # jbones [ ](https://wordpress.org/support/users/jbones/) * [Profile](https://wordpress.org/support/users/jbones/) * [Topics Started](https://wordpress.org/support/users/jbones/topics/) * [Replies Created](https://wordpress.org/support/users/jbones/replies/) * [Reviews Written](https://wordpress.org/support/users/jbones/reviews/) * [Topics Replied To](https://wordpress.org/support/users/jbones/replied-to/) * [Engagements](https://wordpress.org/support/users/jbones/engagements/) * [Favorites](https://wordpress.org/support/users/jbones/favorites/) Search replies: ## Forum Replies Created Viewing 2 replies - 1 through 2 (of 2 total) * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [MAMP, changed MySQL database password, broke everything](https://wordpress.org/support/topic/mamp-changed-mysql-database-password-broke-everything/) * Thread Starter [jbones](https://wordpress.org/support/users/jbones/) * (@jbones) * [10 years, 1 month ago](https://wordpress.org/support/topic/mamp-changed-mysql-database-password-broke-everything/#post-7231405) * Solved. * I initially borked everything in phpMyAdmin by choosing Privileges tab > Edit Privileges link > Login information link: and I made a unique user name and password and I think selected the radio button “delete the old one from the user tables”. Everything went to hell after that. * As for my fix, I’m not saying this is the best way or even a sensible way, this is just how fixed it after a few hours of trial and error (and tears). I’m posting my solution because I hate to leave a thread hanging for the next poor soul in a similar situation. * So I’m using MAMP 3.5 on MacOSX 10.8.5 * Backup database folder located: * ‘Hard Drive > Applications > MAMP > db’ * Backup MAMP content folder too if you use the default location: * ‘Hard Drive > Applications > MAMP > htdocs’ * Stop MAMP servers. Quit application. Go to: * ‘Hard Drive > Applications >’ * Trash MAMP and MAMP Pro folder. Empty Trash. Download new MAMP package from website. Run installer. * Now, in your backup ‘db’ folder go into ‘mysql’ folder find the folder name of your database (something like ‘mywebsite’ or whatever you named it) and these files: * ib_logfile0 ib_logfile1 ibdata1 * Copy them in the corresponding ‘db > mysql’ folder location and put you contents of “htdocs” back as well. Set WordPress ‘wp-config.php’ file back to MAMP defaults DB_NAME to ‘mywebsite’, username ‘root,’ and password ‘root’. * Launch MAMP, start server. * The problem I had here was that all of the database tables were empty and logging into WordPress Admin panel would start a new WordPress installation and that didn’t help. So… * Go to phpMyAdmin panel, should be up and running now. Select ‘mywebsite’ database and select the Export tab. Defaults, Export Method: Quick. Format: SQL. Go. You get a page of text. Select all. Copy. Paste into text editor like Text Wrangler( something that doesn’t muck around with formatting). Save file as ‘mywebsite. sql’ somewhere you can find it. (I made a slight variation in the name to make it different not sure if that’s important or not.) * Uninstall MAMP and MAMP Pro by putting folders in Trash again. Empty Trash. Reinstall using downloaded package. Put “htdocs” contents back. Restart server. Open phpMyAdmin. No databases should be there. * Click New in the database tree on the left. Give it a name, (again, I made it slightly different to make the sql file I generated). Import tab. Choose File. Point to ‘mywebsite.sql’ file you made earlier. Defaults, and Go. Make sure that WordPress ‘wp-config.php’ file points to a database with the same name. * Go to localhost:8888 in browser and WordPress first page should be back but click here and there and you’ll quickly notice that links are broken. * Go to WordPress Admin panel ‘http://localhost:8888/wp-login.php’, login with the username and password you had been using all along, then go to: * Dashboard > Settings > Permalinks > Check Plain and Save Changes. That should fix the links and you can change it back to whichever format you prefer again. * Maybe this will be useful for someone else, and if I screwed up something above, it’s because my process wasn’t nearly as linear, so I may have misremembered. But there’s enough to give someone the general idea. Basically, try to get the database to show up by wiping MAMP settings clean and copying in database files. Export the database it if it’s broken, re-import, and reset WordPress permalinks. * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [MAMP, changed MySQL database password, broke everything](https://wordpress.org/support/topic/mamp-changed-mysql-database-password-broke-everything/) * Thread Starter [jbones](https://wordpress.org/support/users/jbones/) * (@jbones) * [10 years, 1 month ago](https://wordpress.org/support/topic/mamp-changed-mysql-database-password-broke-everything/#post-7231371) * Okay, I’ve found the MAMP folder containing ‘mywebsite’ database: * Hard Drive > Applications > MAMP > db > mysql > ‘mywebsite’ * My anxiety levels dropped by 70%. * I had a hypen in the name, so actually it was more like ‘my-website’ that made the folder ‘my@002dwebsite’ which was why when I was mass searching for the name it wasn’t getting any immediate hits. * So how do I hook my database back into MAMP services? Viewing 2 replies - 1 through 2 (of 2 total)