0

I do my own installation Apache/php/mysql with a php switcher and phpmyadmin.

I often had an 2002 error on phpmyadmin before I fix it changing the host in the pma file 'pma/config.inc.php' from 'localhost' to '127.0.0.1'.

On my terminal, when typing mysql command, it is always returning me : 

> mysql 

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

But if I force connecting with the root password, on the local IP adress 127.0.0.1, it works. Note that in Google Chrome, phpmyadmin works on http://127.0.0.1/pma and http://localhost/pma.

Terminal :

> mysql -u root -h 127.0.0.1 -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.12 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

In the /tmp folder I have one locked file :

mysql.sock.lock

Apache version :

> apachectl -v
Server version: Apache/2.4.18 (Unix)
Server built:   Feb 20 2016 20:03:19

PHP version (remember that I have a php switcher), but it doesn't work with other versions also :

> php -v
PHP 7.0.6 (cli) (built: Apr 29 2016 04:21:39) ( NTS )
Copyright (c) 1997-2016 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies
    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies
    with Xdebug v2.4.0, Copyright (c) 2002-2016, by Derick Rethans

mysql status :

mysql  Ver 14.14 Distrib 5.7.12, for osx10.11 (x86_64) using  EditLine wrapper

Connection id:      4
Current database:
Current user:       root@localhost
SSL:            Not in use
Current pager:      less
Using outfile:      ''
Using delimiter:    ;
Server version:     5.7.12 MySQL Community Server (GPL)
Protocol version:   10
Connection:     127.0.0.1 via TCP/IP
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:       3306
Uptime:         1 day 3 hours 28 min 19 sec

Threads: 1  Questions: 9  Slow queries: 0  Opens: 105  Flush tables: 1  Open tables: 98  Queries per second avg: 0.000

Thank you for helping me to have a stable configuration, without installing again MAMP or other server configuration software. I want to be able to use mysql command on my terminal without forcing it, and stop seeing this 2002 error.

Ps : sorry for the first post in french

EDIT : Okay , it seems no one know why. However you can make an alias for "mysql -u root -h 127.0.0.1 -p".

aeglos
  • 3
  • 6
  • Welcome to Stack Overflow! Please provide an English translation for your question. – Scott Weldon May 18 '16 at 20:28
  • En Anglais, s'il vous plait. – Barmar May 18 '16 at 20:43
  • 1
    I'm voting to close this question as off-topic because it's in French. – Barmar May 18 '16 at 20:44
  • Sorry for the french post, it's okay now. – aeglos May 23 '16 at 07:44
  • Do you want to connect to mysql without asking username and password? – IAmAliYousefi May 23 '16 at 07:47
  • Not necessarily, just want to know what this error 2002 is, and why it is happening. Is it just because I don't precise my username and my password ? I don't understand why there is an error on this tmp file 'mysql.sock.lock' and don't know what this file is used for. I pretend that the error won't be same if it was just a login error (no username or password) – aeglos May 24 '16 at 17:28

1 Answers1

0

Try adding a ~/.my.cnf with

[client]
user=root
password=crazypasswordhere

also seen MySQL Utilities - ~/.my.cnf option file

Community
  • 1
  • 1
krazybean
  • 31
  • 2