![]() ![]() MAMP PRO creates a shell script in your Library folder. If you are using MAMP PRO there is an easier way to stop MySQL. Sh -c '/Applications/MAMP/Library/bin/mysqladmin -u root -proot -socket=/Applications/MAMP/tmp/mysql/mysql.sock shutdown'Īs a bonus, the indicators in the MAMP PRO.app GUI show the correct status of these apps in real time, so you can continue to rely on that. (for some reason you must hit enter again to regain your prompt) Sh -c '/Applications/MAMP/Library/bin/mysqld_safe -defaults-file=/Applications/MAMP/tmp/mysql/my.cnf -port=3306 -socket=/Applications/MAMP/tmp/mysql/mysql.sock -user=alex -pid-file=/Applications/MAMP/tmp/mysql/mysql.pid -log-error=/Applications/MAMP/logs/mysql_error_log.err -tmpdir=/Applications/MAMP/tmp/mysql/tmpdir -datadir=/Library/Application\ Support/appsolute/MAMP\ PRO/db/mysql &' Sudo /Applications/MAMP/Library/bin/httpd -f "/Library/Application Support/appsolute/MAMP PRO/conf/nf" -k restart MySQL Sudo /Applications/MAMP/Library/bin/httpd -f "/Library/Application Support/appsolute/MAMP PRO/conf/nf" -k stop Sudo /Applications/MAMP/Library/bin/httpd -f "/Library/Application Support/appsolute/MAMP PRO/conf/nf" -k start Also womble's answer provided helpful insight to the root of the error.Note that I have my ports set to the application's respective defaults (Apache: 80, MySQL: 3306), and as such these commands reflect that, AND you must use sudo with Apache (which you will in MAMP as well if you're using port 80). ![]() I know this is an old thread, but since it popped up now that I experienced the same issue, I figured I'd add the full solution to my own problem. olduser won't be using it any more), then it might be a good idea to also change the ownership of all the files: sudo chown -R newuser:admin /Applications/MAMP If, like in my case, the company laptop was passed from one user to the other (i.e. If newuser is also in the admin group then just add group read and write to the entire MAMP path: sudo chmod -R ug+rw /Applications/MAMP In a typical MAMP installation the ownership is likely set to olduser and the admin group (olduser:admin), with only user read/write permissions. ![]() Presumably it is because it was installed by a different user, and all files are owned by that user and write permissions are only set up for the files' owner. ![]() mysql/m ( /Applications/MAMP/db/mysql/mysql/m) This issue is related to the current user not having permissions to the file. Please run mysql_upgrade to create it.ġ10803 16:16:26 InnoDB: Started log sequence number 0 396676924ġ10803 16:16:26 /Applications/MAMP/Library/libexec/mysqld: Can't find file: './mysql/m' (errno: 13)ġ10803 16:16:26 Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/m' (errno: 13)ġ10803 16:16:26 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended Applications/MAMP/Library/libexec/mysqld: Can't find file: './mysql/m' (errno: 13)ġ10803 16:16:26 Can't open the ugin table. Here's the mysql log: 110803 16:16:26 Plugin 'FEDERATED' is disabled.ġ10803 16:16:26 Plugin 'ndbcluster' is disabled. I have already restarted the system several times, even checked /etc for the file my.cnf, but there's no my.cnf inside /etcĬouldn't find any form to ask for a support on and am desperately missing my Ubuntu now :-( I have also verified that no other instance of mysqld is running, still it won't run MySql on my system. In my old user, Apache doesn't start and in the new user, MySql doesn't start. I am pretty new to Mac itself but managed to find users with similar problems. I had MAMP successfully running in one of the user, but since I have created a new user to separate things between two developers, its throwing tantrums. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |