Mysql manager of pid file quit without updating fi
Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange 130319 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 130319 [Warning] '--skip-locking' is deprecated and will be removed in a future release. 130319 [Warning] '--log' is deprecated and will be removed in a future release. ^G/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 130319 [ERROR] Can't open the mysql.plugin table. 130319 Inno DB: Initializing buffer pool, size = 8.0M 130319 Inno DB: Completed initialization of buffer pool 130319 Inno DB: Operating system error number 13 in a file operation.
Had the same issue, for me it was doing a brew remove while having a previous install of the mysqld running.
Seems brew does not stop a service before uninstalling. Fix the 2002 My SQL Socket error Fix the looming 2002 socket error – which is linking where My SQL places the socket and where OSX thinks it should be, My SQL puts it in /tmp and OSX looks for it in /var/mysql the socket is a type of file that allows mysql client/server communication.
In this article, we have listed the most common fixes which work on most cases.
[mysqld] port = 3306 socket = /tmp/skip-external-locking key_buffer_size = 16K pid-file=/var/run/mysqld/[mysqld_safe] log-error=/var/log/pid-file=/var/run/mysqld/The solution that worked for me was here: https://serverfault.com/questions/334284/cant-create-pid-file-on-mysql-server-permission-denied Changing some of my permissions seemed to do the trick.
I copied the pid file from the server that is working to the one that isn't.
Please take note that you need to run mysql_install_db from the with top level of the mysql directory (IE, usr/local/Cellar/mysql/5.5.25).so scripts/mysql_install_db sets up camp in /usr/local/mysql/var, but the rest of the application seems to want to do its work in /usr/local/mysql/data!So I just edited /etc/and under the section [mysqld] I added a directive to explicitly point mysql's data directory to var (as I normally expect it to be any how), and after doing so, mysqld starts up just fine.If not a bad config setting, the error log should at least point you in the right direction.Well, I assume the OP has fixed it at this point...