Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I purged my existing mysql-server from ubuntu and re-installed the same. This was due there was an upgrade from my ubuntu and I was unable to start my sql-server.

After cleaned up and taking backup of my data , I re-insalled mysql.

During installaion I received following message popup.

Unable to set password for the MySQL "root" user      
An error occurred while setting the password for the MySQL administrative user. 
This may have happened because the account already has a password, or   because of a communication problem with the MySQL server. 
You should check the account's password after the package installation.      
Please read the /usr/share/doc/mysql-server-5.5/README.Debian file for more
information.                                                                │    
                                                        │    

After the installation was failed, following error were received.

        121109 20:36:18 InnoDB: Initializing buffer pool, size = 128.0M
        121109 20:36:18 InnoDB: Completed initialization of buffer pool
        121109 20:36:18 InnoDB: highest supported file format is Barracuda.
        121109 20:36:18  InnoDB: Waiting for the background threads to start
        121109 20:36:19 InnoDB: 1.1.8 started; log sequence number 2395841
        ERROR: 130  Incorrect file format 'user'
        121109 20:36:19 [ERROR] Aborting

    121109 20:36:19  InnoDB: Starting shutdown...
    121109 20:36:20  InnoDB: Shutdown completed; log sequence number 2395841
    121109 20:36:20 [Note] /usr/sbin/mysqld: Shutdown complete

    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
    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
    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.5
     mysql-server
    E: Sub-process /usr/bin/dpkg returned an error code (1)
share|improve this question

closed as too localized by devav2, Jorge Castro, Ringtail, jokerdino, hexafraction Nov 10 '12 at 16:28

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
The problem fixed. I purged again and re-installed. This time, I didn't give password and installation was successful. –  Anand Nov 10 '12 at 4:58

Browse other questions tagged or ask your own question.