I recently installed Ubuntu 16.10 and was looking to install MySQL via sudo apt mysql-server mysql-client when I received the error "mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory." I discovered, however, that libaio1 had been installed via apt and the libaio.so.1 file existed in /lib/x86_64-linux-gnu along with libaio.so.1.0.1, as well as /media/ubuntu/casper-rw/upper/lib/x86_64-linux-gnu. I've purged the MySQL files and databases and retried with no success. How do I properly install MySQL? Thanks!
Try starting over utilizing a "
LAMP" tutorial to guide you. The sources below pertain to Ubuntu 16.04. There may now be new posts for Ubuntu 16.10.
LAMP Server is a collection of open source software used to create a web server. The collection consists of:
Linux – the operating system Apache server – the server MySQL – the database system PHP – the programming language
Quote above from: SudoJuice
The issue I was having wasn't a libaio library error but an apparmor error. The mysqld profile in Ubuntu's apparmor was too restrictive. I disabled apparmor's MySQLd profile using the tutorial here (http://www.cyberciti.biz/faq/ubuntu-linux-howto-disable-apparmor-commands/) and was able to successfully install and use the mysql-server! Thanks for all the help guys, and sorry I wasn't more clear on the issue.