LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   mysql in linux (https://www.linuxquestions.org/questions/linux-newbie-8/mysql-in-linux-910624/)

kumar Saurabh 10-28-2011 06:56 AM

mysql in linux
 
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 (Post 4510528)
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 (Post 4510622)
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.


All times are GMT -5. The time now is 07:41 PM.