[SOLVED] mysql in linux

kumar Saurabh · 10-28-2011, 06:56 AM

Hi,

I am trying to install mysql to my newly installed ubuntu distribution. When I try to install test database and grants table, I got the following error..anyone can help me???

kumar@kumar-VGN-CR35G-L:/usr/local$ sudo mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
Installing MySQL system tables...
/usr/local/mysql/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

Installation of system tables failed! Examine the logs in
/usr/local/mysql/data for more information.

You can try to start the mysqld daemon with:

shell> /usr/local/mysql/bin/mysqld --skip-grant &

and use the command line tool /usr/local/mysql/bin/mysql
to connect to the mysql database and look at the grant tables:

shell> /usr/local/mysql/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /usr/local/mysql/data that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/local/mysql/scripts/mysqlbug script!

kumar@kumar-VGN-CR35G-L:/usr/local$ cd ..
kumar@kumar-VGN-CR35G-L:/usr$ cd ..
kumar@kumar-VGN-CR35G-L:/$ /usr/local/mysql/bin/mysqld --skip-grant &
[1] 2461
kumar@kumar-VGN-CR35G-L:/$ /usr/local/mysql/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

thanx

acid_kewpie · 10-28-2011, 07:00 AM

it says you've not got libaio. install libaio. simple.

kumar Saurabh · 10-28-2011, 07:31 AM

Thanks people...I have installed the libaio-dev and then it worked.

Quote:

Originally Posted by kumar Saurabh

Hi,

I am trying to install mysql to my newly installed ubuntu distribution. When I try to install test database and grants table, I got the following error..anyone can help me???

kumar@kumar-VGN-CR35G-L:/usr/local$ sudo mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
Installing MySQL system tables...
/usr/local/mysql/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

Installation of system tables failed! Examine the logs in
/usr/local/mysql/data for more information.

You can try to start the mysqld daemon with:

shell> /usr/local/mysql/bin/mysqld --skip-grant &

and use the command line tool /usr/local/mysql/bin/mysql
to connect to the mysql database and look at the grant tables:

shell> /usr/local/mysql/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /usr/local/mysql/data that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/local/mysql/scripts/mysqlbug script!

kumar@kumar-VGN-CR35G-L:/usr/local$ cd ..
kumar@kumar-VGN-CR35G-L:/usr$ cd ..
kumar@kumar-VGN-CR35G-L:/$ /usr/local/mysql/bin/mysqld --skip-grant &
[1] 2461
kumar@kumar-VGN-CR35G-L:/$ /usr/local/mysql/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

thanx

Nylex · 10-28-2011, 09:32 AM

Mark your thread as solved (using the "Thread tools" at the top). Also, there really was no need to quote your first post.

acid_kewpie · 10-28-2011, 11:22 AM

Quote:

Originally Posted by Nylex

Mark your thread as solved (using the "Thread tools" at the top). Also, there really was no need to quote your first post.

Dude, neither of these things matter.