Public bug reported: The mysql root password stopped working from mysql workbench and the command-line. I tried resetting the root password and got me an error stating the root password could not be reset.
So I completely uninstalled (generally following these directions http://stuffthatspins.com/2011/01/08/ubuntu-10-x-completely-remove-and- clean-mysql-installation/) and reinstalled mysql-server, mysql-common, mysql-client & mysql-workbench. I was prompted to enter a root password and it was accepted successfully, but we given a warning that the root password could not be applied to the mysql instance. Here is my output for the entire apt-get install: sudo apt-get install mysql-server mysql-common mysql-client mysql-workbench Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: libctemplate0 libdbd-mysql-perl libgtkmm-2.4-1c2a libmysqlclient18 libtinyxml2.6.2 libzip2 mysql-client-5.5 mysql-server-5.5 mysql-workbench-data python-all python-mysql.connector python-pysqlite2 python-support Suggested packages: libterm-readkey-perl tinyca mailx python-pysqlite2-doc python-pysqlite2-dbg Recommended packages: mysql-utilities The following NEW packages will be installed: libctemplate0 libdbd-mysql-perl libgtkmm-2.4-1c2a libmysqlclient18 libtinyxml2.6.2 libzip2 mysql-client mysql-client-5.5 mysql-common mysql-server mysql-server-5.5 mysql-workbench mysql-workbench-data python-all python-mysql.connector python-pysqlite2 python-support 0 upgraded, 17 newly installed, 0 to remove and 0 not upgraded. Need to get 36.2 MB/38.7 MB of archives. After this operation, 126 MB of additional disk space will be used. Do you want to continue [Y/n]? Y Get:1 http://us.archive.ubuntu.com/ubuntu/ precise/main mysql-common all 5.5.22-0ubuntu1 [13.7 kB] Get:2 http://us.archive.ubuntu.com/ubuntu/ precise/main mysql-client-5.5 amd64 5.5.22-0ubuntu1 [8,298 kB] Get:3 http://us.archive.ubuntu.com/ubuntu/ precise/main mysql-server-5.5 amd64 5.5.22-0ubuntu1 [8,816 kB] Get:4 http://us.archive.ubuntu.com/ubuntu/ precise/main mysql-client all 5.5.22-0ubuntu1 [11.7 kB] Get:5 http://us.archive.ubuntu.com/ubuntu/ precise/main mysql-server all 5.5.22-0ubuntu1 [11.8 kB] Get:6 http://us.archive.ubuntu.com/ubuntu/ precise/universe mysql-workbench-data all 5.2.38+dfsg-3 [7,150 kB] Get:7 http://us.archive.ubuntu.com/ubuntu/ precise/universe mysql-workbench amd64 5.2.38+dfsg-3 [11.9 MB] Fetched 36.2 MB in 19s (1,875 kB/s) Preconfiguring packages ... Selecting previously unselected package libgtkmm-2.4-1c2a. (Reading database ... dpkg: warning: files list file for package `mysql-server-core-5.5' missing, assuming package has no files currently installed. dpkg: warning: files list file for package `mysql-client-core-5.5' missing, assuming package has no files currently installed. (Reading database ... 179822 files and directories currently installed.) Unpacking libgtkmm-2.4-1c2a (from .../libgtkmm-2.4-1c2a_1%3a2.24.2-1ubuntu1_amd64.deb) ... Selecting previously unselected package mysql-common. Unpacking mysql-common (from .../mysql-common_5.5.22-0ubuntu1_all.deb) ... Selecting previously unselected package libmysqlclient18. Unpacking libmysqlclient18 (from .../libmysqlclient18_5.5.22-0ubuntu1_amd64.deb) ... Selecting previously unselected package libdbd-mysql-perl. Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.020-1build2_amd64.deb) ... Selecting previously unselected package mysql-client-5.5. Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.22-0ubuntu1_amd64.deb) ... Processing triggers for man-db ... Setting up mysql-common (5.5.22-0ubuntu1) ... Selecting previously unselected package mysql-server-5.5. (Reading database ... dpkg: warning: files list file for package `mysql-server-core-5.5' missing, assuming package has no files currently installed. dpkg: warning: files list file for package `mysql-client-core-5.5' missing, assuming package has no files currently installed. (Reading database ... 179918 files and directories currently installed.) Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.22-0ubuntu1_amd64.deb) ... Selecting previously unselected package libctemplate0. Unpacking libctemplate0 (from .../libctemplate0_1.0-1_amd64.deb) ... Selecting previously unselected package libtinyxml2.6.2. Unpacking libtinyxml2.6.2 (from .../libtinyxml2.6.2_2.6.2-1build1_amd64.deb) ... Selecting previously unselected package libzip2. Unpacking libzip2 (from .../libzip2_0.10-1ubuntu1_amd64.deb) ... Selecting previously unselected package mysql-client. Unpacking mysql-client (from .../mysql-client_5.5.22-0ubuntu1_all.deb) ... Selecting previously unselected package mysql-server. Unpacking mysql-server (from .../mysql-server_5.5.22-0ubuntu1_all.deb) ... Selecting previously unselected package mysql-workbench-data. Unpacking mysql-workbench-data (from .../mysql-workbench-data_5.2.38+dfsg-3_all.deb) ... Selecting previously unselected package python-support. Unpacking python-support (from .../python-support_1.0.14ubuntu2_all.deb) ... Selecting previously unselected package python-mysql.connector. Unpacking python-mysql.connector (from .../python-mysql.connector_0.3.2-1_all.deb) ... Selecting previously unselected package python-pysqlite2. Unpacking python-pysqlite2 (from .../python-pysqlite2_2.6.3-2build1_amd64.deb) ... Selecting previously unselected package python-all. Unpacking python-all (from .../python-all_2.7.3-0ubuntu2_amd64.deb) ... Selecting previously unselected package mysql-workbench. Unpacking mysql-workbench (from .../mysql-workbench_5.2.38+dfsg-3_amd64.deb) ... Processing triggers for ureadahead ... Processing triggers for man-db ... Processing triggers for desktop-file-utils ... Processing triggers for bamfdaemon ... Rebuilding /usr/share/applications/bamf.index... Processing triggers for gnome-menus ... Processing triggers for shared-mime-info ... Setting up libgtkmm-2.4-1c2a (1:2.24.2-1ubuntu1) ... Setting up libmysqlclient18 (5.5.22-0ubuntu1) ... Setting up libdbd-mysql-perl (4.020-1build2) ... Setting up mysql-client-5.5 (5.5.22-0ubuntu1) ... Setting up mysql-server-5.5 (5.5.22-0ubuntu1) ... /var/lib/dpkg/info/mysql-server-5.5.postinst: line 50: /usr/sbin/mysqld: No such file or directory AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in /etc/apparmor.d/usr.sbin.mysqld at line 9: Could not open 'abstractions/mysql' start: Job failed to start invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.5 (--configure): subprocess installed post-installation script returned error exit status 1 Setting up libctemplate0 (1.0-1) ... Setting up libtinyxml2.6.2 (2.6.2-1build1) ... Setting up libzip2 (0.10-1ubuntu1) ... Setting up mysql-client (5.5.22-0ubuntu1) ... dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.5; however: Package mysql-server-5.5 is not configured yet. dpkg: error processing mysql-server (--configure): dependency problems - leaving unconfigured Setting up mysql-workbench-data (5.2.38+dfsg-3) ... No apport report written because the error message indicates its a followup error from a previous failure. Setting up python-support (1.0.14ubuntu2) ... Setting up python-mysql.connector (0.3.2-1) ... Setting up python-pysqlite2 (2.6.3-2build1) ... Setting up python-all (2.7.3-0ubuntu2) ... Setting up mysql-workbench (5.2.38+dfsg-3) ... Processing triggers for libc-bin ... ldconfig deferred processing now taking place Processing triggers for python-support ... Errors were encountered while processing: mysql-server-5.5 mysql-server E: Sub-process /usr/bin/dpkg returned an error code (1) Note: This was done in an Ubuntu 64 bit machine running in VirtualBox 4.1.14 r77440. It also worked prior yesterday prior to receiving two updates for openjdk, update-manger, and update-manager-core in case that helps! ProblemType: Package DistroRelease: Ubuntu 12.04 Package: mysql-server-5.5 5.5.22-0ubuntu1 ProcVersionSignature: Ubuntu 3.2.0-24.37-generic 3.2.14 Uname: Linux 3.2.0-24-generic x86_64 ApportVersion: 2.0.1-0ubuntu7 Architecture: amd64 Date: Fri May 18 12:57:58 2012 ErrorMessage: subprocess installed post-installation script returned error exit status 1 InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425) Logs.var.log.daemon.log: MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf: [mysqld_safe] syslog MySQLVarLibDirListing: ['debian-5.5.flag', 'mysql'] SourcePackage: mysql-5.5 Title: package mysql-server-5.5 5.5.22-0ubuntu1 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.5 (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-package need-duplicate-check precise -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1001354 Title: package mysql-server-5.5 5.5.22-0ubuntu1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1 on clean installation To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1001354/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs