Centos Custombuild mysql 5.5 won't start

[vpsnl]

Server setup:
Apache 2.2.17 Running
DirectAdmin 1.38.3 Running
Exim 4.72 Running
MySQL *** Stopped ***
Named 9.3.6 Running
ProFTPd 1.3.3e Running
sshd Running
dovecot 2.0.12 Running
Php 5.3.6 Installed

Error:
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/servername.net.pid).

I worked about it for 12 hours now and i am really stuck. The mysql server wont start:confused:

[vpsnl]

I can reinstall my vps that is done in a few minutes but i did it like 5 times and it still doesnt work. I followed this tut: http://help.directadmin.com/item.php?id=240, is het that hard to install mysql 5.5?

[scsi]

You should check the .err file to see what is causing the issue.

tail -200 /var/lib/mysql/servername.net.err

[vpsnl]

110512 21:49:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/sbin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
110512 21:49:12 mysqld_safe mysqld from pid file /var/lib/mysql/server.net.pid ended

[vpsnl]

Finally!

Starting MySQL.. SUCCESS!
-bash-3.2#

[DirectAdmin Support]

Hello,

As a followup, this would be related:
http://help.directadmin.com/item.php?id=368

I've added a relation from the id=240 guide to the id=368 to hopefully help others.

John

[vpsnl]

Yep, i found that threat and that was the key to let it work. After this i ran the mysql_upgrade -u root -p to update the tables's now everything works fine!