Comment 10 for bug 578357

I think, i have the same problem (even after 5 Trials, to install a fresh Lucid Lynx (Kubuntu) without the old /home-Folder).
My last error-log ($HOME/.local/share/akonadi/db_data/mysql.err) is this:

100728 8:12:58 [Note] Plugin 'FEDERATED' is disabled.
100728 8:12:59 InnoDB: Started; log sequence number 0 130014
100728 8:13:00 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100728 8:13:00 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100728 8:13:00 [Note] /usr/sbin/mysqld-akonadi: ready for connections.
Version: '5.1.41-3ubuntu11-log' socket: '/home/muelux/.local/share/akonadi/db_misc/mysql.socket' port: 0 (Ubuntu)

** First, akonadi came with:

Test 14: ERROR
--------

No resource agents found.
Details: No resource agents have been found, Akonadi is not usable without at least one. This usually means that no resource agents are installed or that there is a setup problem. The following paths have been searched: '/usr/share/akonadi/agents /usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to '/usr/share:/usr/share:/usr/local/share', make sure this includes all paths where Akonadi agents are installed to.

Test 16: ERROR
--------

Previous Akonadi server error log found.
Details: The Akonadi server did report error during its previous startup into <a href='/home/muelux/.local/share/akonadi/akonadiserver.error.old'>/home/muelux/.local/share/akonadi/akonadiserver.error.old</a>.

File content of '/home/muelux/.local/share/akonadi/akonadiserver.error.old':
Control process died, committing suicide!

*** I tried:

sudo apt-get install virtuoso-server mysql-server-5.1
rm -r $HOME/.local/share/akonadi
akonadictl start
mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/
mysql_upgrade --socket=$HOME/.local/share/akonadi/db_misc/mysql.socket
akonadictl stop
akonadictl start

*** after that it came with:

"akonadiserver" [out] "Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--socket=/home/muelux/.local/share/akonadi/db_misc/mysql.socket'
"
[akonadiserver] /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/home/muelux/.local/share/akonadi/db_misc/mysql.socket' (2) when trying to connect
[akonadiserver] FATAL ERROR: Upgrade failed
[akonadiserver] Failed to use database "akonadi"
[akonadiserver] Query error: "Unknown database 'akonadi' QMYSQL: Unable to execute query"
[akonadiserver] Database error: "Can't connect to local MySQL server through socket '/home/muelux/.local/share/akonadi/db_misc/mysql.socket' (2) QMYSQL: Unable to connect"
[akonadiserver] Trying to create database now...
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"

...]
### it creates a new database with log-messages (extract):

[akonadiserver] DbInitializer::run() done
[akonadiserver] skipping update 2
[akonadiserver] skipping update 3
[akonadiserver] skipping update 4
[akonadiserver] skipping update 8
[akonadiserver] skipping update 10
[akonadiserver] skipping update 12
[akonadiserver] skipping update 13
[akonadiserver] skipping update 14
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[akonadiserver] DataStore::unhideAllPimItems()
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
PLUGINS: "/usr/share/akonadi/agents"
PLUGINS: ("birthdaysresource.desktop", "contactsresource.desktop", "icalresource.desktop", "imapresource.desktop", "kabcresource.desktop", "kcalresource.desktop", "knutresource.desktop", "kolabproxyresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop", "maildispatcheragent.desktop", "mboxresource.desktop", "microblog.desktop", "mtdummyresource.desktop", "nepomukcalendarfeeder.desktop", "nepomukcontactfeeder.desktop", "nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "pop3resource.desktop", "vcarddirresource.desktop", "vcardresource.desktop")
search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games")
PLUGINS inserting: "akonadi_birthdays_resource" 0 ("Resource")
PLUGINS inserting: "akonadi_contacts_resource" 1 ("Resource")

### the last messages belongs to kmail, i guess:

[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(1849)/libakonadi Akonadi::DefaultResourceJob::slotResult: "Unknown resource"
[/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(1849)/libakonadi Akonadi::ResourceScanJob::Private::fetchResult: "Unknown resource"
[/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(1849)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_0" : "Unbekannter Fehler. (Unknown resource)"
[/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(1849) OutboxQueue::Private::localFoldersRequestResult: Failed to get outbox folder.
[/usr/bin/akonadi_nepomuk_contact_feeder] Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"

So, after two month of trial and error upgrading to Kubuntu 10.04 i think i have to give up ;-(