wejrowski-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
2009-Apr-29 06:16 UTC
Driving me nuts!!! - Can''t connect to local MySQL server through socket ''/tmp/mysql.sock'' (2)
I had to put a new HD in, and now I''m reinstalling everything, and can''t get mysql to fully work. I can''t remember how I fixed it. I''ve searched everywhere online and can''t find anything. when I try to use the >mysql command I get this: Can''t connect to local MySQL server through socket ''/tmp/ mysql.sock'' (2) My first error came in installing mysql here: http://hivelogic.com/articles/view/installing-mysql-on-mac-os-x/ It was this step that messed me up: cd /usr/local/mysql sudo ./bin/mysql_install_db --user=mysql sudo chown -R mysql ./var I can cd the mysql folder, but when I run the second command I get this: Installing MySQL system tables... 090428 23:15:26 [ERROR] /usr/local/mysql/libexec/mysqld: Can''t find file: ''./mysql/db.frm'' (errno: 13) ERROR: 1017 Can''t find file: ''./mysql/db.frm'' (errno: 13) I''ve been on this for hours. anyone know?
Andrew Timberlake
2009-Apr-29 07:05 UTC
Re: Driving me nuts!!! - Can''t connect to local MySQL server through socket ''/tmp/mysql.sock'' (2)
On Wed, Apr 29, 2009 at 8:16 AM, wejrowski-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org <wejrowski-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > I had to put a new HD in, and now I''m reinstalling everything, and > can''t get mysql to fully work. I can''t remember how I fixed it. I''ve > searched everywhere online and can''t find anything. > > when I try to use the >mysql command I get this: > > Can''t connect to local MySQL server through socket ''/tmp/ > mysql.sock'' (2) > > My first error came in installing mysql here: > http://hivelogic.com/articles/view/installing-mysql-on-mac-os-x/ > > It was this step that messed me up: > cd /usr/local/mysql > sudo ./bin/mysql_install_db --user=mysql > sudo chown -R mysql ./var > > I can cd the mysql folder, but when I run the second command I get > this: > > Installing MySQL system tables... > 090428 23:15:26 [ERROR] /usr/local/mysql/libexec/mysqld: Can''t find > file: ''./mysql/db.frm'' (errno: 13) > ERROR: 1017 Can''t find file: ''./mysql/db.frm'' (errno: 13) > > > I''ve been on this for hours. anyone know?I''ve had this before, I installed mysql from an ubuntu package and suddenly it put the socket into /var/run/mysqld/mysqld.sock You can create or edit /etc/my.cnf and tell it where the socket file is created, just remember to add a line for each configuration group (i.e. [client], [mysqld] etc) You can also tell Rails where the socket is in database.yml Andrew Timberlake http://ramblingsonrails.com http://www.linkedin.com/in/andrewtimberlake "I have never let my schooling interfere with my education" - Mark Twain