LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-28-2011, 06:56 AM   #1
kumar Saurabh
LQ Newbie
 
Registered: Jun 2011
Location: Camerino
Distribution: 2.6.35-22-generic #33-Ubuntu SMP
Posts: 19

Rep: Reputation: Disabled
Unhappy 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
 
Old 10-28-2011, 07:00 AM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975
it says you've not got libaio. install libaio. simple.
 
Old 10-28-2011, 07:31 AM   #3
kumar Saurabh
LQ Newbie
 
Registered: Jun 2011
Location: Camerino
Distribution: 2.6.35-22-generic #33-Ubuntu SMP
Posts: 19

Original Poster
Rep: Reputation: Disabled
Thanks people...I have installed the libaio-dev and then it worked.


Quote:
Originally Posted by kumar Saurabh View Post
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
 
Old 10-28-2011, 09:32 AM   #4
Nylex
LQ Addict
 
Registered: Jul 2003
Location: London, UK
Distribution: Slackware
Posts: 7,464

Rep: Reputation: Disabled
Mark your thread as solved (using the "Thread tools" at the top). Also, there really was no need to quote your first post.
 
Old 10-28-2011, 11:22 AM   #5
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975
Quote:
Originally Posted by Nylex View Post
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
error in installing mysql i.e. mysql-5.1.34-linux-powerpc-glibc23 in centos 4.4 i686 pankajd Linux - Newbie 1 06-07-2009 02:00 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 03:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 09:37 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration