All geek questions in one place

MAMP mysql not starting

Received error: 2002: it was not possible to connect to the local MySQL server through the socket '/Applications/MAMP/tmp/mysql/mysql.sock' (2) when trying to connect 150629 15:44:35 mysqld_safe Starting the mysqld daemon with databases from / Applications / MAMP / db / mysql 150629 15:44:35 [Warning] You forcibly replaced lower_case_table_names with 0 using the command line, even if your file system '/ Applications / MAMP / db / mysql /' is not case sensitive. This means that you can damage the MyISAM table by accessing it in different cases. You should consider changing the lower_set_data to 1 or 2 150629 15:44:35 [Note] The 'FEDERATED' plugin is disabled. 150629 15:44:35 [Note] The plugin 'ndbcluster' is disabled. / Applications / MAMP / Library / libexec / mysqld: Cannot find file: './mysql/plugin.frm' (errno: 13) 150629 15:44:35 [ERROR] Cannot open the mysql.plugin table. To create it, run mysql_upgrade. 150629 15:44:35 InnoDB: Started; journal serial number 1 402900962 150629 15:44:35 [ERROR] / Applications / MAMP / Library / libexec / mysqld: Cannot find file: ./ mysql / host.frm (errno: 13) 150629 15:44:35 [ERROR ] Fatal error: Cannot open and lock privilege tables: Cannot find file: ./ mysql / host.frm (errno: 13) 150629 15:44:35 mysqld_safe mysqld from pid / Applications / MAMP / tmp / mysql / mysql. pid is over

I can not find the mysql.sock file anywhere. This is MAMP 1.9 for OS X version 10.8.5

-1
source share
1 answer

The first thing to try is to change the ownership of the MySQL datadir, for example, if you start MySQL with the mysql user:

chown -R mysql:mysql /path/to/datadir

check the permissions on the directory / Applications / MAMP / tmp / mysql / to create the socket.

+1
source

Source: https://habr.com/ru/post/1263027/

More articles:


All Articles