Advertisement
Guest User

Untitled

a guest
Apr 15th, 2016
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.86 KB | None | 0 0
  1. $ sudo service mysql start
  2. mysql start/running
  3.  
  4. $ mysql -u root
  5. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
  6.  
  7. $ aptitude search mysql |grep ^i
  8. i libapache2-mod-auth-mysql - Module Apache 2 pour l'authentification vi
  9. i libdbd-mysql-perl - Perl5 database interface to the MySQL data
  10. i libmysqlclient16 - MySQL database client library
  11. i mysql-client-5.1 - MySQL database client binaries
  12. i mysql-client-core-5.1 - MySQL database core client binaries
  13. i mysql-common - MySQL database common files, e.g. /etc/mys
  14. i mysql-server-5.1 - MySQL database server binaries and system
  15. i mysql-server-core-5.1 - MySQL database server binaries
  16. i php5-mysql - MySQL module for php5
  17.  
  18. sudo apt-get install mysql-server-5.1 --reinstall
  19.  
  20. sudo dpkg-reconfigure mysql-server-5.1
  21.  
  22. Mysql-u root-p
  23. Enter password:
  24. ERROR 2002 (HY000): Can not connect to local MySQL server-through socket '/ tmp / mysql.sock' (2)
  25.  
  26. # ps -fea | grep mysqld
  27. mysql 17661 14003 1 Feb19 ? 00:24:59 /usr/local/mysql-percona/libexec/mysqld --basedir=/usr/local/mysql-percona --datadir=/var/data/mysql/datadir/data --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log
  28. root 23790 7840 0 09:25 pts/0 00:00:00 grep mysqld
  29.  
  30. grep socket /etc/my.cnf
  31. socket=/var/lib/mysql/mysql.sock
  32.  
  33. [client]
  34. default-character-set=utf8
  35. socket=/var/lib/mysql/mysql.sock
  36.  
  37. I came to the similar error when I failed to upgrade mysql-server package, but I found this solved my problem.
  38. When `sudo apt-get install -f` doesn't work, try `sudo apt-get purge mysql*`. Now you can reinstall mysql-server.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement