Public bug reported: typing 'mysql -u root -p' in ubutu 11.04 terminal, I end up with the following error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
When i read to solve that on the Internet, it informs me to re-install it. Here is what I have done so far. sudo apt-get remove mysql-server libapache2-mod-auth-mysql php5-mysql sudo apt-get autoremove sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql At the end, I get the following error! che2-mod-auth-mysql php5-mysql Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: mysql-server-5.1 mysql-server-core-5.1 Suggested packages: tinyca mailx The following NEW packages will be installed: libapache2-mod-auth-mysql mysql-server mysql-server-5.1 mysql-server-core-5.1 php5-mysql 0 upgraded, 5 newly installed, 0 to remove and 160 not upgraded. Need to get 11.0 MB of archives. After this operation, 25.9 MB of additional disk space will be used. Do you want to continue [Y/n]? y Get:1 http://et.archive.ubuntu.com/ubuntu/ natty/main mysql-server-core-5.1 i386 5.1.54-1ubuntu4 [4,627 kB] Get:2 http://et.archive.ubuntu.com/ubuntu/ natty/main mysql-server-5.1 i386 5.1.54-1ubuntu4 [6,258 kB] Get:3 http://et.archive.ubuntu.com/ubuntu/ natty/main libapache2-mod-auth-mysql i386 4.3.9-13ubuntu1 [25.9 kB] Get:4 http://et.archive.ubuntu.com/ubuntu/ natty/main mysql-server all 5.1.54-1ubuntu4 [6,828 B] Get:5 http://et.archive.ubuntu.com/ubuntu/ natty-updates/main php5-mysql i386 5.3.5-1ubuntu7.3 [65.8 kB] Fetched 11.0 MB in 9min 27s (19.3 kB/s) Preconfiguring packages ... Selecting previously deselected package mysql-server-core-5.1. (Reading database ... 157774 files and directories currently installed.) Unpacking mysql-server-core-5.1 (from .../mysql-server-core-5.1_5.1.54-1ubuntu4_i386.deb) ... Selecting previously deselected package mysql-server-5.1. Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.54-1ubuntu4_i386.deb) ... egrep: /etc/mysql/: No such file or directory Selecting previously deselected package libapache2-mod-auth-mysql. Unpacking libapache2-mod-auth-mysql (from .../libapache2-mod-auth-mysql_4.3.9-13ubuntu1_i386.deb) ... Selecting previously deselected package mysql-server. Unpacking mysql-server (from .../mysql-server_5.1.54-1ubuntu4_all.deb) ... Selecting previously deselected package php5-mysql. Unpacking php5-mysql (from .../php5-mysql_5.3.5-1ubuntu7.3_i386.deb) ... Processing triggers for man-db ... Processing triggers for ureadahead ... Processing triggers for libapache2-mod-php5 ... * Reloading web server config apache2 apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName [ OK ] Setting up mysql-server-core-5.1 (5.1.54-1ubuntu4) ... Setting up mysql-server-5.1 (5.1.54-1ubuntu4) ... 111212 18:45:04 [Note] Plugin 'FEDERATED' is disabled. 111212 18:45:04 InnoDB: Initializing buffer pool, size = 8.0M 111212 18:45:04 InnoDB: Completed initialization of buffer pool 111212 18:45:05 InnoDB: Started; log sequence number 0 44233 111212 18:45:05 InnoDB: Starting shutdown... 111212 18:45:10 InnoDB: Shutdown completed; log sequence number 0 44233 start: Job failed to start invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.1 (--configure): subprocess installed post-installation script returned error exit status 1 Setting up libapache2-mod-auth-mysql (4.3.9-13ubuntu1) ... dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.1; however: Package mysql-server-5.1 is not configured yet. dpkg: error processing mysql-server (--configure): dependency problems - leaving unconfigured Setting up php5-mysql (5.3.5-1ubuntu7.3) ... No apport report written because the error message indicates its a followup error from a previous failure. Errors were encountered while processing: mysql-server-5.1 mysql-server E: Sub-process /usr/bin/dpkg returned an error code (1) ProblemType: Package DistroRelease: Ubuntu 11.04 Package: mysql-server-5.1 5.1.54-1ubuntu4 ProcVersionSignature: Ubuntu 2.6.38-13.52-generic 2.6.38.8 Uname: Linux 2.6.38-13-generic i686 Architecture: i386 Date: Mon Dec 12 18:45:27 2011 ErrorMessage: subprocess installed post-installation script returned error exit status 1 InstallationMedia: Ubuntu 11.04 "Natty Narwhal" - Release i386 (20110427.1) SourcePackage: mysql-5.1 Title: package mysql-server-5.1 5.1.54-1ubuntu4 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1 UpgradeStatus: No upgrade log present (probably fresh install) ** Affects: mysql-5.1 (Ubuntu) Importance: Undecided Status: New ** Tags: apport-package i386 natty -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/903259 Title: package mysql-server-5.1 5.1.54-1ubuntu4 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/903259/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs