Can t connect to local MySQL server through socket homebrew

Question

I recently tried installing MySQL with homebrew  brew install mysql  and when I try to run it I get the following error      ERROR 2002  HY000   Can t connect to local MySQL server through socket   tmp mysql sock   2    There is no  tmp mysql sock nor a  var lib mysql sock   I ve searched and haven t found any mysql sock file   How can I fix this

User · Answer

Just to add to these answers  In my case I had no local mySQL server  it was running inside a docker container  So the socket file does not exist and will not be accessible for the  mysql  client   The sock file gets created by mysqld and mysql uses this to communicate with it  However if your mySql server is not running local  it does not require the sock file   By specifying a host name ip the sock file is not required e g    mysql --host 127 0 0 1 --port 3306 --user xyz --password xyz

User · Answer

I got the same error and this is what helped me    ln -sfv  usr local opt mysql   plist   Library LaunchAgents  launchctl load   Library LaunchAgents homebrew mxcl mysql plist  mysql -uroot mysql gt

User · Answer

In my case  the culprit was found in the logfiles     tail  usr local var mysql  lt hostname gt  lan err 2019-09-19  7 32 21 0  ERROR  InnoDB  redo log file    ib logfile0  exists  Creating system tablespace with existing redo log files is not recommended  Please delete all redo log files before creating new system tablespace  2019-09-19  7 32 21 0  ERROR  InnoDB  Database creation was aborted with error Generic error  You may need to delete the ibdata1 file before trying to start up again    So I renamed ib logfile0 to get rid of the error  I had to do the same with ib logfile1 afterwards    mv  usr local var mysql ib logfile0  usr local var mysql ib logfile0 bak mv  usr local var mysql ib logfile1  usr local var mysql ib logfile1 bak brew services restart mariadb

User · Answer

Since I spent quite some time trying to solve this and always came back to this page when looking for this error  I ll leave my solution here hoping that somebody saves the time I ve lost  Although in my case I am using mariadb rather than MySql  you might still be able to adapt this solution to your needs   My problem  is the same  but my setup is a bit different  mariadb instead of mysql    Installed mariadb with homebrew     brew install mariadb   Started the daemon     brew services start mariadb   Tried to connect and got the above mentioned error    mysql -uroot ERROR 2002  HY000   Can t connect to local MySQL server through socket   tmp mysql sock   2    My solution  find out which my cnf files are used by mysql  as suggested in this comment      mysql --verbose --help   grep my cnf  usr local etc my cnf    my cnf                         order of preference  my cnf   MYSQL TCP PORT    check where the Unix socket file is running  almost as described here      netstat -ln   grep mariadb       usr local mariadb data mariadb sock    you might want to grep mysql instead of mariadb   Add the socket file you found to    my cnf  create the file if necessary  assuming    my cnf was listed when running the mysql --verbose    -command from above     client  socket    usr local mariadb data mariadb sock   Restart your mariadb     brew services restart mariadb   After this I could run mysql and got     mysql -uroot ERROR 1698  28000   Access denied for user  root   localhost    So I run the command with superuser privileges instead and after entering my password I got     sudo mysql -uroot MariaDB   none   gt      Notes    I m not quite sure about the groups where you have to add the socket  first I had it  client-server  but then I figured  client  should be enough  So I changed it and it still works  When running mariadb config   grep socket I get  --socket   tmp mysql sock  which is a bit confusing since it seems that  usr local mariadb data mariadb sock is the actual place  at least on my machine  I wonder where I can configure the  usr local mariadb data mariadb sock to actually be  tmp mysql sockso I can use the default settings instead of having to edit my  my cnf  but I m too tired now to figure that out     At some point I also did things mentioned in other answers before coming up with this

User · Answer

If  quot mysqld quot  IS running  it s possible your data is corrupted  Try running this  mysqld  Read through the wall of data  and check if mysqld is reporting that the database is corrupted  Corruption can present in many unintuitive ways   mysql -uroot returns  quot ERROR 2002  HY000   Can t connect to local MySQL server through socket   tmp mysql sock   2  quot   mysql server start returns  quot ERROR  The server quit without updating PID quot   Sequel Pro and MySQL Workbench responds that they can t connect to MySQL on localhost or 127 0 0 1   To recover your data  open my cnf and add the following line in the  mysqld  section  innodb force recovery 1  Restart mysqld    brew services restart mysql 5 6  Now you can connect to it  but it   s in limited read-only mode  If you re using InnoDB  run this to export all your data    mysqldump -u root -p --all-databases --add-drop-database --add-drop-table  gt  data-recovery sql  The file is created in your   dir  It may take some time  Once finished  remove innodb force recovery 1 from my cnf  then restart mysql in normal mode    brew services restart mysql 5 6  Drop all the databases  I did this using Sequel Pro  This deletes all your original data  Make sure your data-recovery sql looks good before doing this  Also consider backing up  usr local var mysql to be extra careful  Then restore the databases  tables  and data with this    mysql -uroot  lt    data-recovery sql  This can be a long import restoration process  Once complete  you   re good to go  Thanks go to https   severalnines com database-blog my-mysql-database-corrupted-what-do-i-do-now for the recovery instructions  The link has further instructions on MyISAM recovery

User · Answer

Looks like your mysql server is not started  I usually run the stop command and then start it again   mysqld stop mysql server start   Same error  and this works for me

User · Answer

You ll need to run mysql install db - easiest way is if you re in the install directory      cd  usr local Cellar mysql  lt version gt      mysql install db   Alternatively  you can feed mysql install db a basedir parameter like the following     mysql install db --basedir    brew --prefix mysql

User · Answer

After installing macos mojave  had to wipe mysql folder under  usr local var mysql and then reinstall via brew install mysql otherwise permission related things would come up all over the place

User · Answer

After a restart I could not connect with the local mariadb  a search also brought me to this page and I wanted to share my solution with you   I noticed that the directory my cnf d in  usr local etc  is missing    This is a known bug with homebrew that is described and solved there  https   github com Homebrew homebrew-core issues 36801  fast way to fix  mkdir  usr local etc my cnf d

User · Answer

This works for me  brew upgrade mysql

User · Answer

I had some directories left from another mysql 8 0  installation  that were not removed   I solved this by doing the following   First uninstall mysql  brew uninstall mysql 5 6   Delete the folders files that were not removed  rm -rf  usr local var mysql rm  usr local etc my cnf   Reinstall mysql and link it  brew install mysql 5 6 brew link --force mysql 5 6   Enable and start the service  brew services start mysql 5 6

User · Answer

I faced the same problem on my mac and solved it  by following the following tutorials  https   mariadb com resources blog installing-mariadb-10116-mac-os-x-homebrew  But don t forget to kill or uninstall the old version before continuing   Commands   brew uninstall mariadb  xcode-select --install  ruby -e    curl -fsSL https   raw githubusercontent com Homebrew install master install   - See more at  https   mariadb com resources blog installing-mariadb-10116-mac-os-x-homebrew sthash XQoxRoJp dpuf  brew doctor  brew update  brew info mariadb  brew install mariadb  mysql install db  mysql server start

User · Answer

The file  tmp mysql sock is probably a Named-Pipe  since it s in a temporary folder  A named pipe is a Special-File that never gets permanently stored    If we make two programs  and we want one program to send a message to another program  we could create a text file  We have one program write something in the text file and the other program read what our other program wrote  That s what a pipe is  except it doesn t write the file to our computer hard disk  IE doesn t permanently store the file  like we do when we create a file and save it    A Socket is the exact same as a Pipe  The difference is that Sockets are usually used over a network -- between computers  A Socket sends information to another computer  or receives information from another computer  Both Pipes and Sockets use a temporary file to share so that they can  communicate    It s difficult to discern which one MySql is using in this case  Doesn t matter though   The command mysql server start should get the  server   program  running its infinite loop that will create that special-file and wait for changes  listen for writes    After that  a common issue might be that the MySql program doesn t have permission to create a file on your machine  so you might have to give it root privileges   sudo mysql server start

User · Answer

If you are able to see  quot mysql stopped quot  when you run below command  brew services list   and if you are able to start mysql with below command  mysql server start    this means  mysql is able to start manually  but it doesn t start automatically when the operating system is started  Adding mysql to services will fix this problem  To do so  you can run below command  brew services start mysql  After that  you may restart your operating system and try connecting to mysql to see if it started automatically  I did the same and stop receiving below error   ERROR 2002  HY000   Can t connect to local MySQL server through socket   tmp mysql sock   2   I hope this helps

User · Answer

Try to connect using  127 0 0 1  instead  localhost

User · Answer

When you got the server running via  mysql server start  you should see the socket in  tmp mysql sock  However  the system seems to expect it in  var mysql mysql sock  To fix this  you have to create a symlink in  var mysql   sudo mkdir  var mysql sudo ln -s  tmp mysql sock  var mysql mysql sock  This solved it for me  Now my phpMyAdmin works happily with localhost and 127 0 0 1  Credit goes to Henry

User · Answer

I had same problem  After trying all these methods without success I did the following    tail -f the-mysql-or-maria-db-error-file err   in another console   brew services restart mariadb   I saw the following error        MAC HOMEBREW Crash recovery failed  Either correct the problem  if   it s  for example  out of memory error  and restart  or delete tc log   and start mysqld with    So I changed the tc log extesion to tc log txt and restart mariadb   brew services restart mariadb   and done

User · Answer

When running mysql secure installation and entering the new password I got    Error  Can t connect to local MySQL server through socket   tmp mysql sock   2    I noticed when trying the following from this answer   netstat -ln   grep mysql   It didn t return anything  and I took that to mean that there wasn t a  sock file  So  I added the following to my my cnf file  either in  etc my cnf or in my case   usr local etc my cnf   Under   mysqld  socket  tmp mysql sock  Under   client  socket  tmp mysql sock  This was based on this post  Then stop start mysql again and retried mysql secure installation which finally let me enter my new root password and continue with other setup preferences

User · Answer

For me  I had installed mariadb long time ago  then installed mysql 5 7  When I executed mysql -uroot  I get the error  ERROR 2002  HY000   Can t connect to local MySQL server through socket   tmp mysql sock   2  Reading the answers   I uninstalled mariadb Deleted the folder  usr local var mysql Ran the command mysqld --initialize  Then I was able to mysql -uroot -p

User · Answer

I manually started mysql in the system preferences pane by initialising the database and then starting it  This solved my problem

User · Answer

just to complete this thread  therefore MAMP  PRO  is used pretty often  the path here is   Applications MAMP tmp mysql mysql sock

[mysql] Can't connect to local MySQL server through socket homebrew

Examples related to mysql

Examples related to homebrew