#MYSQL NOT STARTING MAMP PRO#
This will probably sound really stupid to alot of you but I really do not know what to do here I would just like MAMP PRO to work again. I’ve looked high and low on Google and all I can find are pages of words that are double dutch to me… I dont understand what the problem is basically. How can I restore everything to normal so that I can access the MAMP start page, phpmyadmin etc ? Ive tried completely uninstalling MAMP/MAMP PRO, nothing. This all seems to have happened when I stupidly tried to create a new user in PHP myadmin and I think I have entirely messed up the “root” account – However with this kind of topic this is as far as my knowledge goes… I am baffled.
#MYSQL NOT STARTING MAMP PASSWORD#
You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server. PhpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. #1045 – Access denied for user (using password: YES) Then I try out of curiosity the webstart button to attempt to open the MAMP start page… and I get this errorĮrror: Could not connect to MySQL server!įinally I use the “Launch PhpMyAdmin Button”. Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user (using password: YES) when trying to connect Seguí a la segunda, pero en mi directorio Applications/MAMP/db/mysql/ no había ningún archivo llamado ib_logfileN sino una carpeta denominada mysql56 como indica ElCid en cuyo interior estaba el fichero ibdata1 de 79,7 MB que borré tras haber hecho copia de seguridad.Basically the problem is that every time I launch MAMP PRO and start the servers, when the MySQL server attempts to start I get this message… Mysqli_real_connect(): (HY000/2002): No such file or directoryīuscando soluciones llegué a tu web 🙂 Probé tu solución primera sin éxito. #2002 – No such file or directory - El servidor no está respondiendo (o el zócalo local al servidor MySQL no está configurado correctamente). Cuando la volví a instalar observé que el archivo index.php del directorio htdocs indicaba su última línea ‘Something is wrong with your MAMP installation :-(‘ y al intentar conectar mediante phpMyAdmin con las bases de datos el navegador mostraba este mensaje: Para clonar una Moodle descargué Moodle4Mac-34.dmg que viene con la versión MAMP 4.1.1 pero como había cosas que no funcionaban tuve que quitarla. Hace tiempo estuve trabajando con una versión MAMP antigua, que desinstalé de mi MacOS. Muchas gracias, Juanfra Aldasoro y ElCid. Please back up these before you delete them 🙂 In the finder go to Applications/MAMP/db/mysql/ and delete the last log file (look for a file named ib_logfileN – being N the log number).
The instructions he shared are the following: If you are having trouble fixing this issue with the instructions above, many readers are being able to solve this problem thanks to the amazing fix shared by one of the commenters, ElCid. You can also use Hyper, a terminal app built by the amazing team. You can check if there are any MySQL processes running the “top” command. You can find that app under Applications/Utilities. Note: Terminal is the terminal emulator included in Apple’s OS X operating system. Then you’ll be able to start again your servers by hitting “Start Servers” in the MAMP app. Assuming that not many people hosts websites on OSX, you won’t have any collateral damage.Īll you need to do, is run a simple command on the terminal or hyper.
Simply killing all MySQL processes and then starting the servers again. There’s an easy solution for this, a quick and tiny fix you can run as many times you need. Sometimes, it also happens when restarting your computer.
I hate when I resume my computer after sleeping a few hours, and I get that annoying red light just beside “MySQL server” indicator. The only problem I often get with this platform, is that MySQL won’t start. That way I can work with loads of different projects in an organized manner. Personally, I love setting up and using virtual hosts & WordPress multisite. I like the fact that is the faster and easier way to setup a low-maintenance development environment for OSX. As many others WordPress developers out there, I use MAMP for local development.
0 kommentar(er)
