Reputation: 84
I'm having a problem with localhost servers and databases. I'm by no means a pro at all of this but I've been developing WordPress websites for a short while and have been using MAMP because of how simple it is.
Now I understand that it installs MySQL for you and that Apache and PHP are all included with OS X, but I began learning Ruby on Rails and while I was following a tutorial I installed MySQL manually via terminal and I think I've ran into some collision problems now.
For a while MAMP refused to start the SQL server so I've changed the ports to Apache 8888 and SQL 8889 and now seems to be starting fine (which are the defaults I believe but were different for some reason).
Now I've got two different database locations (I think). One which I can see via the terminal using mysql -u root -p
and the other which I can see by launching MAMP and viewing PHPMyAdmin. If I create a database in one I cannot see it in the other, but more importantly when I create the database in MAMP's phpMyAdmin and try installing WP it doesn't recognise it, is this because my username/password may have been changed for MAMP or should it all be the same?
So far I've been thinking maybe I should uninstall MAMP and do a hard reset for MySQL etc and just use the terminal to manage MySQL, phpMyAdmin and Apache etc but I'm not sure - is there a better way to go about this? I am working on a WP website for a client at the moment in tandem with a Ruby on Rails project so need to ideally jump between the two!
Upvotes: 0
Views: 1069
Reputation: 2588
Having had a look around this looks like a good guide for running WordPress on your Mac locally... https://coolestguidesontheplanet.com/fastest-way-to-install-wordpress-on-osx-10-6/
They also have nice guides for installing Apache, MySQL and PHP as well for Mavericks https://coolestguidesontheplanet.com/get-apache-mysql-php-phpmyadmin-working-osx-10-9-mavericks/ and Yosemite https://coolestguidesontheplanet.com/get-apache-mysql-php-phpmyadmin-working-osx-10-10-yosemite/
Hope these help and good luck :)
Upvotes: 1