Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

[vadlo]

И снова ERROR 2002 (HY000)

Добрый вечер! У меня Ubuntu 10.04, устанавливал мускул с оглядкой на http://www.jonathanmoeller.com/screed/?p=1781. Когда дошёл до mysql_secure installation, случилось страшное:

Код: [Выделить]

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)Ни одно из кучи решений, найденных в гугле, не помогло. Если вдруг кто недавно сталкивался с такой проблемой, подскажите, как справились? И ещё: наверняка придётся переустанавливать мускул, скажите, как полностью очистить от него сервер? apt-get purge достаточно? Видимо, нет: у меня при повторной установке появляется http://h1813090.stratoserver.net/files/share/3_4_2011/Jj4LGeruZ0WzzlksU4565Q.jpg

[vasilisc]

Код: [Выделить]

sudo apt-get purge mysql-server
sudo updatedb
locate mysql
найдите ошмётки mysql с помощью locate mysql и удалите вдумчиво

Код: [Выделить]

sudo apt-get -o DPkg::options::=--force-confmiss --reinstall install mysql-server


[vadlo]

vasilisc, я кстати встречал ваш комментарий, где вы говорили "удалить вдумчиво" =) Но дело в том, что я чайн не очень хорошо в этом разбираюсь и не знаю, что надо удалять, а что нет. Подскажите?

[vasilisc]

сделайте

Код: [Выделить]

sudo apt-get purge mysql-server
sudo updatedb
locate mysql
и сюда в спойлер киньте вывод locate mysql
подскажем

[vadlo]

Сделал

apt-get purge mysql-server mysql-server-5.0 mysql-server-5.1
apt-get purge mysql-client mysql-client-5.0 mysql-client-5.1
apt-get autoremove
updatedb

locate mysql вывело:

(Нажмите, чтобы показать/скрыть)

/.mysql.15443
/.mysql.16173
/.mysql.22096
/etc/mysql
/etc/mysql/conf.d
/etc/mysql/debian.cnf
/etc/mysql/my.cnf
/etc/php5/conf.d/mysql.ini
/etc/php5/conf.d/mysqli.ini
/etc/php5/conf.d/pdo_mysql.ini
/root/.mysql.28367
/usr/lib/libmysqlclient.so.16
/usr/lib/libmysqlclient.so.16.0.0
/usr/lib/libmysqlclient_r.so.16
/usr/lib/libmysqlclient_r.so.16.0.0
/usr/lib/php5/20090626+lfs/mysql.so
/usr/lib/php5/20090626+lfs/mysqli.so
/usr/lib/php5/20090626+lfs/pdo_mysql.so
/usr/share/mysql-common
/usr/share/doc/libmysqlclient16
/usr/share/doc/mysql-common
/usr/share/doc/php5-mysql
/usr/share/doc/libmysqlclient16/EXCEPTIONS-CLIENT.gz
/usr/share/doc/libmysqlclient16/changelog.Debian.gz
/usr/share/doc/libmysqlclient16/changelog.gz
/usr/share/doc/libmysqlclient16/copyright
/usr/share/doc/mysql-common/changelog.Debian.gz
/usr/share/doc/mysql-common/changelog.gz
/usr/share/doc/mysql-common/copyright
/usr/share/lintian/overrides/mysql-common
/usr/share/man/man5/mysql_table.5.gz
/usr/share/mysql-common/internal-use-only
/usr/share/mysql-common/internal-use-only/_etc_logrotate.d_mysql-server
/usr/share/mysql-common/internal-use-only/_etc_mysql_debian-start
/usr/share/vim/vim72/syntax/mysql.vim
/var/cache/apt/archives/libdbd-mysql-perl_4.012-1ubuntu1_i386.deb
/var/cache/apt/archives/libmysqlclient16_5.1.41-3ubuntu12.7_i386.deb
/var/cache/apt/archives/libmysqlclient16_5.1.41-3ubuntu12_i386.deb
/var/cache/apt/archives/mysql-client-5.1_5.1.41-3ubuntu12.7_i386.deb
/var/cache/apt/archives/mysql-client-5.1_5.1.41-3ubuntu12_i386.deb
/var/cache/apt/archives/mysql-client-core-5.1_5.1.41-3ubuntu12.7_i386.deb
/var/cache/apt/archives/mysql-client-core-5.1_5.1.41-3ubuntu12_i386.deb
/var/cache/apt/archives/mysql-client_5.1.41-3ubuntu12_all.deb
/var/cache/apt/archives/mysql-common_5.1.41-3ubuntu12.7_all.deb
/var/cache/apt/archives/mysql-common_5.1.41-3ubuntu12_all.deb
/var/cache/apt/archives/mysql-server-5.1_5.1.41-3ubuntu12.7_i386.deb
/var/cache/apt/archives/mysql-server-5.1_5.1.41-3ubuntu12_i386.deb
/var/cache/apt/archives/mysql-server-core-5.1_5.1.41-3ubuntu12.7_i386.deb
/var/cache/apt/archives/mysql-server-core-5.1_5.1.41-3ubuntu12_i386.deb
/var/cache/apt/archives/mysql-server_5.1.41-3ubuntu12_all.deb
/var/cache/apt/archives/php5-mysql_5.3.2-1ubuntu4_i386.deb
/var/lib/mysql
/var/lib/dpkg/info/libmysqlclient16.list
/var/lib/dpkg/info/libmysqlclient16.md5sums
/var/lib/dpkg/info/libmysqlclient16.postinst
/var/lib/dpkg/info/libmysqlclient16.postrm
/var/lib/dpkg/info/libmysqlclient16.shlibs
/var/lib/dpkg/info/mysql-common.conffiles
/var/lib/dpkg/info/mysql-common.list
/var/lib/dpkg/info/mysql-common.md5sums
/var/lib/dpkg/info/mysql-common.postrm
/var/lib/dpkg/info/mysql-common.preinst
/var/lib/dpkg/info/php5-mysql.conffiles
/var/lib/dpkg/info/php5-mysql.list
/var/lib/dpkg/info/php5-mysql.md5sums
/var/lib/mysql/debian-5.1.flag
/var/lib/mysql/ib_logfile0
/var/lib/mysql/ib_logfile1
/var/lib/mysql/ibdata1
/var/lib/mysql/livetomeet.err
/var/lib/mysql/mysql
/var/lib/mysql/mysql/columns_priv.MYD
/var/lib/mysql/mysql/columns_priv.MYI
/var/lib/mysql/mysql/columns_priv.frm
/var/lib/mysql/mysql/db.MYD
/var/lib/mysql/mysql/db.MYI
/var/lib/mysql/mysql/db.frm
/var/lib/mysql/mysql/event.MYD
/var/lib/mysql/mysql/event.MYI
/var/lib/mysql/mysql/event.frm
/var/lib/mysql/mysql/func.MYD
/var/lib/mysql/mysql/func.MYI
/var/lib/mysql/mysql/func.frm
/var/lib/mysql/mysql/general_log.CSM
/var/lib/mysql/mysql/general_log.CSV
/var/lib/mysql/mysql/general_log.frm
/var/lib/mysql/mysql/help_category.MYD
/var/lib/mysql/mysql/help_category.MYI
/var/lib/mysql/mysql/help_category.frm
/var/lib/mysql/mysql/help_keyword.MYD
/var/lib/mysql/mysql/help_keyword.MYI
/var/lib/mysql/mysql/help_keyword.frm
/var/lib/mysql/mysql/help_relation.MYD
/var/lib/mysql/mysql/help_relation.MYI
/var/lib/mysql/mysql/help_relation.frm
/var/lib/mysql/mysql/help_topic.MYD
/var/lib/mysql/mysql/help_topic.MYI
/var/lib/mysql/mysql/help_topic.frm
/var/lib/mysql/mysql/host.MYD
/var/lib/mysql/mysql/host.MYI
/var/lib/mysql/mysql/host.frm
/var/lib/mysql/mysql/ndb_binlog_index.MYD
/var/lib/mysql/mysql/ndb_binlog_index.MYI
/var/lib/mysql/mysql/ndb_binlog_index.frm
/var/lib/mysql/mysql/plugin.MYD
/var/lib/mysql/mysql/plugin.MYI
/var/lib/mysql/mysql/plugin.frm
/var/lib/mysql/mysql/proc.MYD
/var/lib/mysql/mysql/proc.MYI
/var/lib/mysql/mysql/proc.frm
/var/lib/mysql/mysql/procs_priv.MYD
/var/lib/mysql/mysql/procs_priv.MYI
/var/lib/mysql/mysql/procs_priv.frm
/var/lib/mysql/mysql/servers.MYD
/var/lib/mysql/mysql/servers.MYI
/var/lib/mysql/mysql/servers.frm
/var/lib/mysql/mysql/slow_log.CSM
/var/lib/mysql/mysql/slow_log.CSV
/var/lib/mysql/mysql/slow_log.frm
/var/lib/mysql/mysql/tables_priv.MYD
/var/lib/mysql/mysql/tables_priv.MYI
/var/lib/mysql/mysql/tables_priv.frm
/var/lib/mysql/mysql/time_zone.MYD
/var/lib/mysql/mysql/time_zone.MYI
/var/lib/mysql/mysql/time_zone.frm
/var/lib/mysql/mysql/time_zone_leap_second.MYD
/var/lib/mysql/mysql/time_zone_leap_second.MYI
/var/lib/mysql/mysql/time_zone_leap_second.frm
/var/lib/mysql/mysql/time_zone_name.MYD
/var/lib/mysql/mysql/time_zone_name.MYI
/var/lib/mysql/mysql/time_zone_name.frm
/var/lib/mysql/mysql/time_zone_transition.MYD
/var/lib/mysql/mysql/time_zone_transition.MYI
/var/lib/mysql/mysql/time_zone_transition.frm
/var/lib/mysql/mysql/time_zone_transition_type.MYD
/var/lib/mysql/mysql/time_zone_transition_type.MYI
/var/lib/mysql/mysql/time_zone_transition_type.frm
/var/lib/mysql/mysql/user.MYD
/var/lib/mysql/mysql/user.MYI
/var/lib/mysql/mysql/user.frm
/var/lib/update-rc.d/mysql
/var/log/mysql
/var/log/mysql.err
/var/log/mysql.log
/var/log/mysql.log.1
/var/log/mysql.log.2.gz
/var/log/mysql.log.3.gz
/var/log/mysql.log.4.gz
/var/log/mysql.log.5.gz
/var/log/mysql/error.log
/var/log/mysql/error.log-old

Пользователь решил продолжить мысль 03 Апреля 2011, 23:44:54:Вот ещё на всякий случай:

root@livetomeet:/# dpkg -l | grep mysql

(Нажмите, чтобы показать/скрыть)

ii  libmysqlclient16                5.1.41-3ubuntu12.7       MySQL database client library
ii  mysql-common                    5.1.41-3ubuntu12.7       MySQL database common files (e.g. /etc/mysql
ii  php5-mysql                      5.3.2-1ubuntu4           MySQL module for php5

[vasilisc]

попробуйте без удаления каких-либо каталогов

Код: [Выделить]

sudo apt-get -o DPkg::options::=--force-confmiss --reinstall install mysql-server

[vadlo]

После повторного ввода пароля получил:

(Нажмите, чтобы показать/скрыть)

Selecting previously deselected package libnet-daemon-perl.
(Reading database ... 17576 files and directories currently installed.)
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.43-1_all.deb) ...
Selecting previously deselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ...
Selecting previously deselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.609-1build1_i386.deb) ...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.012-1ubuntu1_i386.deb) ...
Selecting previously deselected package mysql-client-core-5.1.
Unpacking mysql-client-core-5.1 (from .../mysql-client-core-5.1_5.1.41-3ubuntu12.7_i386.deb) ...
Selecting previously deselected package mysql-client-5.1.
Unpacking mysql-client-5.1 (from .../mysql-client-5.1_5.1.41-3ubuntu12.7_i386.deb) ...
Selecting previously deselected package mysql-server-core-5.1.
Unpacking mysql-server-core-5.1 (from .../mysql-server-core-5.1_5.1.41-3ubuntu12.7_i386.deb) ...
Selecting previously deselected package mysql-server-5.1.
Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.41-3ubuntu12.7_i386.deb) ...
Selecting previously deselected package libhtml-template-perl.
Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.9-1_all.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.1.41-3ubuntu12.7_all.deb) ...
Processing triggers for man-db ...
Setting up libnet-daemon-perl (0.43-1) ...
Setting up libplrpc-perl (0.2020-2) ...
Setting up libdbi-perl (1.609-1build1) ...
Setting up libdbd-mysql-perl (4.012-1ubuntu1) ...
Setting up mysql-client-core-5.1 (5.1.41-3ubuntu12.7) ...
Setting up mysql-client-5.1 (5.1.41-3ubuntu12.7) ...
Setting up mysql-server-core-5.1 (5.1.41-3ubuntu12.7) ...
Setting up mysql-server-5.1 (5.1.41-3ubuntu12.7) ...

Configuration file `/etc/apparmor.d/usr.sbin.mysqld', does not exist on system.
Installing new config file as you requested.

Configuration file `/etc/logrotate.d/mysql-server', does not exist on system.
Installing new config file as you requested.

Configuration file `/etc/mysql/conf.d/mysqld_safe_syslog.cnf', does not exist on system.
Installing new config file as you requested.

Configuration file `/etc/mysql/debian-start', does not exist on system.
Installing new config file as you requested.

Configuration file `/etc/init/mysql.conf', does not exist on system.
Installing new config file as you requested.

Configuration file `/etc/logcheck/ignore.d.workstation/mysql-server-5_1', does not exist on system.
Installing new config file as you requested.

Configuration file `/etc/logcheck/ignore.d.server/mysql-server-5_1', does not exist on system.
Installing new config file as you requested.

Configuration file `/etc/logcheck/ignore.d.paranoid/mysql-server-5_1', does not exist on system.
Installing new config file as you requested.
110403 19:51:40 [Note] Plugin 'FEDERATED' is disabled.
110403 19:51:40  InnoDB: Started; log sequence number 0 44233
110403 19:51:40  InnoDB: Starting shutdown...
110403 19:51:41  InnoDB: Shutdown completed; log sequence number 0 44233

... и тут так и висит.
Пользователь решил продолжить мысль 04 Апреля 2011, 00:20:06:...и висит...
Пользователь решил продолжить мысль 04 Апреля 2011, 11:52:52:Не бросайте меня, пожалуйста
Пользователь решил продолжить мысль 05 Апреля 2011, 01:44:09:Такие вот вы, убунтоиды...