I am using a MAMP server to host my laravel project. I am trying to push my database migrations table which I have created to the MAMP phpmyadmin database hosted on the localhost 8888 server.
I am attempting to import data from a csv file into an existing table in my database. It seems to be working fine, except that mysql does not accept NA as a value for columns represented by an int. Therefore I would like to change the values of NA to NULL while importing the file. Also, I would like to terminate a row from the table that uses NA as a primary key.
This would all be easy to change if the values were already in the database table, however the values are not getting added due to this error. For the record I use MAMP.
I am using PHP 5.5 and MAMP (downloaded from here):
I can’t seem to find the my.cnf or other config file for the MySQL that comes with MAMP. Does it not include one?
My MAMP mysql server won’t start. All of the suggestions I’ve seen on the web say to check for other mysqld processes running and kill them if they exist, and that it should fix the problem, but it has not for me.
Apache wont start and it throws an error:
I have both apache and mySQL running with the default MAMP ports (8888 and 8889 respectively) and everything seems to work, but when I switch the ports to 80 for Apache and 3306 for mySQL, the mySQL server is unable to restart.
Run the following command, replacing the port number with the one you use. This will start mysql minus the user permissions.
So I added the MySQL Connector/J 5.1.16 to my project’s Build Path. I’m using the default OSX Java package and MAMP Pro 1.9.4 with MySQL 5.1.44 and Eclipse.